子公司需要搭建数据仓库，并且新建ADG作为主从，硬件设备DellR730机器；192.168.1.11dwjrdb--主库192.168.1.12dwjrstdyd--备库--数据库软件：linuxx64_12201_database.zip--数据库补丁包：p27105253_122010_Linux-x86-64.zip--Opatch升级包：p6880880_122010_Linux-x86-64.zip--目录规划为/u01存放归档日志，数据文件等，目录6.6TB空间
一、数据库安装实施步骤如下：1、关闭防火墙：systemctlstopfirewalldsystemctldisablefirewalld
systemctlstopfirewalld.servicesystemctldisablefirewalld.servicechkconfigNetworkManageroff
2、配置主机名和IP地址对应关系vi/etc/hosts添加如下内容
192.168.1.11dwjrdb192.168.1.12dwjrstdydb
修改主备库两端主机名/etc/hostnamedwjrdb
/etc/hostnamedwjrstdydb
3、安装依赖包：(oraclelinux7.2依赖包如下，具体可参考官方文档)
yumcleanallyuminstall-ybinutils-yuminstall-ycompat-libcap1-yuminstall-ycompat-libstdcyuminstall-yglibc-yuminstall-yglibc-devel-yuminstall-ykshyuminstall-ylibaio-yuminstall-ylibaio-develyuminstall-ylibX11-yuminstall-ylibXau-yuminstall-ylibXi-yuminstall-ylibXtst-yuminstall-ylibgcc-yuminstall-ylibstdcyuminstall-ylibstdc++-develyuminstall-ylibxcb-yuminstall-ymakeyuminstall-ynfs-utils-yuminstall-ynet-tools-yuminstall-ysmartmontools-yuminstall-ysysstat-yuminstall-ycompat-libcap1yuminstall-ysysstat-yuminstall-ylibaio-devel-yuminstall-ycompat-libcap1-*
4、关闭transparenthugepages，设置hugepages查看transparenthugepageRedHatEnterpriseLinuxkernels:
Otherkernels:
oraclelinux7.2没有开启transparenthugepages，忽略。
6、用户和组：groupadd-g501oinstallgroupadd-g502dbagroupadd-g503opergroupadd-g504backupdbagroupadd-g505dgdbagroupadd-g506kmdbagroupadd-g507racdba
/usr/sbin/useradd-u500-goinstall-Goinstall,dba,oper,backupdba,dgdba,kmdba,racdbaoracle
7、目录：mkdir-p/u01/app/oraInventorychown-Roracle:oinstall/u01/app/oraInventorychmod-R775/u01/app/oraInventory
mkdir-p/u01/app/oraclechown-Roracle:oinstall/u01/app/oraclechmod-R775/u01/app/oracle
mkdir-p/u01/app/oracle/product/12.2.0/db_1chown-Roracle:oinstall/u01/app/oracle/product/12.2.0/db_1chmod-R775/u01/app/oracle/product/12.2.0/db_1
mkdir-p/u01/archchown-Roracle:oinstall/u01/archchmod-R775/u01/arch
备库mkdir-p/u01/app/oracle/oradata/dwjrstdydbchown-Roracle:oinstall/u01/app/oracle/oradata/dwjrstdydbchmod-R775/u01/app/oracle/oradata/dwjrstdydb
8、环境变量
主库：exportORACLE_SID=dwjrdbexportORACLE_BASE=/u01/app/oracle/exportORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1exportPATH=$ORACLE_HOME/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibumask022sttyerase^h
备库：exportPATHexportORACLE_SID=dwjrstdydbexportORACLE_BASE=/u01/app/oracle/exportORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1exportPATH=$ORACLE_HOME/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibumask022sttyerase^h
9、内核参数：
vi/etc/sysctl.confkernel.shmmax=236223201280kernel.shmall=57671680kernel.shmmni=4096kernel.sem=50106412805010128fs.file-max=6815744net.ipv4.ip_local_port_range=900065500net.core.rmem_default=1048576net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048576fs.aio-max-nr=1048576vm.swappiness=0vm.nr_hugepages=62850
--保存生效/sbin/sysctl-p
10、限制文件：/etc/security/limits.conf
oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile65536oraclesoftstack10240
11、vi/etc/pam.d/login文件sessionrequiredpam_limits.so
vi/etc/profile
if[$USER="oracle"]||[$USER="grid"];thenif[$SHELL="/bin/ksh"];thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fiumask022fi
12、启动图形化窗口执行databas建库脚本a》error启动不起来设定exportDISPLAY=:11未果；
b》直接用xmanager登陆oracle用户，执行安装脚本可以；
13、创建完成后，dbca建库、netca创建监听
14、备库端只装sqlplus软件不建库
15、修改数据库参数altersystemsetopen_cursors=500container=all;altersystemsetprocesses=5000scope=spfile;altersystemsetdb_files=5000scope=spfile;altersystemsetundo_retention=7200scope=spfile;altersystemset"_undo_autotune"=FALSEscope=spfile;altersystemsetDEFERRED_SEGMENT_CREATION=falsescope=spfile;
16、更新OPatch版本，OPatch直接压缩替换，并且将patch打上。1.(1)上传p6880880_122010_Linux-x86-64.zip到/u01/software目录下,/u01/software给777权限。(2)root用户下将原OPatch目录改名。
mv/u01/app/oracle/product/12.2.0/db_1/OPatch/u01/app/oracle/product/12.2.0/db_1/OPatchBAK
cd/u01/software/;chownoracle:oinstallp6880880_122010_Linux-x86-64.zip
(2)oracle用户
su-oraclecd/u01/software/;unzipp6880880_122010_Linux-x86-64.zip
(3)root用户
cd/u01/software/;mvOPatch/u01/app/oracle/product/12.1.0/db_1/
(4)oracle用户测试
su-oracle/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchversion
打补丁[oracle@dwjrdb27105253]$cd/software/27105253[oracle@dwjrdb27105253]$/u01/app/oracle/product/12.2.0/db_1/OPatch/opatchapply
17、设定pdb随cdb启动参数alterpluggabledatabaseallsavestate;
18、添加数据文件参考现历史库
--CDB--ALTERDATABASEDATAFILE'/u01/app/oracle/oradata/dwjrdb/system01.dbf'RESIZE1024M;ALTERDATABASEDATAFILE'/u01/app/oracle/oradata/dwjrdb/undotbs01.dbf'RESIZE5120M;ALTERDATABASEDATAFILE'/u01/app/oracle/oradata/dwjrdb/users01.dbf'RESIZE1024M;ALTERDATABASEDATAFILE'/u01/app/oracle/oradata/dwjrdb/sysaux01.dbf'RESIZE8192M;ALTERDATABASETEMPFILE'/u01/app/oracle/oradata/dwjrdb/temp01.dbf'RESIZE1024M;
--增加控制文件--SQL>selectnamefromv$controlfile;/u01/app/oracle/oradata/dwjrdb/control01.ctl/u01/app/oracle/oradata/dwjrdb/control02.ctl--加控制文件altersystemsetcontrol_files='/u01/app/oracle/oradata/dwjrdb/control01.ctl','/u01/app/oracle/oradata/dwjrdb/control02.ctl','/u01/app/oracle/oradata/dwjrdb/control03.ctl'scope=spfile;
/u01/app/oracle/oradata/dwjrdb/control01.ctl/u01/app/oracle/oradata/dwjrdb/control02.ctl/u01/app/oracle/oradata/dwjrdb/control03.ctl
二、ADG的搭建步骤
192.168.1.11dwjrdb--主库
192.168.1.12dwjrstdydb--备库—安装数据库软件，等配置dg后将数据库升级opatch并打补丁
1、修改主备监听文件主库：listener.ora
LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dwjrdb)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))))
SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=dwjrdb)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)(SID_NAME=dwjrdb))(SID_DESC=(GLOBAL_DBNAME=dwjrstdydb)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)(SID_NAME=dwjrstdydb)))
如果配置broker的话，需要新增listener.ora中(SID_DESC=(GLOBAL_DBNAME=dwjrdb_DGMGRL)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)(SID_NAME=dwjrdb))
--tnsnames.ora
dwjrdb=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dwjrdb)))
dwjrstdydb=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.12)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dwjrstdydb)))
--备库
--listener.ora
dwjrstdydb=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=1192.168.1.12)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dwjrstdydb)))
--重新启动主备库监听lsnrctlreload
--测试
tnspingdwjrdbtnspingdwjrstdydbsqlplussys/VgdAJ9ZeNw2B@dwjrdbassysdbasqlplussys/VgdAJ9ZeNw2B@dwjrstdydbassysdba
2、修改主库必要参数（CDB中执行即可）
selectforce_loggingfromv$database;--查询是否开启
alterdatabaseforcelogging;--开启强制记录日志
alterdatabasearchivelog;--开启归档
altersystemsetstandby_file_management=auto;--手动
altersystemsetlog_archive_dest_1='location=/u01/archvalid_for=(all_logfiles,all_roles)db_unique_name=dwjrdb'scope=spfile;--开启本地归档
altersystemsetlog_archive_dest_2='SERVICE=dwjrstdydbLGWRASYNCvalid_for=(all_logfiles,all_roles)db_unique_name=dwjrstdydb'scope=spfile;--开启远程归档
altersystemsetlog_archive_config='dg_config=(dwjrdb,dwjrstdydb)';--开启DG功能
altersystemsetfal_client='dwjrdb';--指定源端
altersystemsetfal_server='dwjrstdydb';--指定目标端
altersystemsetlog_archive_dest_state_2=enable;--启动应用
altersystemsetlog_archive_dest_state_1=enable;--启动应用
altersystemsetlog_archiveformat='dwjrdb%t%s_%r.dbf'scope=spfile;--指定归档文件形式
--源端--先写备端地址，在写源端地址
altersystemsetdb_file_name_convert='/u01/app/oracle/oradata/dwjrstdydb/','/u01/app/oracle/oradata/dwjrdb/'scope=spfile;altersystemsetlog_file_name_convert='/u01/app/oracle/oradata/dwjrstdydb/','/u01/app/oracle/oradata/dwjrdb/'scope=spfile;
selectbytes/1024/1024fromv$log;--查询日志大小
selectmemberfromv$logfile;--查询日志位置
selectGROUP#,BYTES/1024/1024/1024Gfromv$log;--查询组的个数，以及大小
selectgroup#,thread#,members,archived,statusfromv$log;--查询当前使用的是那个日志组
--添加standbylogfile
alterdatabaseaddstandbylogfilegroup6('/u01/app/oracle/oradata/dwjrdb/standby06a.log','/u01/app/oracle/oradata/dwjrdb/standby06b.log')size1G;alterdatabaseaddstandbylogfilegroup7('/u01/app/oracle/oradata/dwjrdb/standby07a.log','/u01/app/oracle/oradata/dwjrdb/standby07b.log')size1G;alterdatabaseaddstandbylogfilegroup8('/u01/app/oracle/oradata/dwjrdb/standby08a.log','/u01/app/oracle/oradata/dwjrdb/standby08b.log')size1G;alterdatabaseaddstandbylogfilegroup9('/u01/app/oracle/oradata/dwjrdb/standby09a.log','/u01/app/oracle/oradata/dwjrdb/standby09b.log')size1G;alterdatabaseaddstandbylogfilegroup10('/u01/app/oracle/oradata/dwjrdb/standby10a.log','/u01/app/oracle/oradata/dwjrdb/standby10b.log')size1G;alterdatabaseaddstandbylogfilegroup11('/u01/app/oracle/oradata/dwjrdb/standby11a.log','/u01/app/oracle/oradata/dwjrdb/standby11b.log')size1G;
---重启主库数据库，使修改参数生效
shutimmediate;
startup
---生成pfile文件
createpfilefromspfile;
---传递密码文件
cd$ORACLE_HOME/dbs
scporapwdwjrdb192.168.1.12:/u01/app/oracle/product/12.2.0/db_1/dbs/orapwdwjrstdydb
---传递参数文件cd$ORACLE_HOME/dbsscpinitdwjrdb.ora192.168.1.12:/u01/app/oracle/product/12.2.0/db_1/dbs/initdwjrstdydb.ora
--创建audit_file_dest目录（改成备库的）
mkdir-p/u01/app/oracle/admin/dwjrstdydb/adump
--创建control_files路径
mkdir-p/u01/app/oracle/oradata/dwjrstdydb
--修改db_file_name_convert、log_file_name_convert路径
.db_file_name_convert='/u01/app/oracle/oradata/dwjrdb','/u01/app/oracle/oradata/dwjrstdydb'.log_file_name_convert='/u01/app/oracle/oradata/dwjrdb','/u01/app/oracle/oradata/dwjrstdydb'
--添加db_unique_name参数
*.db_unique_name='dwjrstdydb'
---修改下列参数
.fal_client='dwjrstdydb'.fal_server='dwjrdb'
*.log_archive_dest_1='location=/u01/archvalid_for=(all_logfiles,all_roles)db_unique_name=dwjrstdydb'
*.log_archive_dest_2=''
*.log_archiveformat='dwjrstdydb%t%s%r.arc'
--修改备库控制文件的路径，因为是复制过来的，控制文件目录还是原端的
--启动备库到nomount
startupnomount;
4、主库执行恢复操作
rmantargetsys/VgdAJ9ZeNw2B@dwjrdbauxiliarysys/VgdAJ9ZeNw2B@dwjrstdydb
duplicatetargetdatabaseforstandbynofilenamecheckfromactivedatabase;--返回结果datafile10switchedtodatafilecopyinputdatafilecopyRECID=10STAMP=980117877filename=/u01/app/oracle/oradata/dwjrstdydb/dwjrdbpdb/undotbs01.dbfdatafile11switchedtodatafilecopyinputdatafilecopyRECID=11STAMP=980117877filename=/u01/app/oracle/oradata/dwjrstdydb/dwjrdbpdb/users01.dbfdatafile12switchedtodatafilecopyinputdatafilecopyRECID=12STAMP=980117877filename=/u01/app/oracle/oradata/dwjrstdydb/dwjrdbpdb/undotbs02.dbfdatafile13switchedtodatafilecopyinputdatafilecopyRECID=13STAMP=980117877filename=/u01/app/oracle/oradata/dwjrstdydb/dwjrdbpdb/undotbs03.dbfdatafile14switchedtodatafilecopyinputdatafilecopyRECID=14STAMP=980117877filename=/u01/app/oracle/oradata/dwjrstdydb/dwjrdbpdb/undotbs04.dbfFinishedDuplicateDbat29-JUN-18
---上面操作完成，备库就处于mount状态
alterdatabaseopen;---起主库
---备库应用日志
alterdatabaserecovermanagedstandbydatabaseusingcurrentlogfiledisconnectfromsession;
alterdatabaserecovermanagedstandbydatabasecancel;---取消应用
--查询备库日志是否应用
selectsequence#,appliedfromv$archived_log;
---查询备库进程是否正常
selectprocess,client_process,sequence#,statusfromv$managed_standby;
SQL>selectprocess,status,thread#,sequence#,block#,blocksfromv$managed_standby;
PROCESSSTATUSTHREAD#SEQUENCE#BLOCK#BLOCKS
MRP0APPLYING_LOG1110862097152
---查询主备库状态
selectDATABASE_ROLE,SWITCHOVER_STATUSfromv$database;
5、验证
--创建一个测试表a；进行增删改操作；在备库验证是否同步createtablea(aint);
三、配置dgborker1、修改主备库监听文件，tns文件。
主库listener.oraSID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=dwjrdb)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)(SID_NAME=dwjrdb))(SID_DESC=(GLOBAL_DBNAME=dwjrstdydb)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)(SID_NAME=dwjrstdydb))(SID_DESC=(GLOBAL_DBNAME=dwjrdb_DGMGRL)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)(SID_NAME=dwjrdb)))
备库listener.oraSID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=dwjrdb)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)(SID_NAME=dwjrdb))(SID_DESC=(GLOBAL_DBNAME=dwjrstdydb)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)(SID_NAME=dwjrstdydb))(SID_DESC=(GLOBAL_DBNAME=dwjrstdydb_DGMGRL)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)(SID_NAME=dwjrstdydb)))
主库tnsname文件中pdb是初建时候ip为11.11[oracle@dwjrdb~]$more/u01/app/oracle/product/12.2.0/db_1/network/admin/tnsnames.oraDWJRDBPDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DWJRDBPDB)))备库tnsnames。ora文件中是初建时候，所以ip为11.11，改为11.12[oracle@dwjrstdydbadmin]$vitnsnames.oraDWJRDBPDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.12)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DWJRDBPDB)))
2、两边实例均设置dg_broker_start=true;primary:altersystemsetdg_broker_start=true;
standby:altersystemsetdg_broker_start=true;
dgmgrlsys/VgdAJ9ZeNw2B@dwjrdbcreateCONFIGURATIONdwjrdb_dgasprimarydatabaseisdwjrdbCONNECTIDENTIFIERISdwjrdb;adddatabasedwjrstdydbasCONNECTIDENTIFIERISdwjrstdydbMAINTAINEDASPHYSICAL;enableconfiguration;showconfiguration;switchovertodwjrstdydb;switchovertodwjrdb;showdatabaseverbosedwjrstdydb
--下面执行过程发现报错，备库用的是主库的pfile直接修改，但是主库是spfile，备库是pfile[oracle@dwjrdb~]$dgmgrlsys/VgdAJ9ZeNw2B@dwjrdbDGMGRLforLinux:Release12.2.0.1.0-ProductiononMonJul210:48:322018
WelcometoDGMGRL,type"help"forinformation.Connectedto"dwjrdb"ConnectedasSYSDBA.DGMGRL>createCONFIGURATIONdwjrdb_dgasprimarydatabaseisdwjrdbCONNECTIDENTIFIERISdwjrdb;Configuration"dwjrdb_dg"createdwithprimarydatabase"dwjrdb"DGMGRL>adddatabasedwjrstdydbasCONNECTIDENTIFIERISdwjrstdydbMAINTAINEDASPHYSICAL;Database"dwjrstdydb"addedDGMGRL>enableconfiguration;Enabled.DGMGRL>showconfiguration;
Configuration-dwjrdb_dg
ProtectionMode:MaxPerformanceMembers:dwjrdb-Primarydatabasedwjrstdydb-PhysicalstandbydatabaseError:ORA-16797:memberisnotusingaserverparameterfile
Fast-StartFailover:DISABLED
ConfigurationStatus:ERROR(statusupdated1secondago)
DGMGRL>
--两边的参数文件不一致，主库是spfile，备库是pfile，所以生成备库的spfile，然后重启实例；
DGMGRL>removedatabasedwjrdb;
DGMGRL>removedatabasedwjrstdydb;
DGMGRL>removeconfiguration;
--删掉后备库参数dg_broker_start失效，且报错；SQL>showparameterdg_broker_start
NAMETYPEVALUE
dg_broker_startbooleanFALSESQL>altersystemsetdg_broker_start=true;--重新执行上面的命令createCONFIGURATIONdwjrdb_dgasprimarydatabaseisdwjrdbCONNECTIDENTIFIERISdwjrdb;adddatabasedwjrstdydbasCONNECTIDENTIFIERISdwjrstdydbMAINTAINEDASPHYSICAL;enableconfiguration;--具体过程[oracle@dwjrdbtrace]$dgmgrlsys/VgdAJ9ZeNw2B@dwjrdbDGMGRLforLinux:Release12.2.0.1.0-ProductiononMonJul214:55:532018
WelcometoDGMGRL,type"help"forinformation.Connectedto"dwjrdb"ConnectedasSYSDBA.DGMGRL>adddatabasedwjrstdydbasCONNECTIDENTIFIERISdwjrstdydbMAINTAINEDASPHYSICAL;Database"dwjrstdydb"addedDGMGRL>enableconfiguration;Enabled.DGMGRL>showconfiguration;
ProtectionMode:MaxPerformanceMembers:dwjrdb-Primarydatabasedwjrstdydb-Physicalstandbydatabase(disabled)ORA-16795:thestandbydatabaseneedstobere-created--新报错
ConfigurationStatus:SUCCESS(statusupdated5secondsago)
DGMGRL>showdatabasedwjrstdydb
Database-dwjrstdydb
Role:PHYSICALSTANDBYIntendedState:APPLY-ONTransportLag:(unknown)ApplyLag:(unknown)AverageApplyRate:(unknown)RealTimeQuery:OFFInstance(s):dwjrstdydb
DatabaseStatus:ORA-16795:thestandbydatabaseneedstobere-created--解决方法DGMGRL>enabledatabasedwjrstdydbEnabled.DGMGRL>showdatabasedwjrstdydb
Role:PHYSICALSTANDBYIntendedState:APPLY-ONTransportLag:0seconds(computed8secondsago)ApplyLag:0seconds(computed8secondsago)AverageApplyRate:5.00KByte/sRealTimeQuery:ONInstance(s):dwjrstdydb
DatabaseStatus:SUCCESS
DGMGRL>showdatabaseverbosedwjrstdydb
Role:PHYSICALSTANDBYIntendedState:APPLY-ONTransportLag:0seconds(computed11secondsago)ApplyLag:0seconds(computed11secondsago)AverageApplyRate:5.00KByte/sActiveApplyRate:(unknown)MaximumApplyRate:(unknown)RealTimeQuery:ONInstance(s):dwjrstdydb
Logfilelocations:Alertlog:/u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/alert_dwjrstdydb.logDataGuardBrokerlog:/u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/drcdwjrstdydb.log
--切换将主库切到备库switchovertodwjrstdydb;
DGMGRL>switchovertodwjrstdydb;PerformingswitchoverNOW,pleasewait...Operationrequiresaconnectiontodatabase"dwjrstdydb"Connecting...Connectedto"dwjrstdydb"ConnectedasSYSDBA.Newprimarydatabase"dwjrstdydb"isopening...Operationrequiresstartupofinstance"dwjrdb"ondatabase"dwjrdb"Startinginstance"dwjrdb"...ORACLEinstancestarted.Databasemounted.Databaseopened.Connectedto"dwjrdb"Switchoversucceeded,newprimaryis"dwjrstdydb"
switchovertodwjrdb;
DGMGRL>switchovertodwjrdb;PerformingswitchoverNOW,pleasewait...Newprimarydatabase"dwjrdb"isopening...Operationrequiresstartupofinstance"dwjrstdydb"ondatabase"dwjrstdydb"Startinginstance"dwjrstdydb"...ORACLEinstancestarted.Databasemounted.Databaseopened.Connectedto"dwjrstdydb"Switchoversucceeded,newprimaryis"dwjrdb"
--测试删除testpdbSQL>alterpluggabledatabaseTESTPDBclose;
Pluggabledatabasealtered.
SQL>showpdbs;
CON_IDCON_NAMEOPENMODERESTRICTED2PDB$SEEDREADONLYNO3DWJRDBPDBREADWRITENO5TESTPDBMOUNTEDSQL>droppluggabledatabaseTESTPDBincludingdatafiles;--包括数据文件全部删除备库查询SQL>showpdbs;
CON_IDCON_NAMEOPENMODERESTRICTED2PDB$SEEDREADONLYNO3DWJRDBPDBREADONLYNO5TESTPDBREADONLYNOSQL>showpdbs;
CON_IDCON_NAMEOPENMODERESTRICTED2PDB$SEEDREADONLYNO3DWJRDBPDBREADONLYNO--创建home下的软连接ln-s/u01/app/oracle/diag/rdbms/dwjrdb/dwjrdb/tracetrace
生产环境部署完成，该12CDG环境已经可以实现切换主备，数据同步一致。让小白参考此文档也可以搭出自己的DG~