Oracle Developer Jr - READY TO HIRE! Next Step Systems US-CA-Thousand Oaks Post A Job | Post A Resume

Database Recovery

Creating the Backup Control File

Step 1: SQL=alter database backup controlfile {path&name} reuse

Recover the Database using the Backup Control File

Step 1: Use the Backup Control File as the control file name in the initialization file.

Step 2: Start the database up in Mount Mode.
SQL=startup pfile="d:\orant\database\initsid.ora" mount

Step 3: SQL=SQL=recover until cancel using backup controlfile

Recovery until a stable state. The problem with archive files is that they can put
your tablespace in a state that needs further recovery. Recovery until cancel
allows you to achieve an incomplete recovery and start your database.

Step 4: SQL=alter database open resetlogs

Back to the LSS "How To" Series Main Page