Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › oracle无法正常启动 ora-01013 ora03113
发新帖
ALLSTARS_ORACLE

999

积分

1

好友

942

主题

[物理/逻辑坏块] oracle无法正常启动 ora-01013 ora03113

1#
发表于 2017-4-12 17:56:48 | 查看: 1597| 回复: 1
oracle无法正常启动 ora-01013 ora03113

偶然发现数据库崩溃，无法打开，报ora-01013错误

#
# su - oracle
$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 30 05:25:41 2016

Copyright (c) 1982, 2009, Oracle.All rights reserved.

Connected to an idle instance.

SQL> startup
^CORA-01013: user requested cancel of current operation

SQL> startup
ORA-03113: end-of-file on communication channel
SQL> ^C^C

SQL>
SQL>
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area780824576 bytes
Fixed Size                  2217424 bytes
Variable Size             557845040 bytes
Database Buffers          218103808 bytes
Redo Buffers                2658304 bytes
Database mounted.
SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL>
SQL> set linesize 200;
SQL> select * from v$log;

    GROUP#    THREAD#SEQUENCE#      BYTESBLOCKSIZE    MEMBERS ARC STATUS         FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
         1          1         67   52428800      512          1 NOINACTIVE               1145614 21-OCT-16         1171499 27-OCT-16
         3          1         69   52428800      512          1 NOCURRENT                1177272 27-OCT-16      2.8147E+14
         2          1         68   52428800      512          1 NOINACTIVE               1171499 27-OCT-16         1177272 27-OCT-16

SQL>
SQL>


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oradata/orcl1/system01.dbf'


SQL> ^C

SQL>
SQL>
SQL> recover database until cancel using backup controlfile;                      =================重建了resetlog报错，恢复库到控制文件记录的时刻
ORA-00279: change 1177272 generated at 10/27/2016 22:47:07 needed for thread 1
ORA-00289: suggestion : /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_69_922348413.dbf
ORA-00280: change 1177272 for thread 1 is in sequence #69


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto      
ORA-00308: cannot open archived log '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_69_922348413.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_69_922348413.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oradata/orcl1/system01.dbf'


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oradata/orcl1/system01.dbf'




SQL> recover datafile '/home/oracle/app/oradata/orcl1/system01.dbf';
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL>
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1177272 generated at 10/27/2016 22:47:07 needed for thread 1
ORA-00289: suggestion : /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_69_922348413.dbf
ORA-00280: change 1177272 for thread 1 is in sequence #69


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_69_922348413.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oradata/orcl1/system01.dbf'


SQL> select v1.group#, member, sequence#, first_change#from v$log v1, v$logfile v2 where v1.group# = v2.group#;

    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SEQUENCE# FIRST_CHANGE#
---------- -------------
         1
/home/oracle/app/oradata/orcl1/redo01.log
      67       1145614

         3
/home/oracle/app/oradata/orcl1/redo03.log
      69       1177272

    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SEQUENCE# FIRST_CHANGE#
---------- -------------

         2
/home/oracle/app/oradata/orcl1/redo02.log
      68       1171499



SQL> ^C

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1177272 generated at 10/27/2016 22:47:07 needed for thread 1
ORA-00289: suggestion : /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_69_922348413.dbf
ORA-00280: change 1177272 for thread 1 is in sequence #69


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_69_922348413.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638  QQ: 47079569     邮箱：service@parnassusdata.com
2#
发表于 2017-4-12 17:57:38

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oradata/orcl1/system01.dbf'


SQL> ^C^C^C^C^C^C

SQL> ^C

SQL> select v1.group#, member, sequence#, first_change#from v$log v1, v$logfile v2 where v1.group# = v2.group#;

    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SEQUENCE# FIRST_CHANGE#
---------- -------------
         1
/home/oracle/app/oradata/orcl1/redo01.log
      67       1145614

         3
/home/oracle/app/oradata/orcl1/redo03.log
      69       1177272

    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SEQUENCE# FIRST_CHANGE#
---------- -------------

         2
/home/oracle/app/oradata/orcl1/redo02.log
      68       1171499


SQL> ^C^C   ============================查到到启动报的sequence和 FIRST_CHANGE#对应的redo为03

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1177272 generated at 10/27/2016 22:47:07 needed for thread 1
ORA-00289: suggestion : /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_69_922348413.dbf
ORA-00280: change 1177272 for thread 1 is in sequence #69


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_69_922348413.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


/home/oracle/app/oradata/orcl1/redo03.log
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oradata/orcl1/system01.dbf'


SQL> SP2-0734: unknown command beginning "/home/orac..." - rest of line ignored.
SQL> ^Crecover database using backup controlfile until cancel;

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1177272 generated at 10/27/2016 22:47:07 needed for thread 1
ORA-00289: suggestion : /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_69_922348413.dbf
ORA-00280: change 1177272 for thread 1 is in sequence #69


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
filename
ORA-00308: cannot open archived log 'filename'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
filename
ORA-00308: cannot open archived log 'filename'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/home/oracle/app/oradata/orcl1/redo03.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance


SQL>
SQL> select instance_name,status from v$instance;                                 =========================数据库实例已启动

INSTANCE_NAME    STATUS
---------------- ------------
orcl1            OPEN

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> conn test/test123;
Connected.
SQL> select * from test1;

ID                   NAME                                  SAL
-------------------- ------------------------------ ----------
1                  xbl                                 88888
2                  aaa                                  1111
3                  bbb                                  2222
4                  ccc                                 33333
5                  ddd                                  4444
6                  xbq                              21212121
7                  zwp                              111111
9                  lilolilo                            60000
8                  xbqing                           808080
11                   gaga                              66666
10                   lawulawu                           9090

11 rows selected.

SQL>
SQL>

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 16:06 , Processed in 0.046288 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569