OraclegDataGuard安装实例.docx
- 文档编号:24294760
- 上传时间:2023-05-26
- 格式:DOCX
- 页数:23
- 大小:22.26KB
OraclegDataGuard安装实例.docx
《OraclegDataGuard安装实例.docx》由会员分享,可在线阅读,更多相关《OraclegDataGuard安装实例.docx(23页珍藏版)》请在冰豆网上搜索。
OraclegDataGuard安装实例
Oracle11gDataGuard安装
准备工作
PrimaryServerIP:
192.168.1.11
StandbyServerIP:
192.168.1.12
PrimaryNetServiceName:
dbserver1
StandbyNetServiceName:
dbserver2
PrimaryORACLE_SID=dbserver1
StandbyORACLE_SID=dbserver2
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/db_1
Primary已经存在一个数据库,Standby只要灌好Oracle软件,不需要建立数据库。
PrimaryDataBase已经开启于ArchiveLog模式
PrimaryDB、StandbyDB位于两台不同的机器上
PrimaryDB与StandbyDB的目录结构都相同
1、开启ForceLogging模式(primary)
[oracle@localhostadmin]$sqlplus"/assysdba"
SQL*Plus:
Release11.2.0.1.0ProductiononTueJul1215:
35:
342011
Copyright(c)1982,2009,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
SQL>alterdatabaseforcelogging;
2、创建最新的pfile(primary)
SQL>createpfilefromspfile;
参数文件一般在:
$ORACLE_HOME\dbs\initdbserver1.ora
3、修改初始化参数(primary)
添加以下内容,红色为注释:
即修改$ORACLE_HOME\dbs\initdbserver1.ora参数文件:
dbserver1.__db_cache_size=180355072
dbserver1.__java_pool_size=4194304
dbserver1.__large_pool_size=4194304
dbserver1.__oracle_base='/home/oracle/oracle'#ORACLE_BASEsetfromenvironment
dbserver1.__pga_aggregate_target=100663296
dbserver1.__sga_target=306184192
dbserver1.__shared_io_pool_size=0
dbserver1.__shared_pool_size=109051904
dbserver1.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/dbserver1/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/opt/oracle/oradata/dbserver1/control01.ctl','/opt/oracle/flash_recovery_area/dbserver1/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='dbserver'
*.db_recovery_file_dest='/opt/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4070572032
*.db_unique_name='dbserver1'-->主库和备库的db_unique_name参数不能一样。
*.diagnostic_dest='/opt/oracle'
*.dispatchers='(PROTOCOL=TCP)(SERVICE=dbserver1XDB)'
*.open_cursors=300
*.pga_aggregate_target=100663296
*.processes=1500
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=303038464
*.undo_tablespace='UNDOTBS1'
*.INSTANCE_NAME='primary'
*.DB_NAME='primary'-->db_name在初始化参数文件中已经存在,核对正确即可,不用添加。
*.LOG_ARCHIVE_DEST_1='LOCATION=/opt/ora9/archive_logmandatory'
*.LOG_ARCHIVE_DEST_2='service=dbserver2lgwrsyncAFFIRM'-->(MaximumPerformance模式)
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.LOG_ARCHIVE_FORMAT=%r_%t_%s.arc
*.FAL_SERVER=dbserver1
*.FAL_CLIENT=dbserver2
*.STANDBY_FILE_MANAGEMENT=AUTO
*._log_archive_callout='LOCAL_FIRST=TRUE'-->避免尖峰时间,switchlog太快,系统hang住
*.archive_lag_target=1800
4、复制参数文件和密码文件到StandbyDB(primary)
$scp$ORACLE_HOME/dbs/initdbserver1.oraoracle@192.168.1.12:
$ORACLE_HOME/dbs/initdbserver2.ora
$scp$ORACLE_HOME/dbs/orapwdbserver1oracle@192.168.1.12:
$ORACLE_HOME/dbs/orapwdbserver2
5、修改StandbyDB的参数档(Standby)
即修改$ORACLE_HOME\dbs\initdbserver2.ora参数文件:
dbserver1.__db_cache_size=180355072
dbserver1.__java_pool_size=4194304
dbserver1.__large_pool_size=4194304
dbserver1.__oracle_base='/home/oracle/oracle'
dbserver1.__pga_aggregate_target=100663296
dbserver1.__sga_target=306184192
dbserver1.__shared_io_pool_size=0
dbserver1.__shared_pool_size=109051904
dbserver1.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/dbserver1/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/opt/oracle/oradata/dbserver1/control01.ctl','/opt/oracle/flash_recovery_area/dbserver1/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='dbserver'
*.db_recovery_file_dest='/opt/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4070572032
*.db_unique_name='dbserver2'-->主库和备库的db_unique_name参数不能一样。
*.diagnostic_dest='/home/oracle/oracle'
*.dispatchers='(PROTOCOL=TCP)(SERVICE=dbserver2XDB)'
*.open_cursors=300
*.pga_aggregate_target=100663296
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=303038464
*.undo_tablespace='UNDOTBS1'
*.INSTANCE_NAME='dbserver2'
*.DB_NAME='dbserver'-->需要跟primarydb相同
*.LOG_ARCHIVE_DEST_1='LOCATION=/opt/oracle/archive_logmandatory'
*.LOG_ARCHIVE_DEST_2='service=dbserver1lgwrsyncAFFIRM'-->(MaximumPerformance模式)
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=DEFER-->暂时关闭,等Switchover时才开启。
*.LOG_ARCHIVE_FORMAT=%r_%t_%s.arc
*.FAL_SERVER=dbserver2
*.FAL_CLIENT=dbserver1
*.STANDBY_FILE_MANAGEMENT=AUTO
*._log_archive_callout='LOCAL_FIRST=TRUE'
*.archive_lag_target=1800
6、创建StandbyDB上的相关目录(Standby)
主库上也要有相应的目录
#su-oracle
$mkdir-p$ORACLE_BASE/backup-->用于Rman备份
$mkdir-p$ORACLE_BASE/oradata/dbserver1-->数据库目录
$mkdir-p$ORACLE_BASE/archive_log
$mkdir-p$ORACLE_BASE/oradata/standby_archive_log
$mkdir-p$ORACLE_BASE/admin/dbserver1/bdump
$mkdir-p$ORACLE_BASE/admin/dbserver1/cdump
$mkdir-p$ORACLE_BASE/admin/dbserver1/create
$mkdir-p$ORACLE_BASE/admin/dbserver1/pfile
$mkdir-p$ORACLE_BASE/admin/dbserver1/udump
7、修改primary监听(Primary)
#listener.oraNetworkConfigurationFile:
/opt/oracle/product/db/network/admin/listener.ora
#GeneratedbyOracleconfigurationtools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=/home/oracle/oracle/product/db)
(PROGRAM=extproc)
)
(SID_DESC=
(GLOBAL_DBNAME=dbserver1)
(ORACLE_HOME=/home/oracle/oracle/product/db)
(SID_NAME=dbserver1)
)
(SID_DESC=
(GLOBAL_DBNAME=dbserver2)
(ORACLE_HOME=/home/oracle/oracle/product/db)
(SID_NAME=dbserver2)
)
)
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))
)
)
ADR_BASE_LISTENER=/home/oracle/oracle
配置dgmgrl时的监听:
#listener.oraNetworkConfigurationFile:
/opt/oracle/product/db/network/admin/listener.ora
#GeneratedbyOracleconfigurationtools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=/home/oracle/oracle/product/db)
(PROGRAM=extproc)
)
(SID_DESC=
(ORACLE_HOME=/home/oracle/oracle/product/db)
(SID_NAME=dbserver1)
)
(SID_DESC=
(GLOBAL_DBNAME=dbserver1_DGMGRL)
(ORACLE_HOME=/home/oracle/oracle/product/db)
(SID_NAME=dbserver1)
)
)
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))
)
)
ADR_BASE_LISTENER=/home/oracle/oracle
8、修改standby监听(Standby)
#listener.oraNetworkConfigurationFile:
/opt/oracle/product/db/network/admin/listener.ora
#GeneratedbyOracleconfigurationtools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=/home/oracle/oracle/product/db)
(PROGRAM=extproc)
)
(SID_DESC=
(GLOBAL_DBNAME=dbserver1)
(ORACLE_HOME=/home/oracle/oracle/product/db)
(SID_NAME=dbserver1)
)
(SID_DESC=
(GLOBAL_DBNAME=dbserver2)
(ORACLE_HOME=/home/oracle/oracle/product/db)
(SID_NAME=dbserver2)
)
)
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))
)
)
ADR_BASE_LISTENER=/home/oracle/oracle
配置dgmgrl时的监听:
#listener.oraNetworkConfigurationFile:
/opt/oracle/product/db/network/admin/listener.ora
#GeneratedbyOracleconfigurationtools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=/home/oracle/oracle/product/db)
(PROGRAM=extproc)
)
(SID_DESC=
(ORACLE_HOME=/home/oracle/oracle/product/db)
(SID_NAME=dbserver2)
)
(SID_DESC=
(GLOBAL_DBNAME=dbserver1_DGMGRL.localdomain)
(ORACLE_HOME=/home/oracle/oracle/product/db)
(SID_NAME=dbserver2)
)
)
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))
)
)
ADR_BASE_LISTENER=/home/oracle/oracle
9、修改sqlnet.ora(Standby&Primary)
$ORACLE_HOME/network/admin/sqlnet.ora
NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME)
SQLNET.EXPIRE_TIME=2
SQLNET.ALLOWED_LOGON_VERSION=10
10、修改primarytnsnames.ora(Primary)
#tnsnames.oraNetworkConfigurationFile:
/opt/oracle/product/db/network/admin/tnsnames.ora
#GeneratedbyOracleconfigurationtools.
DBSERVER1=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=dbserver1)
)
)
DBSERVER2=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.12)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=dbserver2)
)
)
11、修改standbytnsnames.ora(Standby)
#tnsnames.oraNetworkConfigurationFile:
/opt/oracle/product/db/network/admin/tnsnames.ora
#GeneratedbyOracleconfigurationtools.
DBSERVER2=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.12)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=dbserver2)
)
)
DBSERVER1=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=dbserver1)
)
)
12、重新启动listener(Primary&Standby)
若有修改listner.ora,才执行这一步
#su-oracle
$lsnrctlstop
$lsnrctlstart
$lsnrctlstatus
13、创建spfile(Standby)
由pfile创出spfile,并且开启StandbyDB于nomount模式
[oracle@localhostadmin]$sqlplus"/assysdba"
SQL*Plus:
Release11.2.0.1.0ProductiononTueJul1215:
35:
342011
Copyright(c)1982,2009,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
SQL>createspfilefrompfile;
Filecreated.
SQL>startupnomount;
ORACLEinstancestarted.
TotalSystemGlobalArea235999648bytes
FixedSize450976bytes
VariableSize201326592bytes
DatabaseBuffers33554432bytes
RedoBuffers667648bytes
SQL>exit
14、备份primary库(Primary)
使用Rman备份Primary数据库,准备Duplicate至StandbyDB
[oracle@dbserver1oracle]$rmantarget/no
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- OraclegDataGuard 安装 实例