What is cold backup? What are the elements of it?

 Cold backup is taking backup of all physical files after normal shutdown of database.  We need to take.     - All Data files.     - All Control files.     - All on-line redo log files.     - The init.ora file (Optional)
  • Interview Candidate
  • 2
  • 1703

Showing Answers 1 - 2 of 2 Answers

cmanne

  • Jan 4th, 2006
 

A cold backup is taken after shutting down the database Cold backup contains the following files--Data Files--Redolog Files--Control File(s)

  Was this answer useful?  Yes

Ravi Prakash Pichika

  • Jun 20th, 2006
 

A backup of one or more database files taken while the database is closed. Typically, closed backups are also whole database backups. If you closed the database cleanly, then all the files in the backup are consistent.

SQL>SHUTDOWN IMMEDIATE (or) NORMAL

 

 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions