Oracle+dataguard Step+by+Step.docx
- 文档编号:7226120
- 上传时间:2023-01-22
- 格式:DOCX
- 页数:14
- 大小:18.87KB
Oracle+dataguard Step+by+Step.docx
《Oracle+dataguard Step+by+Step.docx》由会员分享,可在线阅读,更多相关《Oracle+dataguard Step+by+Step.docx(14页珍藏版)》请在冰豆网上搜索。
Oracle+dataguardStep+by+Step
一、准备工作
1.1设置主库的forcelogging模式
SQL>alterdatabaseforcelogging;
Databasealtered.
1.2创建主库密码文件
$orapwdfile=orapw$ORACLE_SIDpassword=thunisentries=4
1.3配置主库standbyredolog,并验证结果
SQL>alterdatabaseaddstandbylogfilegroup4('/u01/app/oradata/guard1/redo04.log')size50m;
Databasealtered.
SQL>selectgroup#,thread#,sequence#,archived,statusfromv$standby_log;
GROUP#THREAD#SEQUENCE#ARCSTATUS
-------------------------------------------
400YESUNASSIGNED
1.4配置主库初始化参数文件
DB_NAME=guard1
DB_UNIQUE_NAME=guard1
LOG_ARCHIVE_CONFIG='DG_CONFIG=(guard1,guard2)'
LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/flash_recovery_area/GUARD1/archVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=guard1'
LOG_ARCHIVE_DEST_2='SERVICE=guard2LGWRASYNCVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=guard2'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
/*以下部分为主机切换为备库使用*/
FAL_SERVER=guard2
FAL_CLIENT=guard1
DB_FILE_NAME_CONVERT='guard2','guard1'
LOG_FILE_NAME_CONVERT='/u01/app/oradata/guard2','/u01/app/oradata/guard1'
STANDBY_FILE_MANAGEMENT=AUTO
1.5确认主库的归档模式
SQL>startupmount
ORACLEinstancestarted.
TotalSystemGlobalArea104857600bytes
FixedSize1217980bytes
VariableSize96471620bytes
DatabaseBuffers4194304bytes
RedoBuffers2973696bytes
Databasemounted.
SQL>alterdatabasearchivelog;
Databasealtered.
SQL>archiveloglist;
DatabaselogmodeArchiveMode
AutomaticarchivalEnabled
ArchivedestinationUSE_DB_RECOVERY_FILE_DEST
Oldestonlinelogsequence23
Nextlogsequencetoarchive25
Currentlogsequence25
二、创建主库相关文件的备份
2.1创建主库数据文件的物理备份(这里采用tar方式)
$cd/u01/app/oradata
$tar-cvfguard1.targuard1
guard1/
guard1/temp01.dbf
guard1/control01.ctl
guard1/system01.dbf
guard1/sysaux01.dbf
guard1/control02.ctl
guard1/undotbs01.dbf
guard1/redo03.log
guard1/redo01.log
guard1/redo02.log
guard1/control03.ctl
guard1/example01.dbf
guard1/users01.dbf
guard1/redo04.log
[oracle@test01oradata]$ll*tar
-rw-r--r--1oracledba1133783040Oct2816:
48guard1.tar
2.2为备库创建控制文件
SQL>STARTUPMOUNT;
SQL>ALTERDATABASECREATESTANDBYCONTROLFILEAS'/tmp/control01.ctl';
2.3为备库创建初始化参数文件
SQL>CREATEPFILE='/tmp/initguard1.ora'FROMSPFILE;
2.4将tar包以及主库控制文件和参数文件ftp到备库
#ftp192.168.0.88
Connectedto192.168.0.88.
220(vsFTPd2.0.1)
530PleaseloginwithUSERandPASS.
KERBEROS_V4rejectedasanauthenticationtype
Name(192.168.0.88:
root):
oracle
331Pleasespecifythepassword.
Password:
230Loginsuccessful.
RemotesystemtypeisUNIX.
Usingbinarymodetotransferfiles.
ftp>cd/u01/app/oradata
250Directorysuccessfullychanged.
ftp>pwd
257"/u01/app/oradata"
ftp>lcd/home/oracle
Localdirectorynow/home/oracle
ftp>getguard1.tar
local:
guard1.tarremote:
guard1.tar
227EnteringPassiveMode(192,168,0,88,240,125)
150OpeningBINARYmodedataconnectionforguard1.tar(1133783040bytes).
226FilesendOK.
1133783040bytesreceivedin2.6e+02seconds(4.3e+03Kbytes/s)
ftp>cd/tmp
250Directorysuccessfullychanged.
ftp>ls
227EnteringPassiveMode(192,168,0,88,31,48)
150Herecomesthedirectorylisting.
-rw-------15005000Oct2808:
076GXyHcjG4Y
-rw-rw-rw-15005000Oct2808:
05EM_TARGET_INSTALLER.lk
-rw-r-----150050020Oct2807:
55LinuxVendor_output.txt
-rw-r-----15005006832128Oct2808:
52control.ctl
-rw-r-----1500500444Oct2807:
55cpuinfo.txt
-rw-------15005000Oct2808:
07cyzsdX1KWR
-rw-r-----150050018Oct2807:
55glibc.txt
-rw-r--r--1500500881Oct2808:
57initguard1.ora
drwx------2004096Sep2701:
52keyring-606Cr9
srwxr-xr-x1000Oct2807:
52mapping-root
-rw-r-----150050015998Oct2807:
55pkginfo.txt
-rw-r-----1500500100Oct2807:
55swapinfo.txt
-rw-r-----150050011Oct2807:
55tmpFileKernelParms.txt
226DirectorysendOK.
ftp>mget*ctl
mgetcontrol.ctl?
y
227EnteringPassiveMode(192,168,0,88,220,219)
150OpeningBINARYmodedataconnectionforcontrol.ctl(6832128bytes).
226FilesendOK.
6832128bytesreceivedin0.83seconds(8e+03Kbytes/s)
ftp>mget*ora
mgetinitguard1.ora?
y
227EnteringPassiveMode(192,168,0,88,99,183)
150OpeningBINARYmodedataconnectionforinitguard1.ora(881bytes).
226FilesendOK.
881bytesreceivedin0.0042seconds(2.1e+02Kbytes/s)
ftp>bye
221Goodbye.
三、设置备库
3.1解压主库数据文件到备库相应位置
$cd$ORACLE_BASE/oradata
$tar-xvfguard1.tar
guard1/
guard1/temp01.dbf
guard1/control01.ctl
guard1/system01.dbf
guard1/sysaux01.dbf
guard1/control02.ctl
guard1/undotbs01.dbf
guard1/redo03.log
guard1/redo01.log
guard1/redo02.log
guard1/control03.ctl
guard1/example01.dbf
guard1/users01.dbf
guard1/redo04.log
$mvguard1guard2
$cp/tmp/control01.ctl$ORACLE_BASE/oradata/guard1
$cp/tmp/initguard2.ora$ORACLE_HOME/dbs
3.2修改参数文件
--参照前面主库参数文件的配置,值得一提的是db_name参数不能修改,保持和主库一致
3.3创建相关目录
$cd$ORACLE_BASE/admin
$mkdirguard2
$cdguard2
$mkdiradumpbdumpcdumpudump
3.4创建备库密码文件
$orapwdfile=$ORACLE_HOME/dbs/orapw$ORACLE_SIDpassword=thunisentries=4
四、创建主备库监听及tnsnames文件
4.1监听文件
$catlistener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=test)
(SID_NAME=test)
)
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
(PROGRAM=extproc)
)
)
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=test01)(PORT=1521))
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
)
)
4.2tnsnames.ora文件
$cattnsnames.ora
GUARD2=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.99)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=guard2)
)
)
EXTPROC_CONNECTION_DATA=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
)
(CONNECT_DATA=
(SID=PLSExtProc)
(PRESENTATION=RO)
)
)
4.3分别启动主备库监听
五、测试主备库之间的网络连通性
5.1tnsping测试
$hostname
test02
$tnspingguard1
TNSPingUtilityforLinux:
Version10.2.0.1.0-Productionon28-OCT-200821:
14:
18
Copyright(c)1997,2005,Oracle.Allrightsreserved.
Usedparameterfiles:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
UsedTNSNAMESadaptertoresolvethealias
Attemptingtocontact(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.88)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=guard1)))
OK(30msec)
$hostname
test01
$tnspingguard2
TNSPingUtilityforLinux:
Version10.2.0.1.0-Productionon28-OCT-200821:
14:
18
Copyright(c)1997,2005,Oracle.Allrightsreserved.
Usedparameterfiles:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
UsedTNSNAMESadaptertoresolvethealias
Attemptingtocontact(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.89)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=guard1)))
OK(30msec)
5.2sqlplus登录测试
[oracle@test02guard2]$sqlplus'sys/thunis@guard1'assysdba
SQL*Plus:
Release10.2.0.1.0-ProductiononTueOct2822:
24:
592008
Copyright(c)1982,2005,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-Production
WiththePartitioning,OLAPandDataMiningoptions
SQL>
[oracle@test01guard1]$sqlplus'sys/thunis@guard2'assysdba
SQL*Plus:
Release10.2.0.1.0-ProductiononTueOct2822:
24:
592008
Copyright(c)1982,2005,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-Production
WiththePartitioning,OLAPandDataMiningoptions
SQL>
六、启动备用数据库
SQL>startupnomount;
ORACLEinstancestarted.
TotalSystemGlobalArea167772160bytes
FixedSize1218316bytes
VariableSize62916852bytes
DatabaseBuffers100663296bytes
RedoBuffers2973696bytes
SQL>alterdatabasemountstandbydatabase;
Databasealtered.
SQL>alterdatabaserecovermanagedstandbydatabasedisconnectfromsession;
Databasealtered.
--至此,一个完整的physicalstandbydatabase就配置完成了。
七、验证归档日志应用情况
7.1通过数据字典视图验证
--主库执行
SQL>startup
ORACLEinstancestarted.
TotalSystemGlobalArea167772160bytes
FixedSize1218316bytes
VariableSize67111156bytes
DatabaseBuffers96468992bytes
RedoBuffers2973696bytes
Databasemounted.
Databaseopened.
SQL>selectsequence#,first_time,next_time,applied,falfromv$archived_logorderbysequence#;
SEQUENCE#FIRST_TIMNEXT_TIMEAPPFAL
----------------------------------
......
628-OCT-0828-OCT-08NONO
628-OCT-0828-OCT-08YESYES
728-OCT-0828-OCT-08NONO
SEQUENCE#FIRST_TIMNEXT_TIMEAPPFAL
----------------------------------
728-OCT-0828-OCT-08YESYES
828-OCT-0828-OCT-08YESYES
828-OCT-0828-OCT-08NONO
928-OCT-0828-OCT-08NONO
928-OCT-0828-OCT-08YESYES
16rowsselected.
7.2查看告警日志文件
--备库上有类似的信息
TueOct2822:
50:
222008
AttempttostartbackgroundManagedStandbyRecoveryprocess(guard2)
MRP0startedwithpid=10,OSid=7262
TueOct2822:
50:
222008
MRP0:
BackgroundManagedStandbyRecoveryprocessstarted(guard2)
ManagedStandbyRecoverynotusingRealTimeApply
MediaRecoveryWaitingforthread1sequence13(intransit)
TueOct2822:
50:
282008
Completed:
alterdatabaserecovermanagedstandbydatabasedisconnectfromsession
TueOct2822:
51:
222008
idledispatcher'D000'terminated,pid=(13,1)
TueOct2822:
52:
082008
RFS[2]:
Possiblenetworkdisconnectwithprimarydatabase
TueOct2822:
52:
122008
RedoShippingClientConnectedasPUBLIC
--ConnectedUserisValid
RFS[3]:
AssignedtoRFSprocess7268
RFS[3]:
Identifieddatabasetypeas'physicalstandby'
RFS[3]:
Successfullyopenedstandbylog4:
'/u01/app/oradata/guard2/redo04.log'
RedoShippingClientConnectedasPUBLIC
--ConnectedUser
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle+dataguard Step+by+Step Oracle dataguard Step by