7 Replies Latest reply: Aug 26, 2014 9:59 PM by Hemant K Chitale RSS

    Cold backup For a ArchiveLog Database

    Prithwish Adhikari



      Could anyone please tell me the step by step process to perform a cold backup on a database that is running in ARCHIVELOG mode. I have found various links in this community as well as on other sites but none of them seem comprehensive to me as different sites say differently.


      The knowledge that I have , to take a cold backup , is as follows.


      1. Take a backup of datafiles, controlfiles and archived redo log files. Online redo log backups are not needed. Copy the files to tape.

      2. In case of a failure restore the files backed up to original location and recover the database. The archive logs would recover the database till the backup. The online redo log would recover since the backup.


      I know it is not as easy as that , so could anyone please tell me the necessary steps.