Message-Id: <10607.116124@fatcity.com> From: "Slamet Fusianto" Date: Sun, 3 Sep 2000 12:48:57 +0700 Subject: Why ask more ? 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,