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