Actually, Velpuri explains precisely why do you need to do that.
Backup controlfile does not contain last SCN, so one has to do
recovery to bring all datafiles to the same SCN. As there is always
a possibility that log files have some other SCNs, they need to be reset
and cleaned or those SCNs will end up in database during the next
instance recovery (not necessarily media recovery).
If you put RMAN into the mixture, be aware that when one does "alter
database open resetlogs", he ends up with a new database incarnation
which is no longer registered and needs to be synchronized. In other
words, you will not be able to perform backups until your database is
re-registered.
On Mon, 2003-10-06 at 14:49, Govindan K wrote:
> Hi Scott
>
> Answer to Question 1 (answers Question 2, 3 too).
> Bkp & Rcvry by Rama Velpuri - Case 8:Recovery with a Bkp control file
> <quote>
> If you use a backup control file, you need to perform media recovery.
> Also, Oracle will force you to use the 'using backup controlfile'
> option.
> Once recovery is done, you must start up the database with the
> RESETLOGS
> option, and have to take a complete backup of your database. The
> reason
> for this is that, Oracle needs to update certain data structures in
> the
> backup controlfile before opening the database, and this is done
> during
> RESETLOGS. After the database is open, you should immediately take a
> full online or offline backup of the database because you cannot
> restore
> any of the datafiles from before RESETLOGS and try to rollforward.
> </quote>
>
> The book is arguably one of the BEST written on Oracle Backup and
> Recovery ever.
> Better get one.
>
> HTH
> GovindanK
> <-----Original Message----->
>
>
> From: scott scott
> Sent: 10/6/2003 2:37:24
> AM
> To:
> ORACLE-L_at_fatcity.com
> Subject: Re: Basic
> question about
> controlfile recovery
>
> Listers,
>
> sorry for this basic
> questionnare.
>
> ...was reading the RMAN
> B&R docs (9iR2).got
> these
> doubts and thought of
> claryfying it with u
> experts.
>
> Q1.after a controlfile
> recovery from backup,is
> "open
> resetlogs" always
> necessary ?
>
> Q2.is there any
> scenario,where "open
> resetlogs" is not
> necessary after
> controlfile recovery ?
>
> Q3.i have backup ( one
> day old ) of all my
> datafiles/archivelogs/controlfile.now,when all my
> controlfiles are lost
> with online redologs
> intact,
> is complete recovery
> possible ? if so, is
> "open
> resetlogs" reqd. & why
> ?
>
> Please enlighten me.
> i'll c! ontinue
> RTF(ine)M.
>
> Regards,
> Scott.
>
>
>
>
> Author: scott scott
> INET:
> orababies_at_yahoo.com
>
>
> _______________________________________________________________
> Get Your 10MB account for FREE at http://mail.arabia.com !
> [image]Access MILLIONS of JOBS NOW!
--
Mladen Gogala
Oracle DBA
Note:
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mladen_at_wangtrading.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Oct 06 2003 - 14:09:30 CDT
