duplicate方式初始化data guard的standby报错

本文记录了一次Oracle数据库备份过程中的失败案例,详细介绍了错误信息及排查步骤。在尝试备份时遇到ORA-12577错误,最终发现是由于文件系统空间不足导致,并通过调整文件路径解决了问题。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

操作系统环境:Red Hat Linux 6.5
数据库:Oracle 11.2.0.1
错误信息

Starting backup at 2018/02/07 17:31:10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/home/oradata/orcl/undotbs01.dbf
output file name=/oradata/orcl/undotbs01.dbf tag=TAG20180207T173327
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/home/oradata/orcl/users01.dbf
output file name=/oradata/orcl/users01.dbf tag=TAG20180207T173327
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/home/oradata/orcl/central01.dbf
output file name=/oradata/orcl/central01.dbf tag=TAG20180207T173327
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00009 name=/home/oradata/orcl/sjxg_data01.dbf
output file name=/oradata/orcl/sjxg_data01.dbf tag=TAG20180207T173327
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:16
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/home/oradata/orcl/SLDT
output file name=/oradata/orcl/SLDT tag=TAG20180207T173327
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00010 name=/home/oradata/orcl/users02.dbf
output file name=/oradata/orcl/users02.dbf tag=TAG20180207T173327
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/home/oradata/orcl/sysaux01.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/07/2018 17:39:37
ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=/home/oradata/orcl/D:appAdministratororadataSXMLGLXT.dbf
output file name=/oradata/orcl/D:appAdministratororadataSXMLGLXT.dbf tag=TAG20180207T173327
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/home/oradata/orcl/system01.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/07/2018 17:40:27
ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/home/oradata/orcl/D:appAdministratororadataSXMLQZK_DT.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/07/2018 17:40:42
ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/home/oradata/orcl/YW_ZX_GDZC01.dbf
output file name=/oradata/orcl/YW_ZX_GDZC01.dbf tag=TAG20180207T173327
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/07/2018 17:40:46
RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/07/2018 17:40:42
ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/07/2018 17:39:37
ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/07/2018 17:40:27
ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA

试了2次,每次都是到传输sysaux表空间的时候就卡住报错了。后来查看文件系统,居然没空间了,��。
随后,通过db_file_name_convert和log_file_name_convert将文件指定到其他目录解决。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值