Hi,

I am getting the following error while manually recovering my standby database....(ie. recover standby database)

ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 2049 change 5145844262 time 05/23/2005 13:55:47
ORA-00334: archived log: '/arch/arch_2_18272.log'

ORA-01112: media recovery not started

After this error occurs, i have delete the said archive log file from my standby db server and copied again from the production db even then i am getting the same error.

What could be the reason for this? How can i proceed with media recovery and put my standby db in sync with production db.

I searched so many sites, everybody suggests for creating standby db again...is this is the only way for correcting my problem?????


Thanks & Regards