Answer / kittu_chintu2005

Startup mount
Alter database archive log;
Alter database begin backup;
Alter tablespace ts_name begin backup;
Copy the *.dbf & *.ctl files @ os level when copying completed issue the statement “alter database end backup;”

Answer / nagesh yadav

1)Database should be in archivelog mode
2)we can take the hot backup at tablespace level or database
level
3)when we kept in begin backup mode performance will be poor
so take the backup at tablespace level.
4)alter tablespace tablespace_name begin backup; OR
5)alter database begin backup;
Note:- Don't add datafiles in begin backup
select status from v$backup;
If status is active means its is in begin backup mode.

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

what is a user-defined lock?

0 Answers   Oracle,

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---