Re: HELP! recovery problem

From: Jurij Modic <jmodic_at_src.si>
Date: Sun, 24 Oct 1999 00:00:23 GMT
Message-ID: <38134798.9800524@news.siol.net>

On Sat, 23 Oct 1999 22:23:07 +0100, Jörg Rübensam <joerg.ruebensam_at_ivz.de> wrote:

>Dear Erwin,
>
>thanks for your advice. I tried with the cancel-option which affected the
>same result. So the question is, how to tell oracle that another log sequence
>number is current.
>
>Does anybody have an idea ?
>
>(We actually mirrored the the controlfile three times but a co-worker did a
>'complete' job destroing the structure of ALL disks... :-( )

Jörg,

You are correct, if you restored all the files from a cold backup (including redo logs) then database is in a consistent state and it can't perform a recovery.

You must tell Oracle that you are using controlfile from a backup. In your case you should restore datafiles and controlfiles from your backup (BTW, you don't have to restore redo logs), and then perform the following:

1.STARTUP MOUNT; 2.RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE; 3.Apply archived redo logs until you choose to CANCEL

4.ALTER DATABASE OPEN RESETLOGS; 5.Perfor complete database backup.

>Thanks
>
>Joerg

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Sat Oct 23 1999 - 19:00:23 CDT