Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Change based recovery

RE: Change based recovery

From: Hand, Michael T <>
Date: Fri, 08 Aug 2003 08:09:36 -0800
Message-ID: <>

The 3rd option (besides shuting down source database and using a controlfile trace) is to "alter database backup controlfile to 'filename'; ", use this file, then proceed with the recovery as Venu suggests. I've used this method on a hot backup to roll the database forward. Also, don't bother restoring the redo logs as you will be overwriting / recreating them with the "alter database open resetlogs". One more thing I noticed. Your until change number looks to me like an archive sequence number rather than the SCN it needs to be. Hope this helps.  

Mike Hand

-----Original Message-----
Sent: Thursday, August 07, 2003 8:21 AM
To: Multiple recipients of list ORACLE-L

Hi Guys and Gals,
We are currently doing some testing to enable us to move our production database from one unix box to another.
We are running a 7.3.4 db in archivelog mode. The approach that management want to use is to restore the database on the new server from a backup and then roll it forward using the archived redo logs.  

I have a full cold back up from last Friday. I have restored the datafiles, controlfiles and redo logs onto our test server from the backup tape, and then ftp'd the archived logs over.  

I then do -
SVRMGR> startup mount
ORACLE instance started.

Total System Global Area     258304260 bytes
Fixed Size                       45092 bytes
Variable Size                126925024 bytes
Database Buffers             131072000 bytes
Redo Buffers                    262144 bytes
Database mounted.
SVRMGR> recover database until change 10349; Media recovery complete.  


Please see the official ORACLE-L FAQ:

Author: Hand, Michael T

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 Aug 08 2003 - 11:09:36 CDT

Original text of this message