千家信息网

12c RMAN备份脚本,ORA-00245

发表于:2025-02-06 作者:千家信息网编辑
千家信息网最后更新 2025年02月06日,12c rac报错如下:channel d3: backup set complete, elapsed time: 00:00:08RMAN-03009: failure of backup com
千家信息网最后更新 2025年02月06日12c RMAN备份脚本,ORA-00245

12c rac

报错如下:

channel d3: backup set complete, elapsed time: 00:00:08RMAN-03009: failure of backup command on d4 channel at 12/07/2017 15:08:46ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storagecontinuing other job steps, job failed will not be re-runchannel d2: finished piece 1 at 07-DEC-2017 15:09:41piece handle=/u01/bak/db_fullbk_2_1_962118518.rmn tag=BACKUP_FULL comment=NONEchannel d2: backup set complete, elapsed time: 00:01:04channel d1: finished piece 1 at 07-DEC-2017 15:10:02piece handle=/u01/bak/db_fullbk_1_1_962118518.rmn tag=BACKUP_FULL comment=NONEchannel d1: backup set complete, elapsed time: 00:01:24released channel: d1released channel: d2released channel: d3released channel: d4RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of backup command on d4 channel at 12/07/2017 15:08:46ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

解决:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+datadg/snapcf_orcl1.f';

奉上一个备份脚本仅供参考

#!/bin/sh#backup full  database and archivelog#filename:/home/oracle/rk_rman.sh#oracle user execute:sh /home/oracle/rk_rman.sh >./backup.log 2>&1 &#authored by:roidba####export ORACLE_SID=xxxxrman target / <
0