oracle rman 06056,RMAN备份异常啦：RMAN-06169 ...RMAN-06056

尼玛，一个简单的RMAN备份就百度嘛？

using target database control file instead of recovery catalog

allocated channel: c1

channel c1: SID=2276 device type=DISK

allocated channel: c2

channel c2: SID=3402 device type=DISK

Starting backup at 2016/03/29 13:40:49

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

released channel: c1

released channel: c2

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

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

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

RMAN-03002: failure of backup command at 03/29/2016 13:40:51

RMAN-06056: could not access datafile 46

查询DB有，还是OFFLINE，实际却不存在这个文件，备份个锤子哦！为什么会出现这种情况呢？肯定是哪个家伙一晕把ASM当成文件系统玩了

SQL> select file#, name,status, enabled from v$datafile where file# = 46;

FILE# NAME                                               STATUS                ENABLED

---------- -------------------------------------------------- --------------------- ------------------------------

46 /dev/shm/IDX_ORDERS2.777                           OFFLINE               READ WRITE

[oracle@rac1 ~]$ ls -l /dev/shm/IDX_ORDERS2.777

ls: /dev/shm/IDX_ORDERS2.777: No such file or directory

就是这个假的数据文件捣的鬼，干掉它就可以了

SQL> DROP TABLESPACE IDX_ORDERS2 INCLUDING CONTENTS AND DATAFILES;

顺便说下RMAN备份前要改成归档模式，这个要重启DB

shutdown immediate;

startup mount;

alter database archivelog; --开启归档

--alter database noarchivelog; 关闭归档

alter database open;

archive log list;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7492984/viewspace-2071974/，如需转载，请注明出处，否则将追究法律责任。