Oracle Standby Database (9.2.0.7 SE) Issue ...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle Standby Database (9.2.0.7 SE) Issue ...

  1. #1
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    Oracle Standby Database (9.2.0.7 SE) Issue ...

    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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  2. #2
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Is your standby database in recovery mode i.e. if it is in managed recovery mode than ou have to cancel managed recovery.

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width