非归档数据文件offline的恢复(三)

2014-11-24 17:02:25 · 作者: · 浏览: 2
------- ------------------ 1 555687 2 555687 3 555687 4 555687 5 554973 SQL> select file#,checkpoint_change# from v$datafile_header; FILE# CHECKPOINT_CHANGE# ---------- ------------------ 1 555687 2 555687 3 555687 4 555687 5 555067 SQL>
alter database datafile 5 online; alter database datafile 5 online * ERROR at line 1: ORA-01113: file 5 needs media recovery if it was restored from backup, or END BACKUP if it was not ORA-01110: data file 5: '/u01/app/oracle/oradata/ptod/zxy01.dbf' SQL> recover datafile 5; Media recovery complete. SQL> alter database datafile 5 online; Database altered.

成功online数据文件5!