This discussion is archived
4 Replies Latest reply: Apr 10, 2013 11:44 AM by 971256 RSS

Standby Database not opening as Read only

B Dave Newbie
Currently Being Moderated
Hi everyone.
We are managing standby database on oracle 10g32 bit.
Version : 10.2.0.5

Everything was working fine until I activated standby with flashback on.
After testing with flashback I'm not able to open standby as read only.
this is what I'm getting

I'm getting this error in my alert.log file
Fri aug 24 12:19:48 PST 2012
SMON: enabling cache recovery
Fri aug 24 12:19:48 PST 2012
Errors in file /oracle/admin/udump/standby_ora_98305.trc:
ORA-00704: bootstrap process failure
ORA-00376: file 1 cannot be read at this time
ORA-01110: data file 1: '/webdata/rcsystem1.dbf'
Fri aug 24 17:16:48 PST 2012
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 24305
ORA-1092 signalled during: alter database open read only
...
This is system datafile. I have no clue what can I do to resolve this error. I've made this file online which not worked.
Made it to offline and online still not worked.

Here is the output of trace file mentioned in alert.log
Instance name: standby
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Unix process pid: 44305, image: oracle@rctestj

File '/dev/async' not present : errno=2
*** 2012-08-24 17:16:48.629
*** ACTION NAME:() 2012-08-24 17:16:48.629
*** MODULE NAME:(sqlplus@rctestj (TNS V1-V3)) 2012-08-24 17:16:48.629
*** SERVICE NAME:(SYS$USERS) 2012-08-24 17:16:48.629
*** SESSION ID:(653.1) 2012-08-24 17:16:48.629
ORA-00704: bootstrap process failure
ORA-00376: file 1 cannot be read at this time
ORA-01110: data file 1: '/webdata/rcsystem1.dbf'
Please anyone guide me to resolve this issue.

Thanks & regards,
  • 1. Re: Standby Database not opening as Read only
    mseberg Guru
    Currently Being Moderated
    Hello;

    I've seen something like this where the OS mounts READ ONLY shutdown the database ( its probably down ) and hard boot and check the OS before attempting to start the standby.

    Any chance the compatible parameter is different between the primary and standby?

    Given the combination of errors I would probably get oracle support involved early.

    Best Regards

    mseberg
  • 2. Re: Standby Database not opening as Read only
    B Dave Newbie
    Currently Being Moderated
    All parameters were same as before.

    The things that were changed are redo logs.

    Before making standby flashback they were not there.
    Now I can see them in $logs.

    Thanks
    I'll update on this as soon as I'll reach site tomorrow.
    Thanks & regards
  • 3. Re: Standby Database not opening as Read only
    974842 Newbie
    Currently Being Moderated
    Just try to open ur standby using open resetlogs
    thanks
  • 4. Re: Standby Database not opening as Read only
    971256 Newbie
    Currently Being Moderated
    Hi,
    I have the same issue when using sqlplus, probably a bug. But it works fine when using rman:

    SQL> SHUTDOWN IMMEDIATE;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> STARTUP MOUNT;
    ORACLE instance started.

    Total System Global Area 314572800 bytes
    Fixed Size 2083696 bytes
    Variable Size 142607504 bytes
    Database Buffers 163577856 bytes
    Redo Buffers 6303744 bytes
    Database mounted.
    SQL>
    SQL>
    SQL> FLASHBACK DATABASE TO SCN 17838032043;

    Flashback complete.

    SQL> exit

    rman target /

    Recovery Manager: Release 10.2.0.4.0 - Production on Wed Apr 10 14:14:36 2013

    Copyright (c) 1982, 2007, Oracle. All rights reserved.

    connected to target database: XXXXXXXX (DBID=1514076400, not open)

    RMAN> SQL 'ALTER DATABASE OPEN READ ONLY';

    using target database control file instead of recovery catalog
    sql statement: ALTER DATABASE OPEN READ ONLY

    RMAN> exit

    I found the answer here:
    http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr005.htm

    Frédéric

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points