RE: Hot Backup Recovery Scenario

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Thu, 20 Dec 2001 16:29:21 -0800
Message-ID: <F001.003E1681.20011220161022@fatcity.com>

Um, that brings up another point. What are you using for your recovery command. If you are not using the control file you have to tell it you are using a backup control file or it simply will never know where to end.

-----Original Message-----

McClure
Sent: Thursday, December 20, 2001 3:25 PM To: Multiple recipients of list ORACLE-L

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.

1. I restore datafiles and archived redo logs.
2. Edit init file, startup nomount
3. Create control file resetlogs (I tried the binary one too)
4. 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).
--

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

Author: Kimberly Smith
  INET: ksmith2_at_myfirstlink.net

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 - 18:29:21 CST