本篇接着上一篇ORA-16433: The database must be opened in read/write mode.继续,在重建控制文件后,漏掉了一个数据文件,导致改数据文件时offline状态,那么如何恢复这个文件呢?
查看当前数据文件
SQL> select file#,status,checkpoint_change#,name from v$datafile_header;
FILE# STATUS CHECKPOINT_CHANGE# NAME
---------- ------- ------------------ ----------------------------------------
1 ONLINE 3221227459 /u01/oradata/orcl/system01.dbf
2 ONLINE 3221227459 /u01/oradata/orcl/sysaux01.dbf
3 ONLINE 3221227459 /u01/oradata/orcl/undotbs04.db
4 ONLINE 3221227459 /u01/oradata/orcl/users01.dbf
5 ONLINE 3221227459 /u01/oradata/orcl/test01.dbf
6 OFFLINE 2147582092 /u01/oradata/orcl/test_ind01.dbf
6 rows selected.
SQL> select file#,status,checkpoint_change#,name from v$datafile;
FILE# STAT