RE: Change based recovery

[Venu Gopal]

Hi,   When you are restoring from a cold backup you don’t have to recover and your database will be old.   If you want to bring it to current time then recreate the control file and recover it using ‘RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL’; this will ask you for archive logs and then you have to supply them.   Create the control file from a trace file generated on the running database using the following command: ‘ALTER DATABASE BACKUP CONTROLFILE TO TRACE’;   Cheers! Venu   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dobson, Lisa Sent: Thursday, August 07, 2003 5:51 PM To: Multiple recipients of list ORACLE-L Subject: Change based recovery   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.    I would have expected it to display the names of the logs, but  it doesn't, and when I check the alert log it shows 'No Media Recovery required'.    Where am I going wrong? I can't understand why it won't apply the archived logs. (Too hot today and brain not working properly!)   TIA. Lisa Dobson Database Analyst Home Group Ltd -------------------------------------------------------------------------------------------------------------------- This message is intended only for the use of the person(s) ("Intended Recipient") to whom it is addressed. It may contain information, which is privileged and confidential. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient, please contact the sender as soon as possible. ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ **************************Disclaimer************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ***************************************************************************