Proble in opening standby database in read only mode
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Proble in opening standby database in read only mode

  1. #1
    Join Date
    Apr 2007
    Location
    india
    Posts
    11

    Proble in opening standby database in read only mode

    Database version 10.2.0.1.0

    When i am trying to open the standby database in read only mode it is showing error:

    SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 369098752 bytes
    Fixed Size 1249056 bytes
    Variable Size 113246432 bytes
    Database Buffers 251658240 bytes
    Redo Buffers 2945024 bytes
    SQL> alter database mount standby database;

    Database altered.

    SQL> alter database open read only;
    alter database open read only
    *
    ERROR at line 1:
    ORA-16004: backup database requires recovery
    ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
    ORA-01110: data file 1: 'F:\ORACLE\ORADATA\PRIMARY\SYSTEM01.DBF'

    When i am trying to recover standby database it showing error:

    SQL> recover standby database
    ORA-00283: recovery session canceled due to errors
    ORA-01124: cannot recover data file 1 - file is in use or recovery
    ORA-01110: data file 1: 'F:\ORACLE\ORADATA\PRIMARY\SYSTEM01.DBF'


    There is no problem with archive log.Log are archived in both primary location and standby location.
    The error shows that primary standby system file is locked by DBWR.but why it is checking primary database files.

  2. #2
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    1. Recreate the standby control file from the primary database.
    2. Shutdown the Standby database.
    3. Transfer the new standby control and mount the standby database with new control file.
    4. recover standby database.
    5. open in READ ONLY.

  3. #3
    Join Date
    Apr 2007
    Location
    india
    Posts
    11
    I have done this but again it is showing the same error:

    SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 369098752 bytes
    Fixed Size 1249056 bytes
    Variable Size 113246432 bytes
    Database Buffers 251658240 bytes
    Redo Buffers 2945024 bytes
    SQL> alter database mount standby database;

    Database altered.

    SQL> recover standby database;
    ORA-00283: recovery session canceled due to errors
    ORA-01110: data file 1: 'F:\ORACLE\ORADATA\PRIMARY\SYSTEM01.DBF'
    ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
    ORA-01110: data file 1: 'F:\ORACLE\ORADATA\PRIMARY\SYSTEM01.DBF'


    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination f:\oracle\standbyarch
    Oldest online log sequence 38
    Next log sequence to archive 40
    Current log sequence 40

    On primary the log sequence is:

    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination f:\oracle\primaryarch
    Oldest online log sequence 39
    Next log sequence to archive 41
    Current log sequence 41

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