解决oracle数据文件路径有回车故障---惜分飞

最近遇到一个硬件恢复朋友的请求,oracle数据库文件恢复出来了,但是在linux上面启动的时候,有两个文件无法检测到,dbv检测正常.
 

 

---

通过分析是由于文件无法找到原因导致
 

---

进一步检查发现原库这两个文件结尾带有回车,但是恢复出来的文件不带回车
 

---

对于这个故障,我在测试环境进行了重现并且给予解决
1. 创建带回车键数据文件

SQL> create tablespace xifenfei datafile '/u01/app/oracle/oradata/xifenfei/xff01.dbf   2  ' size 128m; Tablespace created. SQL> alter tablespace xifenfei add datafile '/u01/app/oracle/oradata/xifenfei/xff02.dbf' size 128M; Tablespace altered. SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/xifenfei/system01.dbf /u01/app/oracle/oradata/xifenfei/sysaux01.dbf /u01/app/oracle/oradata/xifenfei/undotbs01.dbf /u01/app/oracle/oradata/xifenfei/users01.dbf /u01/app/oracle/oradata/xifenfei/xff01.dbf /u01/app/oracle/oradata/xifenfei/xff02.dbf 6 rows selected.

2.操作系统层面查看文件（在我的ssh工具中,可以看到带回车键文件和不带回车文件不一样,使用的是crt工具,其他工具是否显示不确定）

[oracle@xifenfei ~]$ cd /u01/app/oracle/oradata/xifenfei/ [oracle@xifenfei xifenfei]$ ls -l xff* -rw-r----- 1 oracle oinstall 134225920 Dec 14 08:05 xff01.dbf? -rw-r----- 1 oracle oinstall 134225920 Dec 14 08:05 xff02.dbf

3. 操作系统层面重命名数据文件
[oracle@xifenfei xifenfei]$ mv xff01.dbf* xff01.dbf
[oracle@xifenfei xifenfei]$ ls -l xff*
-rw-r—– 1 oracle oinstall 134225920 Dec 14 08:05 xff01.dbf
-rw-r—– 1 oracle oinstall 134225920 Dec 14 08:05 xff02.dbf
[/shell]
3. 数据库层面重启看文件情况,发现文件不能被正常发现(当然不能,文件被os层面mv了)

SQL> shutdown abort; ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area  551165952 bytes Fixed Size                  2255112 bytes Variable Size             369100536 bytes Database Buffers          171966464 bytes Redo Buffers                7843840 bytes Database mounted. SQL> select file#, CHECKPOINT_CHANGE# from v$datafile_header;      FILE# CHECKPOINT_CHANGE# ---------- ------------------          1          306775013          2          306775013          3          306775013          4          306775013          5                  0          6          306779423 6 rows selected. RMAN> report schema; Report of database schema for database with db_unique_name XIFENFEI List of Permanent Datafiles =========================== File Size(MB) Tablespace           RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1    770      SYSTEM               ***     /u01/app/oracle/oradata/xifenfei/system01.dbf 2    1950     SYSAUX               ***     /u01/app/oracle/oradata/xifenfei/sysaux01.dbf 3    70       UNDOTBS1             ***     /u01/app/oracle/oradata/xifenfei/undotbs01.dbf 4    12       USERS                ***     /u01/app/oracle/oradata/xifenfei/users01.dbf 5    0        XIFENFEI             ***     /u01/app/oracle/oradata/xifenfei/xff01.dbf 6    128      XIFENFEI             ***     /u01/app/oracle/oradata/xifenfei/xff02.dbf

4. 解决控制文件和数据文件实际名称不一致问题

RMAN> catalog datafilecopy '/u01/app/oracle/oradata/xifenfei/xff01.dbf'; using target database control file instead of recovery catalog cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/xifenfei/xff01.dbf RECID=1 STAMP=1187684217 RMAN> switch datafile 5 to copy; datafile 5 switched to datafile copy "/u01/app/oracle/oradata/xifenfei/xff01.dbf" RMAN> report schema; Report of database schema for database with db_unique_name XIFENFEI List of Permanent Datafiles =========================== File Size(MB) Tablespace           RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1    770      SYSTEM               ***     /u01/app/oracle/oradata/xifenfei/system01.dbf 2    1950     SYSAUX               ***     /u01/app/oracle/oradata/xifenfei/sysaux01.dbf 3    70       UNDOTBS1             ***     /u01/app/oracle/oradata/xifenfei/undotbs01.dbf 4    12       USERS                ***     /u01/app/oracle/oradata/xifenfei/users01.dbf 5    128      XIFENFEI             ***     /u01/app/oracle/oradata/xifenfei/xff01.dbf 6    128      XIFENFEI             ***     /u01/app/oracle/oradata/xifenfei/xff02.dbf List of Temporary Files ======================= File Size(MB) Tablespace           Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1    123      TEMP                 32767       /u01/app/oracle/oradata/xifenfei/temp01.dbf RMAN> alter database open; database opened