rhel6+ oracle 11g rac +dg环境下添加 dg单节点云主机

原创

bjwzh 2020-10-09 22:01:38 ©著作权

文章标签 oracle 11g rac+dg 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者bjwzh的原创作品，如需转载，请与作者联系，否则将追究法律责任

上云端新建DG库，master :代表主服务器，AWSDG:为新DG库：下面是具体操作步骤： 1 master $cd $ORACLE_HOME/dbs scp orapweipdb1 oracle@awsdg_ip:$ORACLE_HOME/dbs
awsdg： $cd $ORACLE_HOME/dbs/ mv orapwpdb1 orapwawsdg /

2 dg 的参数文件备份及修改到AWSDG dg--init.ora--scp awsdg --change awsdg others info---initawsdg.ora awsdg 3 awsdg 到 nomount startup nomount pfile='/home/oracle/initawsdg.ora'

4 master 建控制文件 ; awsdg 用控制文件到mount; master alter database create standby controlfile as '/home/oracle/stdby_control01.ctl'; scp -r /home/oracle/stdby_control01.ctl' oracle@awsdg_ip:/home/oracle/ awsdg sql>alter database mount standby database;

5 awsdg建议静态监听 awsdg vi $ORACLE_HOME/network/admin/listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/oracle/app/product/11.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = awsdg) (ORACLE_HOME = /u01/oracle/app/product/11.2.0/db_1) (GLOBAL_DBNAME=awsdg) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) (ADDRESS = (PROTOCOL = TCP)(HOST = AWSDG_IP)(PORT = 1521)) ) ) 6 awsdg 在tnsnames.ora中增加主库及自己的信息 PDB1= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = pip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID=eipdb1) ) )

EIPDB2= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = pip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = vip )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID=eipdb2) ) )

EIPDB= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = scan_ip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = eipdb) ) )

EIPDBST= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dgip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = eipdbst) ) )

AWSDG= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = awsdg_ip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = awsdg) ) ) 7 master 2 node 增加相awsdg选项 vi $ORACLE_HOME/network/admin/tnsnames.ora AWSDG= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = awSDG_IP)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = awsdg) ) )

8 awsdg删除后重新建standby logfile; ALTER DATABASE DROP STANDBY LOGFILE GROUP 9; ALTER DATABASE DROP STANDBY LOGFILE GROUP 10; ALTER DATABASE DROP STANDBY LOGFILE GROUP 11; ALTER DATABASE DROP STANDBY LOGFILE GROUP 12; ALTER DATABASE DROP STANDBY LOGFILE GROUP 13; ALTER DATABASE DROP STANDBY LOGFILE GROUP 14; ALTER DATABASE DROP STANDBY LOGFILE GROUP 15; ALTER DATABASE DROP STANDBY LOGFILE GROUP 16; ALTER DATABASE DROP STANDBY LOGFILE GROUP 17; ALTER DATABASE DROP STANDBY LOGFILE GROUP 18;

alter database add standby logfile group 9 '/u01/oracle/app/fast_recovery_area/AWSDG/onlinelog/awsdg_redo09.log' size 512m; alter database add standby logfile group 10 '/u01/oracle/app/fast_recovery_area/AWSDG/onlinelog/awsdg_redo10.log' size 512m; alter database add standby logfile group 11 '/u01/oracle/app/fast_recovery_area/AWSDG/onlinelog/awsdg_redo11.log' size 512m; alter database add standby logfile group 12 '/u01/oracle/app/fast_recovery_area/AWSDG/onlinelog/awsdg_redo12.log' size 512m; alter database add standby logfile group 13 '/u01/oracle/app/fast_recovery_area/AWSDG/onlinelog/awsdg_redo13.log' size 512m; alter database add standby logfile group 14 '/u01/oracle/app/fast_recovery_area/AWSDG/onlinelog/awsdg_redo14.log' size 512m; alter database add standby logfile group 15 '/u01/oracle/app/fast_recovery_area/AWSDG/onlinelog/awsdg_redo15.log' size 512m; alter database add standby logfile group 16 '/u01/oracle/app/fast_recovery_area/AWSDG/onlinelog/awsdg_redo16.log' size 512m; alter database add standby logfile group 17 '/u01/oracle/app/fast_recovery_area/AWSDG/onlinelog/awsdg_redo17.log' size 512m; alter database add standby logfile group 18 '/u01/oracle/app/fast_recovery_area/AWSDG/onlinelog/awsdg_redo18.log' size 512m;

9 master 将asm中的文件转换成本地文件形式。 run {

copy archivelog '+DATA/PROD/1_29_856078807.arc' to '/home/oracle/1_29_856078807.arc';

copy archivelog '+DATA/PROD/1_30_856078807.arc' to '/home/oracle/1_30_856078807.arc';

copy archivelog '+DATA/prod/2_14_856078807.arc' to '/home/oracle/2_14_856078807.arc';

copy archivelog '+DATA/prod/2_15_856078807.arc' to '/home/oracle/2_15_856078807.arc';

copy archivelog '+DATA/prod/2_16_856078807.arc' to '/home/oracle/2_16_856078807.arc';

} scp 到awsdg指定路径下

10 aws注册相关archivelog日志

alter database register logfile '/arch/sdyprod/1_29_856078807.arc';

……

Database altered.

SQL> alter database register logfile '/arch/sdyprod/2_16_856078807.arc';

Database altered. 11 更改主库的相关设置,两节点都要做 alter system set log_archive_dest_3='SERVICE=awsdg lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=awsdg'; ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_3=ENABLE; alter system set log_archive_config='(EIPDB,eipdbst,awsdg)';//后边两个为DG库的services name名

12 awsdg 开启应用： alter database open; alter database recover managed standby database using current logfile disconnect;