Listen Software’s How To: Performing an Incomplete Recovery

Creating the Backup Control File

SQL:

alter database 
   backup controlfile 
   {path&name} reuse

Recover the Database using the Backup Control File

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

  2. Start the database up in Mount Mode.

    SQL:

    startup pfile="d:orantdatabaseinitsid.ora" mount
  3. SQL:

    recover until cancel 
       using backup controlfile
  4. 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.

  5. SQL:

    alter database open resetlogs

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles