Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hot Backup Recovery Scenario
You can find out what the current logfile is and then apply the previous ones:
MIKEK:system> select a.group#,a.member,a.status,b.status,b.bytes
2 from v$logfile a, v$log b
3 where a.group# = b.group#
4 /
GROUP# MEMBER STATUS STATUS BYTES ---------- ---------------------------------------- --------- --------- ---------------- 1 C:\ORACLE\ORADATA\MIKEK\REDO01A.LOG ACTIVE 1,048,576 1 C:\ORACLE\ORADATA\MIKEK\REDO01B.LOG ACTIVE 1,048,576 2 C:\ORACLE\ORADATA\MIKEK\REDO02A.LOG ACTIVE 1,048,576 2 C:\ORACLE\ORADATA\MIKEK\REDO02B.LOG ACTIVE 1,048,576 3 C:\ORACLE\ORADATA\MIKEK\REDO03A.LOG CURRENT 1,048,576 3 C:\ORACLE\ORADATA\MIKEK\REDO03B.LOG CURRENT 1,048,576 4 C:\ORACLE\ORADATA\MIKEK\REDO04A.LOG ACTIVE 1,048,576 4 C:\ORACLE\ORADATA\MIKEK\REDO04B.LOG ACTIVE1,048,576
recover database until cancel;
apply logfiles C:\ORACLE\ORADATA\MIKEK\REDO01A.LOG and C:\ORACLE\ORADATA\MIKEK\REDO02A.LOG. alter database open resetlogs;
Mike
>From: "Kimberly Smith" <ksmith2_at_myfirstlink.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Hot Backup Recovery Scenario
>Date: Thu, 20 Dec 2001 13:05:40 -0800
>
>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.
> 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: 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: mwkillough_at_hotmail.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:03:05 CST
![]() |
![]() |