Re: Why ask more ?

You're using a backup controlfile. If you want to recover the database with your existing files you'll have to do a recover using backup cont* until [cancel, time, or scn].

Dave Turner

On Sat, 2 Sep 2000, Slamet Fusianto wrote:

> 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,
>
> Slamet Fusianto
>
>
>
> --
> Author: Slamet Fusianto
> INET: yangken_at_cbn.net.id
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Sep 04 2000 - 14:52:23 CDT