11G R2 DG配置.docx
- 文档编号:9792175
- 上传时间:2023-02-06
- 格式:DOCX
- 页数:31
- 大小:25.26KB
11G R2 DG配置.docx
《11G R2 DG配置.docx》由会员分享,可在线阅读,更多相关《11G R2 DG配置.docx(31页珍藏版)》请在冰豆网上搜索。
11GR2DG配置
11GR2DataGaurd
配置如下
主机
odg1
odg2
IP
192.168.10.194
192.168.10.195
OS
OracleEnterpriseLinux5
OracleEnterpriseLinux5
Database
Oracle11GR2
Oracle11GR2
instance
odgp
odgs
试验步骤是首先在Vmware上建立primary主机odg1,安装完成Oraclesoftware(没有createdatabase),然后复制为standby主机odg2;接着在主机odg1上createdatabase,在odg2上使用duplicate复制数据库为standby。
具体步骤如下
1.在虚拟机上建立虚拟机odg1,安装Oracle需要的rpm,然后建立Oracle用户,配置用户环境,Oracle的用户环境sid为odgp,这里省略。
2.上传Oracle安装文件,然后安装数据库software.这里也省略。
3.关闭odg1,然后复制该主机为odg2,记得修改Oracle的用户环境sid为odgs
4.在odg1上createdatabase。
这里省略步骤,不过需要注意的是记得开启archive模式,如果没有,我们也可以手动设定。
然后是使用netca建立listener.ora和tnsnames.ora.具体文件例如:
[oracle@odg1admin]$morelistener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=odgp)
(ORACLE_HOME=/dba/oracle/product/11.2/db_1)
(SID_NAME=odgp)
)
)
LISTENER=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=odg1)(PORT=1521))
)
ADR_BASE_LISTENER=/dba/oracle
[oracle@odg1admin]$moretnsnames.ora
ODGP=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=odg1)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=odgp)
)
)
ODGS=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=odg2)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=odgs)
)
)
5.同样在odg2上建立listener.ora和tnsnames.ora并启动listener。
[oracle@odg2admin]$morelistener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=odgs)
(ORACLE_HOME=/dba/oracle/product/11.2/db_1)
(SID_NAME=odgs)
)
)
LISTENER=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=odg2)(PORT=1521))
)
ADR_BASE_LISTENER=/dba/oracle
[oracle@odg2admin]$moretnsnames.ora
ODGP=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=odg1)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=odgp)
)
)
ODGS=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=odg2)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=odgs)
)
)
6.odg1增加standbylog
alterdatabaseaddstandbylogfilesize50M;
alterdatabaseaddstandbylogfilesize50M;
alterdatabaseaddstandbylogfilesize50M;
alterdatabaseaddstandbylogfilesize50M;
创建适当的日志组
一般而言,standbyredo日志文件组数要比primary数据库的onlineredo日志文件组数至少多一个。
推荐standbyredo日志组数量基于primary数据库的线程数(这里的线程数可以理解为rac结构中的rac节点数)。
有一个推荐的公式可以做参考:
(每线程的日志组数+1)*最大线程数
例如primary数据库有两个线程,每个线程分配两组日志,则standby日志组数建议为6组,使用这个公式可以降低primary数据库实例LGWR进程锁住的可能性。
7.odg2上设定pfile,不需要很多参数,只用简单的DB_NAME就可以了,因为在使用duplicate的时候会生成的spfile启动的。
[oracle@odg2dbs]$moreinitodgs.ora
DB_NAME='odgp'
8.odg2上生成密码文件
orapwdfile=$ORACLE_HOME/dbs/orapwodgspassword=dulumenentries=10
9.odg2上创建文件路径
如在$ORACLE_BASE/admin下建立odgs目录,并在odgs下建立adumpdpdumppfilescripts;建立controlfiledatafileonlinelog路径(可以primary数据库中查询文件路径selectnamefromv$controlfile;selectnamefromv$datafile;selecttype,memberfromv$logfile;)
10.nomount启动standby,rman连接target和auxiliarydatabase.
Sqlplu‘/assysdba’
Startupnomount
[oracle@odg2dbs]$rmantargetsys/dulumen@odgpauxiliarysys/dulumen@odgs
RecoveryManager:
Release11.2.0.1.0-ProductiononMonDec614:
39:
482010
Copyright(c)1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.
connectedtotargetdatabase:
ODGP(DBID=2482389896)
connectedtoauxiliarydatabase:
ODGP(notmounted)
RMAN>run{
duplicatetargetdatabaseforstandbyfromactivedatabase
spfile
parameter_value_convert'odgp','odgs'
setdb_file_name_convert='ODGP','ODGS'#(这里主要是自动建库的时候大写了)
setlog_file_name_convert='ODGP','ODGS'
set'db_unique_name'='odgs'
setcontrol_files='/data/oracle/ODGS/controlfile/o1_mf_6hrsr8vq_.ctl'
nofilenamecheck;
}
日志如下
StartingDuplicateDbat06-DEC-10
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:
ORA_AUX_DISK_1
channelORA_AUX_DISK_1:
SID=19devicetype=DISK
contentsofMemoryScript:
{
backupascopyreuse
targetfile'/dba/oracle/product/11.2/db_1/dbs/orapwodgp'auxiliaryformat
'/dba/oracle/product/11.2/db_1/dbs/orapwodgs'targetfile
'/dba/oracle/product/11.2/db_1/dbs/spfileodgp.ora'auxiliaryformat
'/dba/oracle/product/11.2/db_1/dbs/spfileodgs.ora';
sqlclone"altersystemsetspfile=''/dba/oracle/product/11.2/db_1/dbs/spfileodgs.ora''";
}
executingMemoryScript
Startingbackupat06-DEC-10
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
SID=105devicetype=DISK
Finishedbackupat06-DEC-10
sqlstatement:
altersystemsetspfile=''/dba/oracle/product/11.2/db_1/dbs/spfileodgs.ora''
contentsofMemoryScript:
{
sqlclone"altersystemsetaudit_file_dest=
''/dba/oracle/admin/odgs/adump''comment=
''''scope=spfile";
sqlclone"altersystemsetdb_file_name_convert=
''ODGP'',''ODGS''comment=
''''scope=spfile";
sqlclone"altersystemsetlog_file_name_convert=
''ODGP'',''ODGS''comment=
''''scope=spfile";
sqlclone"altersystemsetdb_unique_name=
''odgs''comment=
''''scope=spfile";
sqlclone"altersystemsetcontrol_files=
''/data/oracle/ODGS/controlfile/o1_mf_6hrsr8vq_.ctl''comment=
''''scope=spfile";
shutdowncloneimmediate;
startupclonenomount;
}
executingMemoryScript
sqlstatement:
altersystemsetaudit_file_dest=''/dba/oracle/admin/odgs/adump''comment=''''scope=spfile
sqlstatement:
altersystemsetdb_file_name_convert=''ODGP'',''ODGS''comment=''''scope=spfile
sqlstatement:
altersystemsetlog_file_name_convert=''ODGP'',''ODGS''comment=''''scope=spfile
sqlstatement:
altersystemsetdb_unique_name=''odgs''comment=''''scope=spfile
sqlstatement:
altersystemsetcontrol_files=''/data/oracle/ODGS/controlfile/o1_mf_6hrsr8vq_.ctl''comment=''''scope=spfile
Oracleinstanceshutdown
connectedtoauxiliarydatabase(notstarted)
Oracleinstancestarted
TotalSystemGlobalArea797523968bytes
FixedSize2217584bytes
VariableSize469764496bytes
DatabaseBuffers322961408bytes
RedoBuffers2580480bytes
contentsofMemoryScript:
{
backupascopycurrentcontrolfileforstandbyauxiliaryformat'/data/oracle/ODGS/controlfile/o1_mf_6hrsr8vq_.ctl';
}
executingMemoryScript
Startingbackupat06-DEC-10
usingchannelORA_DISK_1
channelORA_DISK_1:
startingdatafilecopy
copyingstandbycontrolfile
outputfilename=/dba/oracle/product/11.2/db_1/dbs/snapcf_odgp.ftag=TAG20101206T144108RECID=6STAMP=737044868
channelORA_DISK_1:
datafilecopycomplete,elapsedtime:
00:
00:
01
Finishedbackupat06-DEC-10
contentsofMemoryScript:
{
sqlclone'alterdatabasemountstandbydatabase';
}
executingMemoryScript
sqlstatement:
alterdatabasemountstandbydatabase
contentsofMemoryScript:
{
setnewnamefortempfile1to
"/data/oracle/ODGS/datafile/o1_mf_temp_6hrsst10_.tmp";
switchclonetempfileall;
setnewnamefordatafile1to
"/data/oracle/ODGS/datafile/o1_mf_system_6hrsrf6v_.dbf";
setnewnamefordatafile2to
"/data/oracle/ODGS/datafile/o1_mf_sysaux_6hrss6lf_.dbf";
setnewnamefordatafile3to
"/data/oracle/ODGS/datafile/o1_mf_undotbs1_6hrssoy3_.dbf";
setnewnamefordatafile4to
"/data/oracle/ODGS/datafile/o1_mf_users_6hrst65f_.dbf";
backupascopyreuse
datafile1auxiliaryformat
"/data/oracle/ODGS/datafile/o1_mf_system_6hrsrf6v_.dbf"datafile
2auxiliaryformat
"/data/oracle/ODGS/datafile/o1_mf_sysaux_6hrss6lf_.dbf"datafile
3auxiliaryformat
"/data/oracle/ODGS/datafile/o1_mf_undotbs1_6hrssoy3_.dbf"datafile
4auxiliaryformat
"/data/oracle/ODGS/datafile/o1_mf_users_6hrst65f_.dbf";
sql'altersystemarchivelogcurrent';
}
executingMemoryScript
executingcommand:
SETNEWNAME
renamedtempfile1to/data/oracle/ODGS/datafile/o1_mf_temp_6hrsst10_.tmpincontrolfile
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
Startingbackupat06-DEC-10
usingchannelORA_DISK_1
channelORA_DISK_1:
startingdatafilecopy
inputdatafilefilenumber=00001name=/data/oracle/ODGP/datafile/o1_mf_system_6hrsrf6v_.dbf
outputfilename=/data/oracle/ODGS/datafile/o1_mf_system_6hrsrf6v_.dbftag=TAG20101206T144115
channelORA_DISK_1:
datafilecopycomplete,elapsedtime:
00:
00:
35
channelORA_DISK_1:
startingdatafilecopy
inputdatafilefilenumber=00002name=/data/oracle/ODGP/datafile/o1_mf_sysaux_6hrss6lf_.dbf
outputfilename=/data/oracle/ODGS/datafile/o1_mf_sysaux_6hrss6lf_.dbftag=TAG20101206T144115
channelORA_DISK_1:
datafilecopycomplete,elapsedtime:
00:
00:
25
channelORA_DISK_1:
startingdatafilecopy
inputdatafilefilenumber=00003name=/data/oracle/ODGP/datafile/o1_mf_undotbs1_6hrssoy3_.dbf
outputfilename=/data/oracle/ODGS/datafile/o1_mf_undotbs1_6hrssoy3_.dbftag=TAG20101206T144115
channelORA_DISK_1:
datafilecopycomplete,elapsedtime:
00:
00:
15
channelORA_DISK_1:
startingdatafilecopy
inputdatafilefilenumber=00004name=/data/oracle/ODGP/datafile/o1_mf_users_6hrst65f_.dbf
outputfilename=/data/oracle/ODGS/datafile/o1_mf_users_6hrst65f_.dbftag=TAG20101206T144115
channelORA_DISK_1:
datafilecopycomplete,elapsedtime:
00:
00:
01
Finishedbackupat06-DEC-10
sqlstatement:
altersystemarchivelogcurrent
contentsofMemoryScript:
{
switchclonedatafileall;
}
executingMemoryScript
datafile1switchedtodatafilecopy
inputdatafilecopyRECID=6STAMP=737044952filename=/data/oracle/ODGS/datafile/o1_mf_system_6hrsrf6v_.dbf
datafile2switchedtodatafilecopy
inputdatafilecopyRECID=7STAMP=737044952filename=/data/oracle/ODGS/datafile/o1_mf_sysaux_6hrss6lf_.dbf
datafile3switchedtodatafilecopy
inputdatafilecopyRECID=8STAMP=737044952filename=/data/oracle/ODGS/datafile/o1_mf_undotbs1_6hrssoy3_.dbf
datafile4switchedtodatafilecopy
inputdatafilecopyRECID=9STAMP=737044952filename=/data/oracle/ODGS/datafile/o1_mf_users_6hrst65f_.dbf
FinishedDuplicateDbat06-DEC-10
11.检查standby文件
select
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 11G R2 DG配置 11 DG 配置
![提示](https://static.bdocx.com/images/bang_tan.gif)