cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding apply archive log after restore DR server

Former Member
0 Kudos

Dear All,

I have restore DR server with latest offline backup. after completed restoreation i have try to apply log i have geting massege:-

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

ORA-00279: change 207631043 generated at 09/19/2011 16:20:55 needed for thread

1

ORA-00289: suggestion : /oracle/P01/oraarch/P01arch1_21304_679453534.dbf

ORA-00280: change 207631043 for thread 1 is in sequence #21304

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

AUTO

ORA-00283: recovery session canceled due to errors

ORA-00354: corrupt redo log block header

ORA-00353: log corruption near block 2393 change 9560599494472 time 09/19/2011

16:20:55

ORA-00334: archived log: '/oracle/P01/oraarch/P01arch1_21304_679453534.dbf'

ORA-01112: media recovery not started

Pls. guide me...

Thanks & Regards,

Sweetdiya

Accepted Solutions (1)

Accepted Solutions (1)

fjhernanz
Contributor
0 Kudos

Hi,

From the error you describe seems like the redo log is corrupted. In regard to this issue would you please firstly take a look

At note 694155 for possible caused and solution:

694155 Error due to corrupt redo logs

Br,

Javier

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Diya,

After restoring from an offline backup you can directly start the DB by using startup command.

There is no need to do the recovery.Only in case of restoration from an online backup recovery is needed.

Regards,

Ershad Ahmed.

Former Member
0 Kudos

Hi,

Probably, redo log "/oracle/P01/oraarch/P01arch1_21304_679453534.dbf" is currupt.

If possible copy it again from Primary server and then run recovery.

Regards.

Rajesh Narkhede

Former Member
0 Kudos

Hello,

Instead of the logfile name, try the command with the logfile integer by folloiwng way.

alter database clear unarchived logfile group <integer>;

Get the logfile integer using the view, v$log.

select GROUP#,MEMBERS,STATUS from v$log;

The parameter GROUP# is the logfile integer.

Regards,

Rao

Former Member
0 Kudos
SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

Post restore - Mount your database in standby mode, then use below command.

recover standby database;

Place the archivelogs in archive directory before executing the above command.

Regards,

Nick Loy

Former Member
0 Kudos

Daer Nick,

Thanks for reply

I have restore DR server again and now i had try to apply archive logs but it shows error:-

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

ORA-00283: recovery session canceled due to errors

ORA-00600: internal error code, arguments: [2141], [1475420285], [1475218428],

[], [], [], [], []

SQL> shutdown normal;

ORA-00600: internal error code, arguments: [2141], [1475420285], [1475218428], [], [], [], [], []

SQL> shutdown immediate;

ORA-00600: internal error code, arguments: [2141], [1475420285], [1475218428], [], [], [], [], []

SQL>

Pls. gudie me .

Thanks & Regards,

Sweetdiya

Former Member
0 Kudos

Hi,

Check the trace file under "/oracle/<SID>/saptrace/usertrace" and provide the error.

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi,

ORA-00600: internal error code, arguments: 2141, 1475420285, 1475218428], [, ], [, ], [

This may be due to BLOCK corruption in database.

Please refer below notes:

[Note 152444 - ora-600 (2141)]|https://service.sap.com/sap/support/notes/152444]

[Note 365481 - Block corruptions|https://service.sap.com/sap/support/notes/365481]

and also

[1559652 - How to deal with block corruptions on Oracle|https://service.sap.com/sap/support/notes/155962]

[Note 23345 - Consistency check of ORACLE database|https://service.sap.com/sap/support/notes/23345]

Search other SAP notes using keyword "ORA-00600"

Regards.

Rajesh Narkhede