RE: Hot Backup Recovery Scenario

From: Steve McClure <smcclure_at_usscript.com>
Date: Thu, 20 Dec 2001 15:49:26 -0800
Message-ID: <F001.003E15D9.20011220152528@fatcity.com>

Most of what you describe seems like it should work. One question. Why create a control file at step 3? Did you backup a control file to a filename, and back it up during your hot backup procedure? If so, you need to use it to recover your database. I don't think you can create a control file with a database that needs recovery and then use it to recover the database.

I have duplicated a database from one machine to another using a hot backup before. I used the following steps.

1.perform a hot backup of database on machine A.
2.shutdown database on machine A.
3.copy online redo logs and control files from Machine A to Machine B.
4.restart database on Machine A.
5.restore datafiles from hot backup to Machine B.
6.copy init files from Machine A to Machine B
7.issue a recover database on Machine B.

Hope This Helps,
Steve McClure
-----Original Message-----
Sent: Thursday, December 20, 2001 12:42 PM To: Multiple recipients of list ORACLE-L

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  INET: smcclure_at_usscript.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 - 17:49:26 CST