使用DGBROKER配置dataguard测试.docx
- 文档编号:15428053
- 上传时间:2023-07-04
- 格式:DOCX
- 页数:18
- 大小:62.71KB
使用DGBROKER配置dataguard测试.docx
《使用DGBROKER配置dataguard测试.docx》由会员分享,可在线阅读,更多相关《使用DGBROKER配置dataguard测试.docx(18页珍藏版)》请在冰点文库上搜索。
使用DGBROKER配置dataguard测试
使用DGBROKER配置dataguard测试
环境准备:
准备两台电脑安装好linuxX64,配置相同的环境变量,安装好oracle数据库软件,做为主端的数据库上建立好一个数据库实例,做为备端的数库库仅装好软件即可。
主、备端都建好监听。
测试:
1、主库开启强制日志
[oracle@ADGTEST1~]$sqlplus/assysdba
SQL*Plus:
Release11.2.0.4.0ProductiononMonJan1615:
02:
172017
Copyright(c)1982,2013,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
SQL>alterdatabaseforcelogging;
Databasealtered.
SQL>
2、主库开归档日志
SQL>shutdownimmediate;
Databaseclosed.
Databasedismounted.
ORACLEinstanceshutdown.
SQL>startupmount;
ORACLEinstancestarted.
TotalSystemGlobalArea1620115456bytes
FixedSize2253704bytes
VariableSize1073745016bytes
DatabaseBuffers536870912bytes
RedoBuffers7245824bytes
Databasemounted.
SQL>alterdatabasearchivelog;
Databasealtered.
SQL>alterdatabaseopen;
Databasealtered.
SQL>
3、主库修改相关数据库参数
a)修改db_unique_name
SQL>altersystemsetdb_unique_name='porcl'scope=spfile;
Systemaltered.
SQL>
b)修改standby_file_management
SQL>altersystemsetstandby_file_management='AUTO'scope=spfile;
Systemaltered.
SQL>
4、主库配置静态网络监听
采用图形方式进行配置,运行netmgr。
\
完成后,保存退出。
注:
“Oracle主目录”框中的路径最后结尾的那个“/”需要删除。
完成后的内容:
[oracle@ADGTEST1~]$cd$ORACLE_HOME/network/admin
[oracle@ADGTEST1admin]$catlistener.ora
#listener.oraNetworkConfigurationFile:
/mnt_array/OracleDB/DB/oracle/network/admin/listener.ora
#GeneratedbyOracleconfigurationtools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=orcl)
(ORACLE_HOME=/mnt_array/OracleDB/DB/oracle)
(SID_NAME=orcl)
)
(SID_DESC=
(GLOBAL_DBNAME=porcl)
(ORACLE_HOME=/mnt_array/OracleDB/DB/oracle)
(SID_NAME=orcl)
)
(SID_DESC=
(GLOBAL_DBNAME=porcl_DGMGRL)
(ORACLE_HOME=/mnt_array/OracleDB/DB/oracle)
(SID_NAME=orcl)
)
)
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=ADGTEST1)(PORT=1521))
)
(DESCRIPTION=
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))
)
)
ADR_BASE_LISTENER=/mnt_array/OracleDB/DB
[oracle@ADGTEST1admin]$
5、主库重启网络监听
[oracle@ADGTEST1admin]$lsnrctlstop
LSNRCTLforLinux:
Version11.2.0.4.0-Productionon16-JAN-201715:
22:
16
Copyright(c)1991,2013,Oracle.Allrightsreserved.
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ADGTEST1)(PORT=1521)))
Thecommandcompletedsuccessfully
[oracle@ADGTEST1admin]$lsnrctlstart
LSNRCTLforLinux:
Version11.2.0.4.0-Productionon16-JAN-201715:
22:
20
Copyright(c)1991,2013,Oracle.Allrightsreserved.
Starting/mnt_array/OracleDB/DB/oracle/bin/tnslsnr:
pleasewait...
TNSLSNRforLinux:
Version11.2.0.4.0-Production
Systemparameterfileis/mnt_array/OracleDB/DB/oracle/network/admin/listener.ora
Logmessageswrittento/mnt_array/OracleDB/DB/diag/tnslsnr/ADGTEST1/listener/alert/log.xml
Listeningon:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ADGTEST1)(PORT=1521)))
Listeningon:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ADGTEST1)(PORT=1521)))
STATUSoftheLISTENER
------------------------
AliasLISTENER
VersionTNSLSNRforLinux:
Version11.2.0.4.0-Production
StartDate16-JAN-201715:
22:
20
Uptime0days0hr.0min.0sec
TraceLeveloff
SecurityON:
LocalOSAuthentication
SNMPOFF
ListenerParameterFile/mnt_array/OracleDB/DB/oracle/network/admin/listener.ora
ListenerLogFile/mnt_array/OracleDB/DB/diag/tnslsnr/ADGTEST1/listener/alert/log.xml
ListeningEndpointsSummary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ADGTEST1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
ServicesSummary...
Service"orcl"has1instance(s).
Instance"orcl",statusUNKNOWN,has1handler(s)forthisservice...
Service"porcl"has1instance(s).
Instance"orcl",statusUNKNOWN,has1handler(s)forthisservice...
Service"porcl_DGMGRL"has1instance(s).
Instance"orcl",statusUNKNOWN,has1handler(s)forthisservice...
Thecommandcompletedsuccessfully
[oracle@ADGTEST1admin]$
可以看到刚才建好的三个静态网络监听。
6、备份数据库
[oracle@ADGTEST1admin]$rmantarget/
RecoveryManager:
Release11.2.0.4.0-ProductiononMonJan1615:
29:
212017
Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.
connectedtotargetdatabase:
ORCL(DBID=1461199451)
RMAN>backupdatabase;
Startingbackupat16-JAN-17
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
SID=14devicetype=DISK
channelORA_DISK_1:
startingfulldatafilebackupset
……
Finishedbackupat16-JAN-17
RMAN>exit
RecoveryManagercomplete.
[oracle@ADGTEST1admin]$
7、建立pfile文件
[oracle@ADGTEST1admin]$sqlplus/assysdba
SQL*Plus:
Release11.2.0.4.0ProductiononMonJan1615:
31:
082017
Copyright(c)1982,2013,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
SQL>createpfilefromspfile;
Filecreated.
SQL>exit
DisconnectedfromOracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
[oracle@ADGTEST1admin]$
8、拷贝参数文件到备库端
[oracle@ADGTEST1admin]$cd$ORACLE_HOME/dbs
[oracle@ADGTEST1dbs]$ls
hc_orcl.datinit.orainitorcl.oralkORCLorapworclsnapcf_orcl.fspfileorcl.ora
[oracle@ADGTEST1dbs]$pwd
/mnt_array/OracleDB/DB/oracle/dbs
[oracle@ADGTEST1dbs]$scpinitorcl.oraorapworcl192.168.0.115:
/mnt_array/OracleDB/DB/oracle/dbs
Address192.168.0.115mapstobogon,butthisdoesnotmapbacktotheaddress-POSSIBLEBREAK-INATTEMPT!
oracle@192.168.0.115'spassword:
initorcl.ora100%10871.1KB/s00:
00
orapworcl100%15361.5KB/s00:
00
[oracle@ADGTEST1dbs]$
9、备库配置静态网络监听
采用图形方式进行配置,运行netmgr。
完成后,保存退出。
注:
“Oracle主目录”框中的路径最后结尾的那个“/”需要删除。
10、备库重启网络监听
[oracle@TestLinux~]$lsnrctlstop
LSNRCTLforLinux:
Version11.2.0.4.0-Productionon16-JAN-201715:
49:
06
Copyright(c)1991,2013,Oracle.Allrightsreserved.
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TestLinux)(PORT=1521)))
Thecommandcompletedsuccessfully
[oracle@TestLinux~]$lsnrctlstart
LSNRCTLforLinux:
Version11.2.0.4.0-Productionon16-JAN-201715:
49:
14
Copyright(c)1991,2013,Oracle.Allrightsreserved.
Starting/mnt_array/OracleDB/DB/oracle/bin/tnslsnr:
pleasewait...
TNSLSNRforLinux:
Version11.2.0.4.0-Production
Systemparameterfileis/mnt_array/OracleDB/DB/oracle/network/admin/listener.ora
Logmessageswrittento/mnt_array/OracleDB/DB/diag/tnslsnr/TestLinux/listener/alert/log.xml
Listeningon:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TestLinux)(PORT=1521)))
Listeningon:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TestLinux)(PORT=1521)))
STATUSoftheLISTENER
------------------------
AliasLISTENER
VersionTNSLSNRforLinux:
Version11.2.0.4.0-Production
StartDate16-JAN-201715:
49:
14
Uptime0days0hr.0min.0sec
TraceLeveloff
SecurityON:
LocalOSAuthentication
SNMPOFF
ListenerParameterFile/mnt_array/OracleDB/DB/oracle/network/admin/listener.ora
ListenerLogFile/mnt_array/OracleDB/DB/diag/tnslsnr/TestLinux/listener/alert/log.xml
ListeningEndpointsSummary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TestLinux)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
ServicesSummary...
Service"orcl"has1instance(s).
Instance"orcl",statusUNKNOWN,has1handler(s)forthisservice...
Service"sorcl"has1instance(s).
Instance"sorcl",statusUNKNOWN,has1handler(s)forthisservice...
Service"sorcl_DGMGRL"has1instance(s).
Instance"orcl",statusUNKNOWN,has1handler(s)forthisservice...
Thecommandcompletedsuccessfully
[oracle@TestLinux~]$
11、备库修改initorcl.ora文件
[oracle@TestLinux~]$cd$ORACLE_HOME/dbs
[oracle@TestLinuxdbs]$ls
init.orainitorcl.oraorapworcl
[oracle@TestLinuxdbs]$viinitorcl.ora
修改内容:
(因为主库和备库环境一样,所有的路径也一样,所以只需要修改db_unique_name参数)
*.db_unique_name='porcl'--->*.db_unique_name='sorcl'
12、备库如果有spfileorcl.ora文件,删除。
[oracle@TestLinuxdbs]$ls
init.orainitorcl.oraorapworcl
[oracle@TestLinuxdbs]$
因为没有建立数据库,所以这里现在没有该文件。
13、备库跟据initorcl.ora内容建立相关文件夹
[oracle@TestLinuxdbs]$grep"/DB/"initorcl.ora
*.audit_file_dest='/mnt_array/OracleDB/DB/admin/orcl/adump'
*.control_files='/mnt_array/OracleDB/DB/oradata/orcl/control01.ctl','/mnt_array/OracleDB/DB/fast_recovery_area/orcl/control02.ctl'
*.db_recovery_file_dest='/mnt_array/OracleDB/DB/fast_recovery_area'
[oracle@TestLinuxdbs]$mkdir/mnt_array/OracleDB/DB/admin/orcl/adump-p
[oracle@TestLinuxdbs]$mkdir/mnt_array/OracleDB/DB/oradata/orcl-p
[oracle@TestLinuxdbs]$mkdir/mnt_array/OracleDB/DB/fast_recovery_area/orcl-p
14、备库启动数据库到nomount状态
[oracle@TestLinuxdbs]$sqlplus/assysdba
SQL*Plus:
Release11.2.0.4.0ProductiononMonJan1616:
00:
242017
Copyright(c)1982,2013,Oracle.Allrightsreserved.
Connectedtoanidleinstance.
SQL>startupnomount;
ORACLEinstancestarted.
TotalSystemGlobalArea1620115456bytes
FixedSize2253704bytes
VariableSize1073745016bytes
DatabaseBuffers536870912bytes
RedoBuffers7245824bytes
SQL>
15、备库将pfile转为spfile,再重启数据库到nomount状态
SQL>createspfilefrompfile;
Filecreated.
SQL>shutdownimmediate;
ORA-01507:
databasenotmounted
ORACLEinstanceshutdown.
SQL>startupnomount;
ORACLEinstancestarted.
TotalSystemGlobalArea1620115456bytes
FixedSize2253704bytes
VariableSize1073745016bytes
DatabaseBuffers536870912bytes
RedoBuffers
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 使用 DGBROKER 配置 dataguard 测试