SQL> select file#,status from v$datafile;FILE# STATUS---------- -------1 SYSTEM2 ONLINE3 ONLINE4 ONLINE5 ONLINE6 ONLINE7 ONLINE8 ONLINE9 RECOVER9 rows selected.SQL> recover datafile 9;ORA-00283: recovery session canceled due to errorsORA-01110: data file 9: '/u01/oradata/dbtest/qq01.dbf'ORA-01157: cannot identify/lock data file 9 - see DBWR trace fileORA-01110: data file 9: '/u01/oradata/dbtest/qq01.dbf'创建数据文件9SQL> alter database create datafile 9;Database altered.SQL> select file#,status from v$datafile;FILE# STATUS---------- -------1 SYSTEM2 ONLINE3 ONLINE4 ONLINE5 ONLINE6 ONLINE7 ONLINE8 ONLINE9 RECOVER9 rows selected.恢复数据文件9SQL> recover datafile 9;ORA-00279: change 1645095 generated at 04/26/2012 10:16:59 needed for thread 1ORA-00289: suggestion :/u01/flash_recovery_area/DBTEST/archivelog/2012_04_26/o1_mf_1_54_%u_.arcORA-00280: change 1645095 for thread 1 is in sequence #54Specify log: {=suggested | filename | AUTO | CANCEL}ORA-00279: change 1646743 generated at 04/26/2012 10:59:35 needed for thread 1ORA-00289: suggestion :/u01/flash_recovery_area/DBTEST/archivelog/2012_04_26/o1_mf_1_55_%u_.arcORA-00280: change 1646743 for thread 1 is in sequence #55ORA-00278: log file'/u01/flash_recovery_area/DBTEST/archivelog/2012_04_26/o1_mf_1_54_7skgjqyf_.arc'no longer needed for this recoverySpecify log: {=suggested | filename | AUTO | CANCEL}ORA-00279: change 1646866 generated at 04/26/2012 11:01:15 needed for thread 1ORA-00289: suggestion :/u01/flash_recovery_area/DBTEST/archivelog/2012_04_26/o1_mf_1_56_%u_.arcORA-00280: change 1646866 for thread 1 is in sequence #56ORA-00278: log file'/u01/flash_recovery_area/DBTEST/archivelog/2012_04_26/o1_mf_1_55_7skgmvm2_.arc'no longer needed for this recoverySpecify log: {=suggested | filename | AUTO | CANCEL}Log applied.Media recovery complete.让数据文件ONLINE
oracle ora 00283,ora-00283
最新推荐文章于 2024-02-03 22:13:26 发布