Re: !!! database recovery HELP!!!

Fyi... depending on what the EXACT error message was, but an error like "file 1 system01.dbf needs recovery" (not exact message) when your database or server crashes during a hot/online backup, might not need recovery from backups.

If this ever happens again, you might want to make sure before doing a recover from your backups. In this particular case I noted, all I had to do was "recover database" and it brought the database to a consistent state just using the online redo logs... sorta the same thing that happens when you issue a "shutdown abort" . At least that is the best/easiest way I can describe it. Other usual posters here can probably explain this better.

Anyway, too late for you this time, IF this was your error. Always good to post those error messages exactly as they appeared...

-- 

"qwerty" <qqq_at_qqq.qqq> wrote in message news:bbrs01$lul$2_at_Sonix.atnet.ru...


> help me if you can

> last day databse failed to open

> data file system01.dbf is inconsistent so i recovered day before yesteday

> backup and now i wanted to apply archive yestaday logs

> i used the folloing commands in SQLPLUS:

> set autorecovery on

> recover database

> and it said that it doesnt required to recover 'cuz databse is ok

> then i checked archivelogs with this command :

> archive log list

> and it doesnot see the new archived logs

> how do i make recovery procedure see that new archived logs

> so i can apply new logs to day before yestaday database ???

> HELP please !

>

>

>

>

>