Re: !!! database recovery HELP!!!

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 07 Jun 2003 10:00:55 +0200
Message-ID: <dr63evggb0kk7ji5cgalbbetjg1ulidle7@4ax.com>

On Sat, 7 Jun 2003 09:12:45 +0400, "qwerty" <qqq_at_qqq.qqq> wrote:

>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 !
>
>
>
>

recover database using backup controlfile until cancel (do NOT use autorecovery in this situation)

Please always post *EXACT* error messages and do NOT PARAPHRASE them. It is making your post incomprehensible and rambling.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jun 07 2003 - 03:00:55 CDT