Oracle Standby Database (9.2.0.7 SE) Issue ...

[vnktummala]

Database: 9.2.0.7 SE
OS: Linux

I have an issue with one of my standby databases. Shell script applies the archivelogs to the standby database between 1am - 6am Some times suddenly it is failing with the error showing in the excerpt of the alert log ...

alter database recover continue default
Fri Oct 31 02:05:02 2008
Media Recovery Log /u01/app/oracle/admin/DBX/arch/arch_1_57806.arc
ORA-1155 signalled during: alter database recover continue default...
Fri Oct 31 02:05:02 2008
alter database recover cancel
Fri Oct 31 02:05:02 2008
Errors in file /u01/app/oracle/admin/DB32/bdump/db32_dbw0_28819.trc:
ORA-01186: file 1 failed verification tests
ORA-01108: file 1 is in backup or media recovery
ORA-01110: data file 1: '/u02/oradata/DB32/system01.dbf'Fri Oct 31 02:05:02 2008
File 1 not verified due to error ORA-01108
Fri Oct 31 02:05:02 2008

The same error continuing for all the data files in the database and the recovery scrpit is existing.

I have googled for it and verified at metalink and the solution every one giving is to "wait till the media recovery complete".

When the time of error, database is already in recovery mode and suddenly it is failing. This is driving me crazy to understand what is trying to recover the database when it is already in recovery.

When the time of error, the shell script is running only one time, no issues with file system or OS what ever.

Is any one faced this type of issue any time? Appreciate your suggestions.

FYI - Part of the trace files is here ...

*** 2008-10-31 02:05:02.584
*** SESSION ID:(2.1) 2008-10-31 02:05:02.583
ORA-01186: file 1 failed verification tests
ORA-01108: file 1 is in backup or media recovery
ORA-01110: data file 1: '/u02/oradata/DB32/system01.dbf'
ORA-01186: file 2 failed verification tests
ORA-01108: file 2 is in backup or media recovery
ORA-01110: data file 2: '/u02/oradata/DB32/undo_01.dbf'
ORA-01186: file 3 failed verification tests
ORA-01108: file 3 is in backup or media recovery
ORA-01110: data file 3: '/u04/oradata/DB32/tools01.dbf'
ORA-01186: file 4 failed verification tests

Thanks,

[bhattnirav]

Is your standby database in recovery mode i.e. if it is in managed recovery mode than ou have to cancel managed recovery.

[vnktummala]

We are using 9.2.0.7 Standard Edition for this database in error. So no question of MRM.

However, when this error came, my shell script is recovering the database.

Thanks,