|
本帖最后由 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
|
|