Performing Oracle Disaster Recovery


Disaster recovery includes the restoration and recovery of the target database after the loss of the entire target database, all current control files, all online redo log files, all parameter files, and the recovery catalog database (if applicable).

To perform disaster recovery, the following backups are required as a minimum:
        Backups of data files
        Corresponding archived redo logs generated after the time of the backup
        At least one autobackup of the control file

Basic procedure:
        Restore an autobackup of the server parameter file.
        Start the target database instance.
        Restore the control file from autobackup.
        Mount the database.
        Restore the data files.
        Recover the data files.
        Open the database with the RESETLOGS option.