Re: Recovery from online backups/archived logs on another system

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Wed, 14 Apr 2004 23:41:43 +0300
Message-ID: <08d201c42260$e5c2f320$48f923d5@porgand>

>From 9i docs:

---

RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE Note:
If you fail to specify the UNTIL clause on the RECOVER command, then you will not be able to open the database until a complete recovery is done.

---

So, you can do a decent incomplete recovery using the "until" option only (until cancel, until time, until change).

Tanel.

> I ran into this exact problem about 18 months ago. MetaLink
> Note:183367.1 resolved my problem. Specifically section "IV. WHEN
> RECOVERING ' USING BACKUP CONTROLFILE' OPTION TO DO INCOMPLETE
> RECOVERY".
>
> SQL> startup mount;
> SQL> recover database using backup controlfile until cancel;
> Apply existing archived redo log files as prompted; type CANCEL when no
> more exist on disk
> SQL> alter database open resetlogs;

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Apr 14 2004 - 15:39:21 CDT