ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ora-00283

ora-00283

原创 Linux操作系统 作者:oracle_db 时间:2012-04-26 14:13:07 0 删除 编辑
问题描述:SQL> show user;
USER is "SYS"
SQL> recover datafile 9;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 9: '/u01/oradata/dbtest/qq01.dbf'
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/u01/oradata/dbtest/qq01.dbf'
查看BDUMP中DBWN进程的跟踪文件出现以下信息
[root@oraclelinux bdump]# more testenv01_dbw0_6158.trc 
/u01/admin/dbtest/bdump/testenv01_dbw0_6158.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/oracle
System name:    Linux
Node name:      oraclelinux
Release:        2.6.9-89.ELsmp
Version:        #1 SMP Mon Jun 22 12:32:43 EDT 2009
Machine:        i686
Instance name: TESTENV01
Redo thread mounted by this instance: 1
Oracle process number: 5
Unix process pid: 6158, image: oracle@oraclelinux (DBW0)

*** 2012-04-26 12:00:04.946
*** SERVICE NAME:(SYS$BACKGROUND) 2012-04-26 12:00:04.945
*** SESSION ID:(167.1) 2012-04-26 12:00:04.945
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/u01/oradata/dbtest/qq01.dbf'
处理:通过重建数据文件来处理,先看下直接恢复的情况
SQL> select file#,status from v$datafile;

     FILE# STATUS
---------- -------
         1 SYSTEM
         2 ONLINE
         3 ONLINE
         4 ONLINE
         5 ONLINE
         6 ONLINE
         7 ONLINE
         8 ONLINE
         9 RECOVER

9 rows selected.

SQL> recover datafile 9;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 9: '/u01/oradata/dbtest/qq01.dbf'
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-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 SYSTEM
         2 ONLINE
         3 ONLINE
         4 ONLINE
         5 ONLINE
         6 ONLINE
         7 ONLINE
         8 ONLINE
         9 RECOVER

9 rows selected.
恢复数据文件9SQL> recover datafile 9;
ORA-00279: change 1645095 generated at 04/26/2012 10:16:59 needed for thread 1
ORA-00289: suggestion :
/u01/flash_recovery_area/DBTEST/archivelog/2012_04_26/o1_mf_1_54_%u_.arc
ORA-00280: change 1645095 for thread 1 is in sequence #54


Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00279: change 1646743 generated at 04/26/2012 10:59:35 needed for thread 1
ORA-00289: suggestion :
/u01/flash_recovery_area/DBTEST/archivelog/2012_04_26/o1_mf_1_55_%u_.arc
ORA-00280: change 1646743 for thread 1 is in sequence #55
ORA-00278: log file
'/u01/flash_recovery_area/DBTEST/archivelog/2012_04_26/o1_mf_1_54_7skgjqyf_.arc'
no longer needed for this recovery


Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00279: change 1646866 generated at 04/26/2012 11:01:15 needed for thread 1
ORA-00289: suggestion :
/u01/flash_recovery_area/DBTEST/archivelog/2012_04_26/o1_mf_1_56_%u_.arc
ORA-00280: change 1646866 for thread 1 is in sequence #56
ORA-00278: log file
'/u01/flash_recovery_area/DBTEST/archivelog/2012_04_26/o1_mf_1_55_7skgmvm2_.arc'
no longer needed for this recovery


Specify log: {=suggested | filename | AUTO | CANCEL}



Log applied.
Media recovery complete.
让数据文件ONLINE
SQL> alter database datafile 9 online;

检测数据
SQL> conn qq1/qq1;
Connected.
SQL> select * from t;

        ID NAME
---------- ---------------
         0 qq1
         1 qq2
         2 qq3
         3 qq4
         4 qq5

SQL> 

备注:
[oracle@oraclelinux ~]$ oerr ora 00283
00283, 00000, "recovery session canceled due to errors"
// *Cause: An error during recovery was determined to be fatal enough to end
//         the current recovery session.
// *Action: More specific messages will accompany this message. Refer to
//          the other messages for the appropriate action.
[oracle@oraclelinux ~]$ 
说了当没说。。。。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15720542/viewspace-722285/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-11-13

  • 博文量
    158
  • 访问量
    308070