Restore and Revovery

[Former Member]

Dear Friends,

I have restore offline backup . now i m applying archive using "Recover database until cancel using backup controlfile. it gives following error:

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 563682868 bytes

Fixed Size 454196 bytes

Variable Size 301989888 bytes

Database Buffers 260046848 bytes

Redo Buffers 1191936 bytes

Database mounted.

SQL> recover database until cancel using backup controlfile;

ORA-00279: change 204128689 generated at 10/24/2011 03:15:32 needed for thread

1

ORA-00289: suggestion : L:\ORACLE\PRD\ORAARCH\PRDARCHARC03965.001

ORA-00280: change 204128689 for thread 1 is in sequence #3965

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

AUTO

ORA-00283: recovery session canceled due to errors

ORA-00600: internal error code, arguments: [3020], [8388633], [1], [3965], [2],

[16], [], []

ORA-10567: Redo is inconsistent with data block (file# 2, block# 25)

ORA-10564: tablespace PSAPUNDO

ORA-01110: data file 2: 'F:\ORACLE\PRD\SAPDATA1\UNDO_1\UNDO.DATA1'

ORA-10560: block type 'KTU SMU HEADER BLOCK'

ORA-01112: media recovery not started

Please help me....Thanks in advance

[audunlea_hansen]

Hi!

Try to run DB Verify ( $ORACLE_HOME/bin/dbv ) on the datafile to verify block corruptions. You need to know the block-size used for the actual tablespace (undo-tbs).

Normally you don't need information in the undo-tbs if you have to restore the whole database.

If you got all needed arch-files, you normally can restore the datafile from an older backup and roll the database forward.

Regards

Audun

DBA

[Former Member]

Dear friends,

Thanks all for your reply.. Now i have restore data base again and applied following command for applying log files...Does it applied??????? what do next ??? please reply...

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area 563682868 bytes

Fixed Size 454196 bytes

Variable Size 301989888 bytes

Database Buffers 260046848 bytes

Redo Buffers 1191936 bytes

Database mounted.

SQL> recover database until cancel using backup controlfile

ORA-00279: change 204691271 generated at 11/03/2011 01:01:27 needed for thread

1

ORA-00289: suggestion : L:\ORACLE\PRD\ORAARCH\PRDARCHARC04008.001

ORA-00280: change 204691271 for thread 1 is in sequence #4008

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

auto

ORA-00279: change 204694501 generated at 11/03/2011 03:15:12 needed for thread

1

ORA-00289: suggestion : L:\ORACLE\PRD\ORAARCH\PRDARCHARC04009.001

ORA-00280: change 204694501 for thread 1 is in sequence #4009

ORA-00278: log file 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04008.001' no longer

needed for this recovery

ORA-00279: change 204707054 generated at 11/03/2011 08:38:09 needed for thread

1

ORA-00289: suggestion : L:\ORACLE\PRD\ORAARCH\PRDARCHARC04010.001

ORA-00280: change 204707054 for thread 1 is in sequence #4010

ORA-00278: log file 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04009.001' no longer

needed for this recovery

ORA-00279: change 204714900 generated at 11/03/2011 10:00:14 needed for thread

1

ORA-00289: suggestion : L:\ORACLE\PRD\ORAARCH\PRDARCHARC04011.001

ORA-00280: change 204714900 for thread 1 is in sequence #4011

ORA-00278: log file 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04010.001' no longer

needed for this recovery

ORA-00308: cannot open archived log 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04011.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

SQL>

SQL> recover database until cancel using backup controlfile

ORA-00279: change 204714900 generated at 11/03/2011 10:00:14 needed for thread

1

ORA-00289: suggestion : L:\ORACLE\PRD\ORAARCH\PRDARCHARC04011.001

ORA-00280: change 204714900 for thread 1 is in sequence #4011

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

auto

ORA-00308: cannot open archived log 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04011.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

ORA-00308: cannot open archived log 'L:\ORACLE\PRD\ORAARCH\PRDARCHARC04011.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

SQL>

[Former Member]

Hi ,

I think there are maybe some block corruption in you undo datafile.

So you can not you cancel base recover scenatio. You can use time base recover to avoid bring database into corruption point.

your database may be closeed abnormally.

Hope this help you.

Wuyan

[former_member188883]

Hi Ketan,

You backup seems to have got corrupted.

Please take a fresh backup and restore the same.

Later you can simply startup database after successful restoration.

Regards,

Deepak Kori

[Former Member]

>                I have restore offline backup . now i m applying archive using  "Recover database until cancel using backup controlfile. it gives following error:
> ORACLE instance shut down.
> SQL> startup mount
> ORACLE instance started.

Hello,

During Restore from 'Offline' backup, we do not need/can't apply the redo-logs. You can't recover point in time by offline backup, database will be restored just to the point when offline backup was executed.

Instead of startup mount, please execute 'startup' to 'open' the database.

Thankyou

[Former Member]

Point in time recovery can be done whether the backup is offline or online, provided you have archive logs.

Br,

Venky

[Former Member]

Hi Ketan,

Seems like you have a corrupt datafile.

ORA-10567: Redo is inconsistent with data block (file# 2, block# 25)

ORA-10564: tablespace PSAPUNDO

ORA-01110: data file 2: 'F:\ORACLE\PRD\SAPDATA1\UNDO_1\UNDO.DATA1'

Restore only the datafile in question from the backup and try to recover the database.

Br,

Venky