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
---------- ---------- ---------- ---------- --- ----------------