Why ask more ?

From: Slamet Fusianto <yangken_at_cbn.net.id>
Date: Sun, 3 Sep 2000 12:48:57 +0700
Message-Id: <10607.116124@fatcity.com>

Dear DBA,

Today I tried a recovery scenario which use BACKUP CONTROFILE. My condition is like this:
1. Backup data using COLD BACKUP

2. Startup the database and create new table and insert 1 record to it. Commit the transaction.

3. I then issue ALTER SYSTEM SWITCH LOGFILE (generate 3 Archived Log file, 50 - 52). If I see in ARCHIVE LOG LIST the next log file to be archived is 53 (it means the current active sequence is 53).

4. I then shutdown the database (use SHUTDOWN IMMEDIATE)

5. I copy the CONTROLFILE from COLD BACKUP to simulate failure database.

6. STARTUP MOUNT, RECOVER DATABASE USING BACKUP CONTROLFILE. What I do not understand why does Oracle ask for archived log file no 53, but in fact it has not been ARCHIVED (in LOG_ARCHIVE_DEST folder there are only 3 files LOG_50, LOG_51,L LOG_52) . 7. I can not open the database ! ALTER DATABASE OPEN RESETLOGS, it will issue ORA-01113 (needs media recovery) and ORA-01110.

Would someone tell me what is wrong with this ? Am I missing something in the recovery scenario ? Thank you.

Have a nice day.

Regards, Received on Sun Sep 03 2000 - 00:48:57 CDT