Re: Interesting but URGENT Case: Online Backup which never gets consistent

Are you sure you got the redo generated during the backup?

After doing all the backup commands and before copying to the other machine, do the following command:

   ALTER SYSTEM ARCHIVE LOG CURRENT This will generate 1 more archived redo that will have in it what you need for a consistent state. This is what Richard Foote was talking about in his 2nd post.

Note: Copying the REDOxxx.log files are of no use for what you are doing.

-- 
"Eric Tallas" <user_at_example.net> wrote in message
news:fdPqb.6$_47.809_at_se2-fa199-9.gva.ch.colt.net...


> Richard Foote wrote:

>

> > Ooooppps, something I forgot to mention.

> >

> > After you performed your online backup, did you make sure you archived

the


> > current online redo log and copied it across as well ?

> >

> > You'll need all the redo logs generated during the backup to ensure that

the


> > database can resync itself. And that'll hence include the current online

> > redo as well.

>

> I copied all the redo logs and archived redo logs to the other machine.

> That's what happens when I do an incomplete recovery:

>

> SQL> recover database until cancel;

> ORA-00279: change 566155031 generated at 11/07/2003 04:37:05 needed for

> thread

> 1

> ORA-00289: suggestion : /opt/oracle/arch/DB/arch_1_6426.arc

> ORA-00280: change 566155031 for thread 1 is in sequence #6426

>

>

> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

>

> ORA-00279: change 566156031 generated at 11/07/2003 04:46:33 needed for

> thread

> 1

> ORA-00289: suggestion : /opt/oracle/arch/DB/arch_1_6427.arc

> ORA-00280: change 566156031 for thread 1 is in sequence #6427

> ORA-00278: log file '/opt/oracle/arch/DB/arch_1_6426.arc' no longer needed

> for this recovery

>

>

> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

>

> ORA-00279: change 566156864 generated at 11/07/2003 05:06:46 needed for

> thread

> 1

> ORA-00289: suggestion : /opt/oracle/arch/DB/arch_1_6428.arc

> ORA-00280: change 566156864 for thread 1 is in sequence #6428

> ORA-00278: log file '/opt/oracle/arch/DB/arch_1_6427.arc' no longer needed

> for this recovery

>

>

> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

> cancel

> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error

> below

> ORA-01196: file 1 is inconsistent due to a failed media recovery session

> ORA-01110: data file 1: '/opt/oracle/oradata/DB/system01.dbf'

>

>

> ORA-01112: media recovery not started

>

> No matter the way I do the incomplete recover, using backup controlfile

> or generating a new controlfile, I never can open the database. Any idea?

>

> Thanks in advance,

>

> Eric

>