Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: rman fun :), nightmare and long

RE: rman fun :), nightmare and long

From: <>
Date: Fri, 04 Oct 2002 05:53:28 -0800
Message-ID: <>

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

-----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:


Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (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

Original text of this message