rman备份报错RMAN-06056: could not access datafile 19-Oracle-运维笔记-技术文档

因为之前我的一个数据文件导入测试时出错，给offline了，结果才报的这个错

查找offline的数据文件，果然就是19号数据文件

SQL> select name,status from v$datafile;

查看表空间

SQL> SELECT ts#,name from v$tablespace;

删除数据表空间

SQL> drop tablespace EXP_TBS;

然后再备份就没出错了

RMAN> backup database format '/soft/%sU.full.bak';

Starting backup at 2023-11-29 03:01:21

using channel ORA_DISK_1

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=/oracle/app/oracle/oradata/OCP19C/system01.dbf

input datafile file number=00003 name=/oracle/app/oracle/oradata/OCP19C/sysaux01.dbf

input datafile file number=00004 name=/oracle/app/oracle/oradata/OCP19C/undotbs01.dbf

input datafile file number=00021 name=/oracle/app/oracle/oradata/OCP19C/test01.dbf

input datafile file number=00022 name=/oracle/app/oracle/oradata/OCP19C/tb_19c01.dbf

input datafile file number=00023 name=/oracle/app/oracle/oradata/OCP19C/cdb01.dbf

input datafile file number=00007 name=/oracle/app/oracle/oradata/OCP19C/users01.dbf

本文地址：https://liuchunjie.top/?id=673
版权声明：本文为原创文章，版权归 admin 所有，欢迎分享本文，转载请保留出处！

rman备份报错RMAN-06056: could not access datafile 19