Eason [資料科學//Python學習/資料庫] & [拍片&剪片]

<<0>> 刪除 example 檔案

<<0>> 驗證

[oracle@localhost ~]$ sqlplus hr/hr

SQL> select count(*) from employees;
select count(*) from employees
*
ERROR at line 1:
ORA-01116: error in opening database file 5
ORA-01110: data file ****5*****:
'/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_82741b8z_.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

完整復原

*********************

<<1>>.offline datafile

[oracle@localhost ~]$ sqlplus / as sysdba

SQL> alter database datafile 5 offline;

<<2>>還原 restore file

[oracle@localhost ~]$ rman target /

RMAN> restore datafile 5;

<<3>>復原 recover

RMAN> recover datafile 5;

SQL> alter database datafile 5 online;

成功!