#############################  switchover  ###############################

sql> select database_role ,open_mode,protection_mode,protection_level,switchover_status from v$database;

sql> alter database commit to switchover to physical standby;

sql> alter database commit to switchover to physical standby with session shutdown;

sql> alter database commit to switchover to primary;

sql> alter database commit to switchover to primary with session shutdown;

#############################  failover    ###############################

sql> select thread#, low_sequence#, high_sequence# from v$archive_gap;

sql> select unique thread#, max(sequence#) over(partition by thread#) last from v$archived_log;

sql> alter database recover managed standby database cancel;

sql> alter database recover managed standby database finish;

sql> alter database recover managed standby database finish force;

sql> alter database commit to switchover to primary;

############################# open standby  ###############################

sql> alter database recover managed standby database cancel;

sql> alter database open;

sql> alter database recover managed standby database disconnect from session;

#################### Maximum Performance 2 Maximum Availability ##################

service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hzdevdb2.mambo.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mrptdb_XPT.mambo.com)(INSTANCE_NAME=rptdb)(SERVER=dedicated)))", ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="mrptdb" register net_timeout=180 valid_for=(online_logfile,primary_role)

service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hzdevdb2.mambo.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mrptdb_XPT.mambo.com)(INSTANCE_NAME=rptdb)(SERVER=dedicated)))", LGWR SYNC AFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="mrptdb" register net_timeout=180 valid_for=(online_logfile,primary_role)

ITPub博客

DG tips

最新文章