这篇文章主要讲解了“DG搭建常见问题处理的方法是什么”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“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/adump
2、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搭建常见问题处理的方法是什么这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是亿速云,小编将为大家推送更多相关知识点的文章,欢迎关注!
原创文章,作者:carmelaweatherly,如若转载,请注明出处:https://blog.ytso.com/205332.html