Re: Backup & Recovery

If you really are sure that you want to revert to this backup you can reset the logs. Do a "startup mount;" and then issue an "alter database open resetlogs;". This will through away all info in your logfiles and start with clean logs. You will probably have to do this in sqlplus or svrmgr not OEM.

Kind Regards

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"xiaomh" <xiaomh_at_hotmail.com> wrote in message news:a3orab$a12$1_at_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 - 09:42:51 CST