Nice Tips About How To Restore Oracle Cold Backup

The restore key dialog box appears.

How to restore oracle cold backup. Afterwards click on “start restore” and. Sql> alter database backup controlfile to trace as '/tmp/dk.sql' resetlogs; Copy the trace file from the source server to the destination server.

Select the time you want to restore to and the databases you want to restore. Restore the control file from cold backup; To perform the oracle backup:

Recover control file with cold backup. Sql> shutdown immediate sql> !cp /u03/coldbkp/*.ctl /datafiles/prod sql> startup. If you are running regedit instead of regedt32, select import registry file.

In order to get this database available i have taken the following steps: Here are the steps involved in this procedure: At the rman prompt, connect.

The generalized procedure for using a cold. Click on the tray icon and select “restore components”: ( same os, same oracle version ) step 1 :

A cold backup, that is, one done with the database in a shutdown state, provides a complete copy of the database that can be restored exactly. We also got both the database name and the passwords for the database. Make sure that the database is in mount state.