ORA-19504、ORA-27040

最新推荐文章于 2021-05-25 14:03:20 发布

Scofy_Pei

最新推荐文章于 2021-05-25 14:03:20 发布

阅读量1.8k

点赞数

分类专栏： oracle 文章标签： RMAN BACKUP

本文链接：https://blog.csdn.net/Scofy0/article/details/42705713

版权

在执行RMAN备份时遇到了ORA-19504和ORA-27040错误，备份过程中出现了文件创建失败的问题。经过排查，错误根源是权限不足。修正权限设置后，成功完成了数据库的备份。

摘要由CSDN通过智能技术生成

RMAN> RUN
{
2> 3> ALLOCATE CHANNEL c1 TYPE DISK;
4> BACKUP DATABASE FORMAT '/database/datafile_%d_%U';
5> BACKUP CURRENT CONTROLFILE format '/database/control_%d_%U';
6> Release CHANNEL c1;
7> }

allocated channel: c1
channel c1: SID=37 device type=DISK

Starting backup at 13-JAN-15
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel c1: starting piece 1 at 13-JAN-15
released channel: c1
RMAN-00571: =