on 09-20-2011 6:28 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.