Oracle-L: RE: Change based recovery

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Thu, 07 Aug 2003 04:40:30 -0800
Message-ID: <F001.005C9727.20030807044030@fatcity.com>

Lisa,

Shut down your production database and FTP the control files over also. This will make your control files waaayyy ahead of your data files, thus forcing a recovery.

Right now, your database does not need recovery - everything is in synch. Your control files don't know anything about the archive logs because they are set back to last Friday - thus they cannot move beyond that.

Good Luck!

Tom Mercadante
Oracle Certified Professional

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

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>

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

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