RMAN-06056: could not access datafile 8

 

执行备份命令

RMAN> BACKUP DATABASE;

 

Starting backup at 2021-04-25 16:26:17

using channel ORA_DISK_1

RMAN-06169: could not read file header for datafile 8 error reason 4

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 04/25/2021 16:26:18

RMAN-06056: could not access datafile 8

 

select file#,name from v$datafile;

 

查看所属的表空间

select a.file#,a.name,b.name from v$datafile a,v$tablespace b where a.ts#=b.ts#;

删除表空间及数据

SQL>  drop tablespace RMANTBS  including contents and datafiles;

 

RMAN> BACKUP DATABASE;

 

Starting backup at 2021-04-25 17:26:31

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=262 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/system01.dbf

input datafile file number=00002 name=/home/data/Local10racl2.dbf

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

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

input datafile file number=00005 name=/u01/app/oracle/product/12.2.0/db_1/dbs/d:dataLocal10racl.dbf

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

channel ORA_DISK_1: starting piece 1 at 2021-04-25 17:26:33

channel ORA_DISK_1: finished piece 1 at 2021-04-25 17:28:31 with 2 copies and tag TAG20210425T172633

piece handle=/u01/app/oracle/product/12.2.0/db_1/dbs/0evt6om9_1_1 comment=NONE

piece handle=/u01/app/oracle/product/12.2.0/db_1/dbs/0evt6om9_1_2 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:58

Finished backup at 2021-04-25 17:28:31

 

Starting Control File and SPFILE Autobackup at 2021-04-25 17:28:31

piece handle=/u01/app/oracle/product/12.2.0/db_1/dbs/c-1570833465-20210425-01 comment=NONE

Finished Control File and SPFILE Autobackup at 2021-04-25 17:28:34

 

 including contents and datafiles;