RE: Hot Backup Recovery Scenario

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Thu, 20 Dec 2001 14:15:24 -0800
Message-ID: <F001.003E1405.20011220133111@fatcity.com>

By the way, those instructions to manually creating a hot standby database came from Oracle so they should be available online. There should be a hint in there that would give you an idea of what you are missing since its really the same thing except you are not staying in recovery mode.

-----Original Message-----
Smith
Sent: Thursday, December 20, 2001 1:06 PM To: Multiple recipients of list ORACLE-L

I have not specifically tried what you are trying to do recently, however, I did implement a standby database using Trusted Oracle 7 in which you had to do it manually. So it should work. You really do need redo logs though. Although you do not specifically need the ones from your other database they need to be in the same location and have the same file name, unless you specifically alter that.

What I would do is move over the redo logs as well and open with resetlogs after recovery. But that is cause I am lazy and don't want to recreate them over there.

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

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------