| ora-00354 [message #244121] |
Mon, 11 June 2007 11:43  |
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
|
Senior Member |
|
|
Hello sir
Plz help me
when i started the database it shows the following error
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 1041307652 bytes
Fixed Size 452612 bytes
Variable Size 536870912 bytes
Database Buffers 503316480 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 48435 change 352075754 time 06/11/2007
09:55:18
ORA-00312: online log 3 thread 1: '/mnt/ora_redo/tcms/redo03.log'
what can i do
- thanx in advance
|
|
|
|
| Re: ora-00354 [message #244122 is a reply to message #244121] |
Mon, 11 June 2007 11:46  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
I hope you have good backups & know how to restore the DB from them.
00354, 00000, "corrupt redo log block header"
// *Cause: The block header on the redo block indicated by the accompanying
// error, is not reasonable.
// *Action: Do recovery with a good version of the log or do time based
// recovery up to the indicated time. If this happens when archiving,
// archiving of the problem log can be skipped by clearing the log
// with the UNARCHIVED option. This must be followed by a backup of
// every datafile to insure recoverability of the database.
[Updated on: Mon, 11 June 2007 11:47] by Moderator Report message to a moderator |
|
|
|
| Re: ora-00354 [message #244123 is a reply to message #244122] |
Mon, 11 June 2007 11:49 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
Try this option but i am not sure.
sql>ALTER DATABASE CLEAR LOGFILE GROUP #
SQL>alter database open;
|
|
|
|
|
|
| Re: ora-00354 [message #244125 is a reply to message #244124] |
Mon, 11 June 2007 12:06 |
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
|
Senior Member |
|
|
when i use this command it shows the following error
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 3;
ALTER DATABASE CLEAR LOGFILE GROUP 3
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of thread 1
ORA-00312: online log 3 thread 1: '/mnt/ora_redo/tcms/redo03.log'
-Thanx
|
|
|
|
| Re: ora-00354 [message #244132 is a reply to message #244125] |
Mon, 11 June 2007 12:35 |
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
|
Senior Member |
|
|
hello sir
if i have try to recover it ,but still it shoes error
SQL> recover database until time '2007-06-11:01:00:00';
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get
error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/mnt/ora_data/tcms/system01.dbf'
Plz help me what can i do for this case.
-Thanx.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
