物理Date Guard配置.docx
- 文档编号:29033678
- 上传时间:2023-07-20
- 格式:DOCX
- 页数:15
- 大小:17.90KB
物理Date Guard配置.docx
《物理Date Guard配置.docx》由会员分享,可在线阅读,更多相关《物理Date Guard配置.docx(15页珍藏版)》请在冰豆网上搜索。
物理DateGuard配置
物理DataGurad配置方法练习总结
环境:
两台机器均为:
RedHatEnterpriseLinuxServerrelease5.4
数据库版本为:
Oracle10g10.2.0
primary机上装oracle软件并创建数据库orcl
standby机上只装oralce软件,无需装数据库
基本配置:
源数据库:
IP:
10.37.1.1
数据库SID:
orcl_p
db_unique_name:
orcl1
standby数据库:
IP:
10.37.1.2
数据库SID:
orcl_s
db_unique_name:
orcl2
配置步骤:
1、配置primary数据库归档,并设置本地归档路径
SQL>shutdownimmediate;
Databaseclosed.
Databasedismounted.
ORACLEinstanceshutdown.
SQL>startupmount
ORACLEinstancestarted.
TotalSystemGlobalArea167772160bytes
FixedSize1218316bytes
VariableSize83888372bytes
DatabaseBuffers79691776bytes
RedoBuffers2973696bytes
Databasemounted.
SQL>alterdatabasearchivelog;
Databasealtered.
SQL>alterdatabaseopen;
Databasealtered.
SQL>altersystemsetlog_archive_dest_1='location=/u01/arch';
Systemaltered.
SQL>archiveloglist
DatabaselogmodeArchiveMode
AutomaticarchivalEnabled
Archivedestination/u01/arch
Oldestonlinelogsequence2
Nextlogsequencetoarchive4
Currentlogsequence4
2、将primary数据库置于forcelogging模式
SQL>selectforce_loggingfromv$database;
FOR
---
NO
SQL>alterdatabaseforcelogging;
Databasealtered.
SQL>selectforce_loggingfromv$database;
FOR
---
YES
3、创建并修改primary数据库的初始化参数文件
SQL>createpfile='/u01/p_pfile.ora'fromspfile;
Filecreated.
[oracle@localhost~]$vi/u01/p_pfile.ora
修改如下内容:
*.db_unique_name=orcl1
*.log_archive_config='dg_config=(orcl1,orcl2)'
*.log_archive_dest_2='service=orcl_s.2_tnsarchvalid_for=(online_logfiles,primary_role)db_unique_name=orcl2'
*.log_archive_dest_state_2=defer
*.fal_server=orcl_s.2_tns
*.fal_client=orcl_p.1_tns
*.db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl_s'
*.log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl_s'
*.standby_file_management=auto
关闭数据库利用修改后的pfile创建spfile
SQL>shutdownimmediate
Databaseclosed.
Databasedismounted.
ORACLEinstanceshutdown.
SQL>!
exportORACLE_SID=orcl_p
SQL>createspfilefrompfile='/u01/p_pfile.ora';
Filecreated.
SQL>startup
ORACLEinstancestarted.
TotalSystemGlobalArea167772160bytes
FixedSize1218316bytes
VariableSize62916852bytes
DatabaseBuffers100663296bytes
RedoBuffers2973696bytes
Databasemounted.
Databaseopened.
4、创建备份:
创建standby的控制文件:
SQL>alterdatabasecreatestandbycontrolfileas'/u01/orcl2control01.ctl';
Databasealtered.
创建所有的数据文件备份(此处仅以users表空间下的数据文件为例,其他数据文件均要备份)
SQL>altertablespaceusersbeginbackup;
Tablespacealtered.
SQL>!
cp/u01/app/oracle/oradata/orcl/users01.dbf/u01
SQL>altertablespaceusersendbackup;
Tablespacealtered.
5、配置primary监听和tns服务
[oracle@localhost~]$cd$ORACLE_HOME/network/admin
[oracle@localhostadmin]$vilistener.ora
配置内容如下:
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=orcl_p)
(ORACLE_HOME=/u01/app/oracle/10.2.0/db_1)
(GLOBAL_DBNAME=orcl_p)
)
)
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.1)(PORT=1521))
)
)
配置tns
[oracle@localhostadmin]$vitnsnames.ora
配置内容如下:
orcl_p.1_tns=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.1)(PORT=1521))
)
(CONNECT_DATA=
(SID=orcl_p)
(SERVER=DEDICATED)
)
)
orcl_s.2_tns=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.2)(PORT=1521))
)
(CONNECT_DATA=
(SID=orcl_s)
(SERVER=DEDICATED)
)
)
此时重启监听后,测试源数据库tns配置
[oracle@localhostadmin]$lsnrctlstop
LSNRCTLforLinux:
Version10.2.0.1.0-Productionon26-FEB-201419:
11:
44
Copyright(c)1991,2005,Oracle.Allrightsreserved.
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.1)(PORT=1521)))
Thecommandcompletedsuccessfully
[oracle@localhostadmin]$lsnrctlstart
LSNRCTLforLinux:
Version10.2.0.1.0-Productionon26-FEB-201419:
11:
53
Copyright(c)1991,2005,Oracle.Allrightsreserved.
Starting/u01/app/oracle/10.2.0/db_1/bin/tnslsnr:
pleasewait...
TNSLSNRforLinux:
Version10.2.0.1.0-Production
Systemparameterfileis/u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
Logmessageswrittento/u01/app/oracle/10.2.0/db_1/network/log/listener.log
Listeningon:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.37.1.1)(PORT=1521)))
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.1)(PORT=1521)))
STATUSoftheLISTENER
------------------------
AliasLISTENER
VersionTNSLSNRforLinux:
Version10.2.0.1.0-Production
StartDate26-FEB-201419:
11:
53
Uptime0days0hr.0min.0sec
TraceLeveloff
SecurityON:
LocalOSAuthentication
SNMPOFF
ListenerParameterFile/u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
ListenerLogFile/u01/app/oracle/10.2.0/db_1/network/log/listener.log
ListeningEndpointsSummary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.37.1.1)(PORT=1521)))
ServicesSummary...
Service"orcl_p"has1instance(s).
Instance"orcl_P",statusUNKNOWN,has1handler(s)forthisservice...
Thecommandcompletedsuccessfully
[oracle@localhostadmin]$tnspingorcl_p.1_tns
TNSPingUtilityforLinux:
Version10.2.0.1.0-Productionon26-FEB-201419:
12:
38
Copyright(c)1997,2005,Oracle.Allrightsreserved.
Usedparameterfiles:
/u01/app/oracle/10.2.0/db_1/network/admin/sqlnet.ora
UsedTNSNAMESadaptertoresolvethealias
Attemptingtocontact(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.1)(PORT=1521)))(CONNECT_DATA=(SID=orcl_p)(SERVER=DEDICATED)))
OK(0msec)
6、standby数据库创建目录结构,并将源数据库的参数文件、备份的控制文件、创建的口令文件copy到相应的位置
7、
[oracle@localhost~]$mkdir-p/u01/arch2
[oracle@localhostu01]$mkdir-p/u01/app/oracle/flash_recovery_area
[oracle@localhost~]$mkdir-p/u01/app/oracle/oradata/orcl_s
[oracle@localhost~]$mkdir-p/u01/app/oracle/admin/orcl_s/{a,b,c,u}dump
[oracle@localhost~]$scp10.37.1.1:
/u01/*.dbf/u01/app/oracle/oradata/orcl_s/
oracle@10.37.1.1'spassword:
example01.dbf100%100MB20.0MB/s00:
05
sysaux01.dbf100%240MB16.0MB/s00:
15
system01.dbf100%480MB14.6MB/s00:
33
undotbs01.dbf100%30MB15.0MB/s00:
02
users01.dbf100%5128KB5.0MB/s00:
01
[oracle@localhost~]$scp10.37.1.1:
/u01/*.ctl/u01/app/oracle/oradata/orcl_s/
oracle@10.37.1.1'spassword:
orcl2control01.ctl100%6896KB6.7MB/s00:
00
[oracle@localhost~]$scp10.37.1.1:
/u01/p_pfile.ora/u01s_pfile.ora
oracle@10.37.1.1'spassword:
p_pfile.ora100%15081.5KB/s00:
00
[oracle@localhost~]$scp10.37.1.1:
/u01/app/oracle/10.2.0/db_1/dbs/orapworcl_p/u01/app/oracle/10.2.0/db_1/dbs/orapworcl_s
oracle@10.37.1.1'spassword:
orapworcl_p100%51205.0KB/s00:
00
7、修改standby数据库的sid为orcl_s并配置copy来的参数文件
[root@localhost~]#vi/u01/s_pfile.ora
需要修改的内容如下:
(没必要照搬,可根据自己的实际情况自行修改,注意红色部分是重点修改的地方)
*.audit_file_dest='/u01/app/oracle/admin/orcl_s/adump'
*.background_dump_dest='/u01/app/oracle/admin/orcl_s/bdump'
*.control_files='/u01/app/oracle/oradata/orcl_s/orcl2control01.ctl','/u01/app/oracle/oradata/orcl_s/orcl2control02.ctl','/u01/app/oracle/oradata/orcl_s/orcl2control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/orcl_s/cdump'
*.user_dump_dest='/u01/app/oracle/admin/orcl_s/udump'
*.db_unique_name=orcl2
*.log_archive_dest_1='location=/u01/arch2'
*.log_archive_dest_2='service=orcl_p.1_tnsarchvalid_for=(online_logfiles,primary_ro
le)db_unique_name=orcl1'
*.log_archive_dest_state_2=enable
*.fal_server=orcl_p.1_tns
*.fal_client=orcl_s.2_tns
8、配置standby数据库的监听和服务名
[oracle@localhostadmin]$cd$ORACLE_HOME/network/admin
[oracle@localhostadmin]$vilistener.ora
#listener.oraNetworkConfigurationFile:
/u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
#GeneratedbyOracleconfigurationtools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=orcl_s)
(ORACLE_HOME=/u01/app/oracle/10.2.0/db_1)
(GLOBAL_DBNAME=orcl_s)
)
)
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.2)(PORT=1521))
)
)
[oracle@localhostadmin]$vitnsnames.ora
#tnsnames.oraNetworkConfigurationFile:
/u01/app/oracle/10.2.0/db_1/network/admin/tnsnames.ora
#GeneratedbyOracleconfigurationtools.
orcl_s.2_tns=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.2)(PORT=1521))
)
(CONNECT_DATA=
(SID=orcl_s)
(SERVER=DEDICATED)
)
)
orcl_p.1_tns=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.1)(PORT=1521))
)
(CONNECT_DATA=
(SID=orcl_p)
(SERVER=DEDICATED)
"tnsnames.ora"36L,764C
配置完成后重启监听服务
[oracle@localhostadmin]$lsnrctlstop
[oracle@localhostadmin]$lsnrctlstart
至此监听和服务配置完成,在primary和standby端用tnsping命令应该能ping都通两个服务,能远程登入两数据库视为配置成功
SQL>connsys/oracle@orcl_p.1_tnsassysdba
Connected.
SQL>connsys/oracle@orcl_s.2_tnsassysdba
Connectedtoanidleinstance.
9、配置stanby数据库并启动到mount状态,并接受归档文件
任意终端连接到standby数据库
[oracle@localhost~]$sqlplussys/oracle@orcl_s.2_tnsassysdba
利用s_pfile.ora常见standby的spfile
SQL>createspfilefrompfile='/u01/s_pfile.ora';
Filecreated.
SQL>startupmount
ORACLEinstancestarted.
TotalSystemGlobalArea167772160bytes
FixedSize1218316bytes
VariableSize62916852bytes
DatabaseBuffers100663296bytes
RedoBuffers2973696bytes
Databasemounted.
连接到primary数据库并设置远程归档路径开启
SQL>connsys/oracle@orcl_p.1_tnsassysdba
Connected.
SQL>altersystemsetlog_archive_dest_state_2=enable;
Systemaltered.
查看归档接受情况
SQL>selectmax(sequence#)fromv$archived_log;
MAX(SEQUENCE#)
--------------
4
SQL>connsys/oracle@orcl_s.2_tnsassysdba
Connected.
SQL>selectmax(sequence#)fromv$archived_log;
MAX(SEQUENCE#)
--------------
4
查看standby的归档路径下是否有源数据库传来的归档日志
SQL>!
ls/u01/arch2
1_4_840520047.dbf
10、primary数据插入,测试standby数据库能否正常接受
primary端创建表并插入数据
SQL>connscott/tiger
Connected.
SQL>createtableDG_TEST(IDVARCHAR2(10));
Tablecreated.
SQL>insertinto
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 物理Date Guard配置 物理 Date Guard 配置