High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

After create standby log on primary using ASM, 'IS_RECOVERY_DEST_FILE' is set to 'NO'. Why?

Test database KMP. RAC environment on ASM. Remote physical standby instance KMPSBY.

Looking at configs to see what is problem with ASM fast recovery area (FRA) config.

What is required to force IS_RECOVERY_DEST_FILE to YES when creating STANDBY logs on primary?

Is it necessary on primary?

ON PRIMARY:

select thread#, status, enabled, groups from v$thread;

       THREAD# STATUS ENABLED      GROUPS

    ---------- ------ -------- ----------

             1 OPEN   PUBLIC            2   ---> standby needs 3 groups each

             2 OPEN   PUBLIC            2

select group#, thread#, sequence#, bytes, archived, status

from v$log order by group#;

        GROUP#    THREAD#  SEQUENCE#      BYTES ARC STATUS

    ---------- ---------- ---------- ---------- --- ----------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center