共计 5302 个字符，预计需要花费 14 分钟才能阅读完成。
这篇文章主要讲解了“DG 搭建常见问题处理的方法是什么”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着丸趣 TV 小编的思路慢慢深入，一起来研究和学习“DG 搭建常见问题处理的方法是什么”吧！
1、ORA-09925 报错
报错 1:
connected to auxiliary database (not started)
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/27/2018 10:48:43
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925原因: 备库 adump 文件不存在
解决:
mkdri -p $ORACLE_HOME/admin/db_unique_name/adump例如：
mkdir -p $ORACLE_BASE/admin/mssdbdg/adump2、RMAN-05537 报错
报错 2:
Starting Duplicate Db at 27-JUL-18
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: stby
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/27/2018 10:57:28
RMAN-05501: aborting duplication of target database
RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause原因: 备库跑了 duplicate 脚本, 没有删除 spfile 文件，重新启动数据库到 nomount
解决: 先删除 spfile 文件，重新启动数据库到 nomount
3、ORA-17628: Oracle error 19505 报错
contents of Memory Script:
backup as copy current controlfile for standby auxiliary format /ORADATA/RESNETDBDG/control01.ctl
restore clone primary controlfile to /ORADATA/fast_recovery_area/RESNETDBDG/control02.ctl from
/ORADATA/RESNETDBDG/control01.ctl
executing Memory Script
Starting backup at 26-JUL-2018 18:42:20
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/26/2018 18:42:21
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/26/2018 18:42:21
ORA-17628: Oracle error 19505 returned by remote Oracle server原因：目标端路径不存在，可能是文件系统路径不存在，也可能是权限不够，如果是 ASM，请确认磁盘组是否存在，磁盘的权限是否正确
4、ORA-01017 报错
这里是报密码错误，SYS 用户登录采用的是密码文件认证的方法，所以需要确保密码文件可读写和密码文件的名字中的 ORACLE_SID 与监听中的 ORACLE_SID 是对应的。密码错误分很多情况。
4.1 第一次搭建时报密码错误
4.1.1 密码文件不一致
通过在主库的一个节点修改密码后，将此节点的密码文件复制给其它所有的节点，包括主库的节点和备库的所有的节点，确认 Oracle 用户有对写的权限。
4.1.2 目标端报密码错误
已经完成 4.1.1 的操作，但是仍然报密码错误。这个时候很可能是静态监听里面的数据库 ORACLE_SID 与密码文件中的 SID 不一致。
5、日志不传输到备库分析方法
SELECT DESTINATION, STATUS, ERROR FROM V$ARCHIVE_DEST WHERE TARGET= STANDBY查看 ERROR 的报错代码，根据报错代码来解决问题。
6、ORA-00845 报错
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/30/2018 02:22:10
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-00845: MEMORY_TARGET not supported on this system由于使用 AMM 功能，但是 SHM 大小没有 AMM 那么大，所有需要重新 SHM，并指定跟 AMM 相同的大小
mount -o remount,default,size=102G /dev/shm修改 /etc/fstab 中的值
7、监听配置没问题，sqlplus 测试没问题，tnsping 也没问题，可还是报下边错误
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/05/2018 02:30:01
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on prmy2 channel at 08/05/2018 02:30:01
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server
RMAN解决：把 tnsnames.ora 的内容，在 grid 的 network/admin 下复制一份。可以在 MOS 上查看 RMAN Active Duplicate on RAC fails with ORA-17629 and ORA-17627: ORA-12154 (文档 ID 1982003.1)
8、duplicate 出错，查看原因是原库有两个数据文件没有使用 OMF 格式，无法传过去。
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/05/2018 20:42:25
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on prmy4 channel at 08/05/2018 20:01:35
ORA-17628: Oracle error 19505 returned by remote Oracle server
RMAN-03009: failure of backup command on prmy4 channel at 08/05/2018 20:01:20
ORA-17628: Oracle error 19505 returned by remote Oracle server解决：查看错误代码：MOS 1331986.1
注意，做之前先确定一下是不是 OMF 文件，若不是，先在 asm 的子层建好目录或在脚本里把子层目录写好。
感谢各位的阅读，以上就是“DG 搭建常见问题处理的方法是什么”的内容了，经过本文的学习后，相信大家对 DG 搭建常见问题处理的方法是什么这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是丸趣 TV，丸趣 TV 小编将为大家推送更多相关知识点的文章，欢迎关注！
![Frank#smith[Kfyzeiuqujbpygze,2,5]](https://cravatar.cn/avatar/ebd2642d86a4b40100d29dc76ec89b0d?s=96&d=monsterid&r=r)
