Backup & Recovery

From: xiaomh <xiaomh_at_hotmail.com>
Date: Tue, 5 Feb 2002 09:45:09 -0500
Message-ID: <a3orab$a12$1@news.gov.on.ca>

Hi, there:

I download a lot of Oracle Documents and try to find something I needed. But I couldn't get the points. Acutally what I need is just following:

A1) Cold Whole Database Backup & Recovery

        a1) Shut down DB immediate(OEM console)
        a2) Copy and backup all datafiles(*.dbf), all control files(*.ctl)
(Operating System)
        a3) Startup and Open DB(OEM console)
        a4) Drop a table
        a5) Stop Database Service(Control Panel)
        a6) Shut down DB immediate(OEM console)
        a7) Copy back all backup datafiles, control files
        a8) Start Database Service(Control Panel)
        a9) Open Database(OEM console)(ERROR here ????)

Q1) What I am trying to do is to recover the table I dropped, but when I Open Database(a9). I got the error, saying Redo log has more recent SCN than control files. If I didn't backup Redo logfiles, what should I do now?

Thanks Received on Tue Feb 05 2002 - 08:45:09 CST