Listen Software Solutions' "How To" Series:
Performing an Incomplete Recovery
By David Nishimoto
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
|
