| 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: rman fun :), nightmare and long
Joe - You da man. An impressive tour de force in working around RMAN. Was
your last statement rhetorical? I think you answered that question - that
you didn't have the right control file. Impressive that you were able to
creatively work around the obvious limitation. This is the reason we test
recovery scenarios, so that before the real disaster you've figured out that
you need to back the control file up separately. Congratulations.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, October 03, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L
Ok so the qa environment we've been fooling around with rman for testing backup/recovery.
tonite they say " we want a backup restored from rman from 2 incarnations ago(for those of u who dont know what an incarnation is, its a new version of the database that gets created when you do open resetlogs <-- if thats wrong please RMAN gurus correct me.
So I get out the book, the docs say "in the event you have to do this, which
should be rare", you must do the
"reset database to incarnation" command.
seems easy enough, fire up rman, startup nomount, reset incarnation and it finds the old backups, and starts the restore.
so far so good, but then the catch, being a rman newbie(8.1.7), i forgot to make a controlfile backup, now if i'd had that, this should have been cake,restore the control file in nomount mode, mount and restore the datafiles, recover the datafiles and open resetlogs, did i forget to say, this is a NOARCHIVELOGMODE database.
Well, for whatever reason, the database wouldnt open, due to using a newer controlfile.
hmmm, i've done this before, i'll just dump the controlfile to trace(yes i did this BEFORE the restore, just in case of an actual emergency).
rebuild the control file, try the recover again(did i say we're going to a particular SCN based on the info from list backup/list incarnation commands), no deal, damn database will not open.
regroup, wait a minute, rman aint anything special, let's do this:
restore the files from rman backup again.
exit rman
sqlplus: recover database until scn #######;
alter database open resetlogs;
rman: <check> resync catalog;
CHOKE, but i expected that,
rman: reset database;
full catalog sync AND
we're good to go.
Where did go wrong in using RMAN to do the recover/restore ???
joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.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 Thu Oct 03 2002 - 22:58:18 CDT
 |
 |