Hello,
Yesterday, I created a new physical standby database, based on
http://dbatricksworld.com/steps-to-configure-oracle-11g-data-guard-physical-standby-data-guard-part-i/
everything looks fine.
Today Morning, found standby database is behind the primary, then manually copied missing archivelogs, and recovering the standby database to catch up.
primary db unique name: orcl2
standby db unique name: orcl2_stby
seems like standby db can't receive archivelogs from primary,
in standby
SQL> SELECT DEST_NAME,STATUS,DESTINATION
2 FROM V$ARCHIVE_DEST
3 WHERE DESTINATION IS NOT NULL;
DEST_NAME STATUS DESTINATION
------------------------- --------- ------------------------------
LOG_ARCHIVE_DEST_1 BAD PARAM E:\oracle\oradata\orcl2\recovery\ORCL2\ARCHIVELOG
LOG_ARCHIVE_DEST_2 VALID ORCL2
STANDBY_ARCHIVE_DEST VALID USE_DB_RECOVERY_FILE_DEST
why it show "bad param"
How I fix?
Thank you
cc:
in standby
SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string E:\ORACLE\ORADATA\ORCL2\recovery
db_recovery_file_dest_size big integer 150G