1 Reply Latest reply: Oct 7, 2013 8:14 AM by mseberg RSS

    Open Mode for Logical Standby

    Jimbo


      HI,

       

      I have a logical standby. It's v$database.open_mode shows READ WRITE

       

      Q1. I am correct in assuming that the Database is only writable for tables that are not in the primary ?

       

      Q2. Are the tables that are also in the primary, in effect in read only mode on the logical standby ? Am I able to see the mode of these tables to prove they are read only ?

       

      thanks,

      Jim

        • 1. Re: Open Mode for Logical Standby
          mseberg

          Hello;

           

          User modification to tables on the Logical Standby has three possible settings:

           

          ALL

          STANDBY

          NONE

           

          You can check the mode using this query:

           

           

          SELECT GUARD_STATUS FROM V$DATABASE;

           

          If you try to insert data into a table and the mode is 'ALL' and you are not the SYS user you should get an error

           

          ORA-16224

           

           

          If you want users to modify non-replicated standby tables then you need to change the mode from its default of 'ALL'.

           

          You can use DBA_LOGSTDBY_SKIP to find non-replicated tables ( the ones with skip rules ).

           

          If you create new objects consider a naming convention that allows you to easily see the write status.

           

          Best Regards

           

          mseberg