Oracle-L: RE: Change based recovery

From: Venu Gopal <venu.andem_at_wipro.com>
Date: Thu, 07 Aug 2003 04:40:38 -0800
Message-ID: <F001.005C9728.20030807044038@fatcity.com>

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-----
Dobson, Lisa
Sent: Thursday, August 07, 2003 5:51 PM
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.

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Venu Gopal
  INET: venu.andem_at_wipro.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 Thu Aug 07 2003 - 07:40:38 CDT