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 ACTIVE
1,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" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
