OraFAQ Forum: Backup & Recovery » Checksum error in redo log block.

Home » RDBMS Server » Backup & Recovery » Checksum error in redo log block. (Oracle 9i Standard Edition, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Checksum error in redo log block. [message #568630]

Mon, 15 October 2012 05:47

chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad

Senior Member

Dear Friends,

I am facing some problems in recovery on oracle 9.2.0.1.0 Standard Edition.
i need help regarding the following errors.
Quote:

ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 43200 change 1021681146 time 10/11/2012 18:25:25
ORA-00334: archived log: '/oradb/odb/archivedata/ARCH0000002343.ARC'

Regards
Chintan

Report message to a moderator

Re: Checksum error in redo log block. [message #568639 is a reply to message #568630]

Mon, 15 October 2012 06:46

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Nothing to do.
If you have a backup of it and need it you can restore it.

Regards
Michel

Report message to a moderator

Re: Checksum error in redo log block. [message #568641 is a reply to message #568639]

Mon, 15 October 2012 07:02

chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad

Senior Member

Dear michel

I have only one copy of /oradb/odb/archivedata/ARCH0000002343.ARC file. because of standard edition i cant multiplex the log file.
The value of db_block_checksum as below.

Quote:

SQL> show parameter db_block_checksum;

NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
db_block_checksum boolean TRUE
SQL>

Regards
Chintan

Report message to a moderator

Re: Checksum error in redo log block. [message #568645 is a reply to message #568641]

Mon, 15 October 2012 07:08

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

How is this parameter related to your problem, see the documentation?

Quote:

because of standard edition i cant multiplex the log file.

Which has nothing to do with ARCHIVED logs.

As I said, if you have only 1 copy, you can't do nothing for it.
Just take a full backup of your database.

Regards
Michel

Report message to a moderator

Previous Topic:	Question regarding full backup strategy
Next Topic:	windows rman - bat file using variable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 19:27:32 CST 2024