中科医院以品质领跑行业 http://news.39.net/bjzkhbzy/180102/5972929.html

#MAXIMUMAVAILABILITY模式

ALTERSYSTEMSETLOG_ARCHIVE_DEST_2=service=kaixuadglgwrsyncaffirmvalid_for=(online_logfiles,primary_role)db_unique_name=kaixuadgSCOPE=BOTH;ALTERSYSTEMSETLOG_ARCHIVE_DEST_2=service=kaixuadblgwrsyncaffirmvalid_for=(online_logfiles,primary_role)db_unique_name=kaixuadbSCOPE=BOTH;ALTERDATABASESETSTANDBYDATABASETOMAXIMIZEAVAILABILITY;#启动DG_BROKER_START主备两个库的ALTERSYSTEMSETDG_BROKER_START=TRUESCOPE=BOTH;#启动FLASHBACKDATABASE.#切换时，OBSERVER会将备库变成主库。同时OBSERVER通过应用FLASHBACKLOG将原来的主库变成备库。ALTERDATABASEFLASHBACKON;#LISNTRCL.ORA主库SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=KAIXUAN)(ORACLE_HOME=/U01/ORA_SOFT/ORACLE/PRODUCT/11.2.0/DB_1)(SID_NAME=KAIXUADB))(SID_DESC=(GLOBAL_DBNAME=KAIXUANDB_DGMGRL.DB_DOMAIN)(ORACLE_HOME=/U01/ORA_SOFT/ORACLE/PRODUCT/11.2.0/DB_1)(SID_NAME=KAIXUADB)))#备库监听添加GLOBAL_DBNAMESID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=KAIXUAN)(ORACLE_HOME=/U01/ORA_SOFT/ORACLE/PRODUCT/11.2.0/DB_1)(SID_NAME=KAIXUADG))(SID_DESC=(GLOBAL_DBNAME=KAIXUANDG_DGMGRL.DB_DOMAIN)(ORACLE_HOME=/U01/ORA_SOFT/ORACLE/PRODUCT/11.2.0/DB_1)(SID_NAME=KAIXUADG)))#TNSNAMEDGBRMAST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.77.20)(PORT=))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=KAIXUANDB_DGMGRL.DB_DOMAIN)))DGBRSLAVE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.77.21)(PORT=))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=KAIXUANDG_DGMGRL.DB_DOMAIN)))4创建配置文件DGMGRLCONNECTSYS/ZFK_ORACLE78

KAIXUADB;DGMGRLCREATECONFIGURATIONDG_BROKER_MASTASPRIMARYDATABASEISKAIXUADBCONNECTIDENTIFIERISDGBRMAST;DGMGRLSHOWCONFIGURATION;DGMGRLENABLECONFIGURATION;5添加备数据库ADDDATABASEKAIXUADGASCONNECTIDENTIFIERISDGBRSLAVEMAINTAINEDASPHYSICAL;#这里的参数要说明一下.ADDDATABASE‘DBSALVE′,这儿的DBSALVE是指DATABASE的DB_UNIQUE_NAME,而ASCONNECTIDENTIFIERISDBSALVE这里的DBSALVE是指TNSNAME.ORA连接到STANDBYDATABASE的NETSERVICENAME.#启动有效备库ENABLEDATABASEKAIXUADG;#显示主和备库所有属性信息DGMGRLSHOWDATABASEVERBOSEKAIXUADB;DGMGRLSHOWDATABASEVERBOSEKAIXUADG;#显示下备库目前的属性值,居然跟数据库参数一直的DGMGRLSHOWDATABASEKAIXUADGSTATUSREPORT;DGMGRLSHOWDATABASEDBSALVEARCHIVELAGTARGET#编辑属性,同步下使得配置文件跟数据库参数一致DGMGRLEDITDATABASEDBSALVESETPROPERTYARCHIVELAGTARGET=0;#切换演练DGMGRLSWITCHOVERTOKAIXUADG;#7DB_UNQIUE_NAME大写的时候#1添加主备库的时候要用单引号引起‘DBMAST’#2使用配置数据库名的时候也要单引号引起#SWITCHOVERTO‘DBSALVE’#SHOWDATABASE‘DBSALVE’STATUSREPORT;二手工DGBROKERFAILOVER关闭主库SQLSHUTDOWNABORTDGMGRLFAILOVERTO‘DBSALVE’;#三自动FAST-FAILOVERDGMGRLCONNECTSYS/ORACLE

DBMAST;DGMGRLSHOWCONFIGURATION;#两边要开启FLASHBACKALTERDATABASEFLASHBACKON;备用库下先取消恢复SQLALTERDATABASERECOVERMANAGEDSTANDBYDATABASECANCEL;SQLALTERDATABASEFLASHBACKON;SQLALTERDATABASERECOVERMANAGEDSTANDBYDATABASEUSINGCURRENTLOGFILEDISCONNECT;SQLSELECTFLASHBACK_ONFROMVDATABASE;DGMGRLENABLEFAST_STARTFAILOVER;#可能需要扩大闪回区SQLALTERSYSTEMSETDB_RECOVERY_FILE_DEST_SIZE=GSCOPE=BOTH;#观察程序已启动DGMGRLSTARTOBSERVER;#启动OBSERVER的DGMGRL需要一直挂着，所以最好放在后台启动，如：NOHUPDGMGRLSYS/ORACLE

DB1startobserverDGMGRLSHOWFAST_STARTFAILOVER;3DGMGRLSHOWCONFIGURATIONVERBOSE;#可以修改相关的属性EDITCONFIGURATIONSETPROPERTYFASTSTARTFAILOVERTHRESHOLD=;

祖仙教小凡仙