使用Active database duplicate 建立dataguard
环境:
hostname IP Database DB_UNIQUE_NAME Oracle
tns name
RAC1 192.168.2.101/3.101 Primary ogg ogg
RAC2 192.168.2.201/3.201 Physical
standby tgg tgg
1.确认主库为归档模式
ARCHIVELOG LIST
2.开启FORCELOGGING
ALTERDATABASE FORCE LOGGING;
3.配置日志传输的认证
本例使用oraclepassword file认证
确保remote_login_passwordfile为EXCLUSIVE后者 SHARED
在主库生成oracle密码文件
orapwdfile=orapwogg password=oracle entries=5
scporapwogg oracle@192.168.2.201:@ORACLE_HOME/dbs/
在备库更改密码文件名字,注意这个文件名更改步骤跟10G有区别了
mvorapwogg orapwtgg
4.设置主库初始化参数
altersystem set LOG_ARCHIVE_CONFIG='DG_CONFIG=(ogg,tgg)';
altersystem set LOG_ARCHIVE_DEST_1='LOCATION=/u01/arch/ogg/VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ogg';
altersystem set LOG_ARCHIVE_DEST_2='SERVICE=tgg LGWR SYNCVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=tgg';
altersystem set LOG_ARCHIVE_DEST_STATE_1=ENABLE;
altersystem set FAL_SERVER=ogg;
altersystem set DB_FILE_NAME_CONVERT='/u01/oradata/ogg','/u01/oradata/tgg'scope=spfile;
altersystem setLOG_FILE_NAME_CONVERT='/u01/oradata/ogg','/u01/oradata/tgg'scope=spfile;
5.添加standby日志
alterdatabase add standby logfile '/u01/oradata/ogg/redostb1.rdo' size50m;
alterdatabase add standby logfile '/u01/oradata/ogg/redostb2.rdo' size50m;


热门课程培训
热门培训机构
