Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Change based recovery
Lisa,
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 bytesDatabase mounted.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hand, Michael T
INET: HANDM_at_polaroid.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 Fri Aug 08 2003 - 11:09:36 CDT