Re: Incomplete recovery not working...

On Thu, 07 Jun 2007 12:32:45 -0700, eAddict <eAddict_at_gmail.com> wrote:

>After I restored the database I tried:
>
>1. startup mount
>2. recover database until cancel using backup controlfile
>3. issue a "cancel" (because I do not have any archived redo logs
>from
> the last backup to the point of failure)
>4. alter database open resetlogs
>
>But I get this:
>
>ORACLE instance started.
>
>Total System Global Area 3258008584 bytes
>Fixed Size 726024 bytes
>Variable Size 1207959552 bytes
>Database Buffers 2048000000 bytes
>Redo Buffers 1323008 bytes
>Database mounted.
>SQL> recover database until cancel using backup controlfile;
>ORA-00279: change 6934091358 generated at 06/03/2007 17:09:39 needed
>for thread
>1
>ORA-00289: suggestion : /oracle/BPR/saparch/BPRarch1_26547.dbf
>ORA-00280: change 6934091358 for thread 1 is in sequence #26547
>
>Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
>cancel
>ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get
>error below
>ORA-01195: online backup of file 1 needs more recovery to be
>consistent
>RA-01110: data file 1: '/oracle/BPR/sapdata1/system_1/system.data1'
>
>
>ORA-01112: media recovery not started
>
>SQL> alter database open resetlogs;
>alter database open resetlogs
>*
>ERROR at line 1:
>ORA-01195: online backup of file 1 needs more recovery to be
>consistent
>ORA-01110: data file 1: '/oracle/BPR/sapdata1/system_1/system.data1'
>
>-----------
>I don't have access to that archive log file. How can I get past the
>error?
>Thanks!
>Vince

Find out, using v$log and v$log_file to which *online redolog* sequence 26547 is pointing.
Then specify *that* file in recover database. If you don't have that file, I would suggest holding a strong magnet in the neighbourhood of the drive.
You aren't running SAP in noarchivelog, are you?

-- 
 
Sybrand Bakker
Senior Oracle DBA