Answer Posted / shabbeer.ahmad

A hot backup is basically taking a backup of the database
while it is still up and running and it must be in archive
log mode. A cold backup is taking a backup of the database
while it is shut down and does not require being in archive
log mode. The benefit of taking a hot backup is that the
database is still available for use while the backup is
occurring and you can recover the database to any point in
time. The benefit of taking a cold backup is that it is
typically easier to administer the backup and recovery
process. In addition, since you are taking cold backups the
database does not require being in archive log mode and thus
there will be a slight performance gain as the database is
not cutting archive logs to disk.

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1887

---

how can a session indicate its interest in receiving alerts?

982

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1024

---

What the different components in replication and what is their use? : sql server DBA

1001

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

975

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1041

---

What purpose does the model database server? : sql server DBA

1099

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1705

---

Query processing is slow(eg select query)how will u solve that

7763

---

what do you understand by fine-grained auditing?

1015

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2401

---

Explain about your sql server dba experience? : sql server DBA

1024

---

What authentication modes does sql server support? : sql server DBA

1140

---

What are the recovery models for a database? : sql server DBA

1068

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4290

---