Oracle 12c RMAN备份脚本,ORA-00245
Oracle 12c RAC
报错如下:
channel d3: backup set complete, elapsed time: 00:00:08
RMAN-03009: failure of backup command on d4 channel at 12/07/2017 15:08:46
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage
continuing other job steps, job failed will not be re-run
channel d2: finished piece 1 at 07-DEC-2017 15:09:41
piece handle=/u01/bak/db_fullbk_2_1_962118518.rmn tag=BACKUP_FULL comment=NONE
channel d2: backup set complete, elapsed time: 00:01:04
channel d1: finished piece 1 at 07-DEC-2017 15:10:02
piece handle=/u01/bak/db_fullbk_1_1_962118518.rmn tag=BACKUP_FULL comment=NONE
channel d1: backup set complete, elapsed time: 00:01:24
released channel: d1
released channel: d2
released channel: d3
released channel: d4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on d4 channel at 12/07/2017 15:08:46
ORA-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=xxxx
rman target / <