RMAN备份错误ORA-19502的学习

最新推荐文章于 2021-04-11 18:01:01 发布

daimin1983

最新推荐文章于 2021-04-11 18:01:01 发布

阅读量8.5k

点赞数

分类专栏： ORA 文章标签： disk database oracle file archive delete

本文链接：https://blog.csdn.net/daimin1983/article/details/2822552

版权

这篇博客详细记录了在Oracle 9i环境下遇到RMAN备份错误ORA-19502的过程及解决方案。错误发生在进行全库备份时，由于磁盘空间不足导致写入文件失败。博主通过检查磁盘空间，删除旧的备份文件释放空间，然后重新执行备份命令成功解决问题。此外，还分享了一个类似错误在Oracle 10g环境下的解决方法。

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

RMAN备份错误ORA-19502的学习

系统平台:Linux AS 3
数据库版本:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

[oracle@localhost oracle]$ rman

Recovery Manager: Release 9.2.0.4.0 - Production

RMAN> connect target /

connected to target database: ORA9I (DBID=2447264884)

RMAN> BACKUP DATABASE
2> include current
3> controlfile;

Starting backup at 23-AUG-08
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=10 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00013 name=/opt/ora9/oradata/ora9i/demo05.dbf
input datafile fno=00001 name=/opt/ora9/oradata/ora9i/system01.dbf
input datafile fno=00009 name=/opt/ora9/oradata/ora9i/users01.dbf
input datafile fno=00005 name=/opt/ora9/oradata/ora9i/example01.dbf
input datafile fno=00011 name=/opt/ora9/oradata/ora9i/ts_mamual_1.dbf
input datafile fno=00010 name=/opt/ora9/oradata/ora9i/xdb01.dbf
input datafile fno=00006 name=/opt/ora9/oradata/ora9i/indx01.dbf
input datafile fno=00003 name=/opt/ora9/oradata/ora9i/cwmlite01.dbf
input datafile fno=00004 name=/opt/ora9/oradata/ora9i/drsys01.dbf
input datafile fno=00007 name=/opt/ora9/oradata/ora9i/odm01.dbf
input datafile fno=00002 name=/opt/ora9/oradata/ora9i/undotbs01.dbf
input datafile fno=00008 name=/opt/ora9/oradata/ora9i/tools01.dbf
input datafile fno=00015 name=/opt/ora9/oradata/ora9i/undotbs03.dbf
input datafile fno=00012 name=/opt/ora9/oradata/ora9i/demo01.dbf
channel ORA_DISK_1: starting piece 1 at 23-AUG-08
RMAN-00571: =============&