Dispatchee Stopped ...URGENT

[Former Member]

Hi All,

After restarting the computer Dispatcher Stopped working and in Event Viewer it's giving the error below:

ORA-00354: corrupt redo log block header

ORA-00312: online log 4 thread 1: 'E:\ORACLE\DR1\ORIGLOGB\LOG_G14M1.DBF'

ORA-00312: online log 4 thread 1: 'F:\ORACLE\DR1\MIRRLOGB\LOG_G14M2.DBF'

I have also found the note related to this problem....but i dont how to execute this suggestion: Through brtools or from the oracle end....plz explain?

"If the ORA-00354 occurs when you are archiving an online redo log (additional error: ORA-16038: "log cannot be archived" or "ORA-00255: Error archiving log") and not during a recovery, the archiving of the redo log can be suppressed as follows:

ALTER DATABASE CLEAR UNARCHIVED LOGFILE '<log>';

Finally, you must create a consistent backup as soon as possible since a recovery is no longer possible beyond this time because the offline redo logs are missing.

Can anybody tell me how to resolve this issue.

regards,

Amit

[Former Member]

Amit,

Try this....Issue the following command on redo log members.

SQL> ALTER SYSTEM DUMP LOGFILE 'filename'

2. If the redo log member is corrupt, then the dump command will fail with the same error as when doing a media recovery with the same file.

3. If the dump of any of the redo log member is successful then,

a. shutdown the database.

b. replace the bad member with a copy of the good redo log member using Operating system commands

c. startup the database

Let me know the result

Regadrs

vinod

[Former Member]

Amit,

If the dump of both the redo members fail then

1) alter database clear unarchived logfile '<logilename>';

2) make a new complete (online) backup of your database

The first command clears the online logfile (fills it with all null). This

makes the corruption disappear which causes the contents of the cleared online

redo file to be missing in the archived redo stream. This requires a new

complete (online) backup to allow for complete recovery in the future (step 2).

Regards

Vinod