Standby database recovery error

[former_member246694]

Dear All,

When Im trying to apply redologs for my standby database, the following error is coming up

ORA-00279: change 276067636 generated at 08/22/2010 05:03:25 needed for thread 1

ORA-00289: suggestion : /oracle/BWP/oraarch/BWParch1_30490_684267445.dbf

ORA-00280: change 276067636 for thread 1 is in sequence #30490

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

AUTO

ORA-00283: recovery session canceled due to errors

ORA-00368: checksum error in redo log block

ORA-00353: log corruption near block 32769 change 276075175 time 08/22/2010 05:03:49

ORA-00334: archived log: '/oracle/BWP/oraarch/BWParch1_30490_684267445.dbf'

ORA-01112: media recovery not started

Could you please help out.

Thanks n Regards,

KK

[Former Member]

Hello,

Transfer the log file BWParch1_30490_684267445.dbf from the production site to the DR site once again and then recover the standby database once again. This time u will not face any issue.

If the issue still persists, then probably the log file BWParch1_30490_684267445.dbf might have corrupted and the only way to recover isto restore a new backup from the PRD server.

Regards,

Varadharajan M

[stefan_koehler]

Hello Anees,

the error is pretty clear:

> ORA-00368: checksum error in redo log block

> ORA-00353: log corruption near block 32769 change 276075175 time 08/22/2010 05:03:49

Now there are some questions to get some more information about your environment.

1) What kind of log transmission do you use (LGWR SYNC, LGWR ASYNC, ARC ASYNC)?

2) What are the settings for that transmission?

3) Do you really perform manual recover actions?

4) What database version do you use?

There are some well known bugs - for example metalink note #9098116.8 / Bug 9098116.

But it all depends on your environment and settings.

Regards

Stefan

[former_member246694]

Hi Stefan,

Im sorry that I do not know how to find answer for your questions 1 and 2.Pls guide me so that i can let you know.

Q 3> We have a oracle data gaurd.But still at time we do no apply manually.

Q 4> We are on Oracle 10.2.0.4 G version.

Thanks,

Anees

[stefan_koehler]

Hello Anees,

you are running Oracle Data Guard without knowing how the logs are transferred or howto check this?

> Pls guide me so that i can let you know.

Just run the following command in SQL*Plus on the primary database and post the output.

shell> su - ora<SID>
shell> sqlplus / as sysdba
SQL> show parameter log_archive_dest

Regards

Stefan

[former_member246694]

Hi Stefan,

Oracle data guard is implemented by one of the expert on the same.

The following is result of the command you listed.

NAME TYPE VALUE

-

---

-

---

-

---

log_archive_dest string /oracle/BWP/oraarch/BWParch

log_archive_dest_1 string

log_archive_dest_10 string

log_archive_dest_2 string

log_archive_dest_3 string

log_archive_dest_4 string

log_archive_dest_5 string

log_archive_dest_6 string

log_archive_dest_7 string

log_archive_dest_8 string

log_archive_dest_9 string

NAME TYPE VALUE

-

---

-

---

-

---

log_archive_dest_state_1 string enable

log_archive_dest_state_10 string enable

log_archive_dest_state_2 string defer

log_archive_dest_state_3 string enable

log_archive_dest_state_4 string enable

log_archive_dest_state_5 string enable

log_archive_dest_state_6 string enable

log_archive_dest_state_7 string enable

log_archive_dest_state_8 string enable

log_archive_dest_state_9 string enable

Thanks,

Anees

[stefan_koehler]

Hello Anees,

ok you are not using any oracle related transmitting mechanism. By the way you are still using "log_archive_dest" which is not recommended anymore (check the note)::

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams099.htm#i1128645

You perform the transmission of archive logs manually with some kind of scripts or any third party software. It seems like there was some trouble by copying the archive logs .. now you are on your own, because of we don't know how you transfer and apply that log files.

Regards

Stefan