重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: RMAN备份报RMAN-03009,ORA-19504,ORA-27040错误 [打印本页]

作者: jiawang 时间: 2020-4-2 17:07
标题: RMAN备份报RMAN-03009,ORA-19504,ORA-27040错误
本帖最后由 jiawang 于 2020-4-2 17:34 编辑

执行备份：
RMAN> backup database;
Starting backup at 02-APR-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=29 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_fd8fv6rf_.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_fd8fv6sr_.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_fd8fv6v3_.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_fd8fv6w0_.dbf
channel ORA_DISK_1: starting piece 1 at 02-APR-20
channel ORA_DISK_1: finished piece 1 at 02-APR-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_04_02/o1_mf_nnndf_TAG20200402T161730_h8c7wtrp_.bkp tag=TAG20200402T161730 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 02-APR-20

Starting Control File and SPFILE Autobackup at 02-APR-20
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 04/02/2020 16:18:17
ORA-19504: failed to create file "/orabackup/c-1500336691-20200402-00"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 13: Permission denied
Additional information: 1

上面提示没这样的文件和目录，确认目录及相应的目录权限
[root@localhost /]# ls -ld orabackup
drwxr-xr-x 2 root root 6 4月 2 16:17 orabackup

授权Oracle权限：
[root@localhost /]# chown -R oracle:dba orabackup/
[root@localhost /]# ls -ld orabackup
drwxr-xr-x 2 oracle dba 6 4月 2 16:17 orabackup

重新备份数据库：
RMAN> backup database;

Starting backup at 02-APR-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=144 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_fd8fv6rf_.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_fd8fv6sr_.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_fd8fv6v3_.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_fd8fv6w0_.dbf
channel ORA_DISK_1: starting piece 1 at 02-APR-20
channel ORA_DISK_1: finished piece 1 at 02-APR-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_04_02/o1_mf_nnndf_TAG20200402T171416_h8cc789z_.bkp tag=TAG20200402T171416 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 02-APR-20

Starting Control File and SPFILE Autobackup at 02-APR-20
piece handle=/orabackup/c-1500336691-20200402-01 comment=NONE
Finished Control File and SPFILE Autobackup at 02-APR-20

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)