List,
I am in the middle of testing my backup procedures
and have come across something that I'm stuck on.
I've read through Velpuri's ver8 book and the Oracle
docs but am still having difficulties. I need to
restore an entire db from a hot backup, to another
server. The above mentioned book and docs address
restoring pieces/parts, but not the whole thing. I am
backing up datafiles, archived log files and control
file to file and trace. No online redo logs.
- I restore datafiles and archived redo logs.
- Edit init file, startup nomount
- Create control file resetlogs (I tried the binary
one too)
- recover database until cancel using backup
controlfile.
It just keeps asking for log files. If I cancel and
open with resetlogs its says my system file still
needs media recovery.
So, is a hot backup an appropriate means of
recovering a database to another server? My cold
backups are only every quarter, so rolling forward
would be doable but tedious. Any ideas or
suggestions?
Thanks
Joe
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at
http://shopping.yahoo.com
or bid at
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Joe Hatchel
INET: joe_hatchel_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Dec 20 2001 - 14:56:23 CST
