Recovery problem

[Former Member]

I am getting this problem while I am trying to do recovery... please help me

SQL> recover database using backup controlfile until cancel

ORA-00279: change 157414678 generated at 06/20/2010 12:53:59 needed for thread

1

ORA-00289: suggestion : E:\ORACLE\BIQ\ORAARCH\BIQARCHARC00053_0722172747.001

ORA-00280: change 157414678 for thread 1 is in sequence #53

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

auto

ORA-00342: archived log does not have expected resetlogs SCN 157406275

ORA-00334: archived log: 'E:\ORACLE\BIQ\ORAARCH\BIQARCHARC00053_0722172747.001'

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

ORA-01190: control file or data file 1 is from before the last RESETLOGS

ORA-01110: data file 1: 'F:\ORACLE\BIQ\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

[former_member204746 · Accepted solution]

your control file is not from your backup... restore it properly.

[Former Member · Accepted solution]

NW2004s under windows 2003 server, oracle 10g

I have 2 Folder listed one OriglogA and OriglogB both has Ctrn folder and control files are listed...

E:\oracle\BIQ\origlogA\Cntrl\CNTRLBIQ.DBF

offline backup

BRBACKUP -u system/******** -c force -t online -m all -p initbiq.sap

Offline Restore

BRRESTORE u2013b bedgoefo.and u2013m all u2013c u2013p initbiq.sap

SQL> Startup

must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

ERROR at line 1:

ORA-01190: control file or data file 1 is from before the last RESETLOGS

ORA-01110: data file 1: 'F:\ORACLE\BIQ\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> recover database using backup controlfile;

ORA-00279: change 157414678 generated at 06/20/2010 12:53:59 needed for thread

ORA-00289: suggestion : E:\ORACLE\BIQ\ORAARCH\BIQARCHARC00053_0722172747.001

ORA-00280: change 157414678 for thread 1 is in sequence #53

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

auto

ORA-00342: archived log does not have expected resetlogs SCN 157406275

ORA-00334: archived log: 'E:\ORACLE\BIQ\ORAARCH\BIQARCHARC00053_0722172747.001'

Basically I having problem SCN sequence and I don't know how to rebuild sequence

recover database until sequence 157406275

recover database until scn

Nothing help

please tell me how to resolve that prblem

Thank

[lbreddemann · Accepted solution]

>

> NW2004s under windows 2003 server, oracle 10g

>

> I have 2 Folder listed one OriglogA and OriglogB both has Ctrn folder and control files are listed...

> E:\oracle\BIQ\origlogA\Cntrl\CNTRLBIQ.DBF

>

> offline backup

> BRBACKUP -u system/******** -c force -t online -m all -p initbiq.sap

>

> Offline Restore

> BRRESTORE u2013b bedgoefo.and u2013m all u2013c u2013p initbiq.sap

And THIS is what you're doing totally wrong here!

Use BRRECOVER instead.

It will automatically select the correct files for your restore/recovery scenario and also use the correct commands.

There's barely a reason to call BRRESTORE directly.

Even better: just use the menu-driven approach of the BRTOOLS program.

regards.

Lars

[Former Member · Accepted solution]

Hi Lars,

Problem has been resolved using RMAN

Restore and recover the whole database

RMAN> STARTUP FORCE MOUNT;

RMAN> RESTORE DATABASE;

RMAN> RECOVER DATABASE;

RMAN> ALTER DATABASE OPEN;

After goto SQL and open database

thanks