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:\orant\database\initsid.ora" mount

3. 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.

4. SQL:

   alter database open resetlogs