| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Why ask more ?
Yes, the
recover database until cancel
can be cancelled out of and the database opened.
We do:
recover automatic using backup controlfile;
This runs out of archived log.
cancel
alter database open
would fail,
so the script has:
cancel
recover until cancel using backup controlfile;
cancel
alter database open resetlogs;
This works.
> Couldn't he just type
>
> recover database using backup controlfile until cancel?
>
>
> Dave Turner
>
>
> On Sun, 3 Sep 2000, Tom Pall wrote:
>
> > Since it is a backup control file, it cannot have a complete record of each archived redo log
> > generated by the database. It's a backup, taken who knows when. As a backup, it knows where
> > all the data files are and the destination for the archive logs. It also knows the start and stop SCNs
> > of _some_ of the archived redo logs.
> >
> > Recovery with a backup control file will go on forever unless you stop it. Since you did not stop it,
> > it recorded that it asked for the next archive log, did not get it yet. Recovery does not know if there is
> > or is not such a log file, so it just waits for you to provide it. Recovery cannot know that it has recovered
> > as much as possible. Therefore, recovery is not complete.
> >
> > When you tried to open the database, Oracle refused. Recovery is not over, just waiting for the next
> > archive log file to appear.
> >
> > In order to open the database, you need to recover the database again without specifying BACKUP CONTROLFILE,
> > then cancel it. You will not run out of archive this time.
> > When you cancel it, you are telling recovery that is as far as you want to recover.
> > The cancel you issued during the first recovery had a different meaning.
> > It said you want to stop recovery until you find the next archive log file or come back from lunch.
> >
> > I recently took the Backup and Recovery seminar and brought this very scenerio up to my instructor.
> > He gave me the explaination I just gave you.
> >
> > I have a reporting database which gets created every morning by placing a production database in hot backup
> > mode, breaking a third mirror of the volumes, taking the database out of hot backup mode. I do a bunch of log
> > switches in production and copy the archive logs and binary copy of the control file to the broken third mirror.
> >
> > The broken third mirror now comprise the volumes of another box. I start up Oracle in this box and recover the database
> > using backup controlfile. Recovery runs out of archive logs, asks for the next one. Recovery is cancelled and restarted.
> > This time, without specifying BACKUP CONTROLFILE. Recovery is cancelled, the database is opened for business.
> >
> > ----- Original Message -----
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Sent: Sunday, September 03, 2000 1:53 AM
> >
> >
> > > 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).
> >
> > --
> > Author: Tom Pall
> > INET: tom_at_cdproc.com
> >
> > 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).
> >
>
> --
> Author: David Turner
> INET: turner_at_tellme.com
>
> 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
Received on Mon Sep 04 2000 - 17:44:01 CDT
 |
 |