Home » RDBMS Server » Backup & Recovery » Checksum error in redo log block. (Oracle 9i Standard Edition, Linux)
Checksum error in redo log block. [message #568630] Mon, 15 October 2012 05:47 Go to next message
chintan.patel
Messages: 131
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
Re: Checksum error in redo log block. [message #568639 is a reply to message #568630] Mon, 15 October 2012 06:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing to do.
If you have a backup of it and need it you can restore it.

Regards
Michel
Re: Checksum error in redo log block. [message #568641 is a reply to message #568639] Mon, 15 October 2012 07:02 Go to previous messageGo to next message
chintan.patel
Messages: 131
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
Re: Checksum error in redo log block. [message #568645 is a reply to message #568641] Mon, 15 October 2012 07:08 Go to previous message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Question regarding full backup strategy
Next Topic: windows rman - bat file using variable
Goto Forum:
  


Current Time: Fri Oct 31 07:56:39 CDT 2014

Total time taken to generate the page: 0.23285 seconds