Work in progress… testing
Lots of stuff about role transition from Oracle
Oracle Best Practices Doc
ALTER SYSTEM SET FAL_SERVER=GGSTBY;
Oracle Documentation on Role Transitions
My primary is GGTARGET and standby is GGSTBY
Primary
*.log_archive_dest_2=’service=”ggstby”‘,’ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=”ggstby” net_timeout=30′,’valid_for=(online_logfile,all_roles)’
*.log_archive_dest_state_2=’ENABLE’
Standby
# probably don’t want the dest_2 on the standby enabled until you switch over – and then you should also disable the old primary dest_2 – or is using DG Broker just a lot easier?
*.log_archive_dest_2=’service=”ggtarget”‘,’ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=”ggtarget” net_timeout=30′,’valid_for=(online_logfile,all_roles)’
*.log_archive_dest_state_2=’DISABLE’