4 Replies Latest reply: Apr 10, 2013 1:44 PM by 971256 RSS

    Standby Database not opening as Read only

    B Dave
      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
          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
            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
              Just try to open ur standby using open resetlogs
              thanks
              • 4. Re: Standby Database not opening as Read only
                971256
                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