ORACLE RAC TO RAC DG搭建过程中可能遇到的问题

最新推荐文章于 2021-12-21 10:32:55 发布

原创

最新推荐文章于 2021-12-21 10:32:55 发布 · 1.5k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#ORACLE #DG #RAC #ORA-17627 #ORA-17629

在ORACLE DataGuard部署过程中，如果操作不规范，可能遇到很多想不到的问题。有些问题是配置参数不到位，有些
是操作不规范遗漏导致。

问题一
主库复制备库到备机时，rman远程登陆主库作为复制的目标库rman无法登陆备机备库，就是下面的命令执行报错：
rman target sys/oracle@dg_orclp auxiliary sys/oracle@dg_orcls
问题原始是从库的TNS配置不规范，缺少(UR=A)，示例配置
DG_ORCLS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.10.101.36)(PORT = 1521))
(LOAD_BALANCE = off)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =DG_ORCLS)
(UR=A)
)
)

问题二
主库复制备库到备机时，rman执行duplicat的时，duplicat过程执行报错ORA-17629&ORA-17627：
RMAN> duplicate target database for standby from active database nofilenamecheck;
Starting Duplicate Db at 2019-03-10 11:38:4
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1811 instance=orcl1 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/oracle/app/oracle/product/11.2.0/dbs/orapworcl1' auxiliary format
'/oracle/app/oracle/product/11.2.0/dbs/orapworcl1' ;
}

executing Memory Script
Starting backup at 2019-03-10 11:38:43
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4533 instance=orcl1 device type=DISK
RMAN-00571: ===========================================================
RMAN-005