| 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
The controlfile gets backed up automatically when you do a RMAN full backup.
I have been having a debate this morning regarding a situation where we do
weekly full backups using RMAN and and a daily RMAN "archivelog all delete
input".
I contend we should do a "archivelog all delete input INCLUDING controlfile". My colleague states that this is only of value for when all controlfiles are lost. (which we both agree is highly unlikely but possible).
I am asured that if we had no controlfile available we could "restore controlfile" and it would go back to the copy it has which could be 1 week old and then roll forward (after calling restore database). RMAN would apply any changes necessary (of which there would be none in this scenario) and create an updated copy of the current controlfile)
So Joe, you only needed a copy of the control file because of the scenario
you were running and you would not need to take a specific copy in the
normal run of events? Is my understanding correct?. I know that no
recovery/DR scenario can be considered normal but I am particularly
interested if any situation where we need to recover from the last backup
either a full database to a SCN or point in time or recover a single
datafile
Thanks
John
-----Original Message-----
Sent: 04 October 2002 12:58
To: Multiple recipients of list ORACLE-L
Connor, my problem(fault) was I didnt make a copy of the control file(and in 8.1.7, you don't get it backed up by default like in 9i, right?).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: John.Hallas_at_vodafone.co.uk
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 Fri Oct 04 2002 - 08:53:28 CDT
 |
 |