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

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-15 19:41:13 | 查看: 1144| 回复: 0
版本11.2,操作系统是redhat  5.5 (Tikanga)
在这之前重建过controlfile,现在只能启到mount状态:

SQL> select instance_name,status  from v$instance;
INSTANCE_NAME    STATUS
---------------- ------------
orcl2            MOUNTED
SQL>  recover database using backup controlfile until cancel;
ORA-00279: change 1821372 generated at 11/21/2012 09:37:51 needed for thread 1
ORA-00289: suggestion : /app/oracle/11.2.0/dbs/arch1_1_799925864.dbf
ORA-00280: change 1821372 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log '/app/oracle/11.2.0/dbs/arch1_1_799925864.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 '/app/oracle/11.2.0/dbs/arch1_1_799925864.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: '/app/oracle/oradata/orcl2/system.dbf'

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: '/app/oracle/oradata/orcl2/system.dbf'

相关视图信息:
SQL> select NAME,RESETLOGS_CHANGE#, CHECKPOINT_CHANGE# from v$database;
NAME                                               RESETLOGS_CHANGE# CHECKPOINT_CHANGE#
-------------------------------------------------- ----------------- ------------------
ORCL                                                         1821369                  0

SQL> select file#,name, RESETLOGS_CHANGE#,CHECKPOINT_CHANGE#,FUZZY from v$datafile_header;
           FILE# NAME                                               RESETLOGS_CHANGE# CHECKPOINT_CHANGE# FUZ
---------------- -------------------------------------------------- ----------------- ------------------ ---
               1 /app/oracle/oradata/orcl2/system.dbf                         1821369            1821372 YES
               2 /app/oracle/oradata/orcl2/sysaux.dbf                         1821369            1821372 YES
               3 /app/oracle/oradata/orcl2/undotbs1.dbf                       1821369            1821372 YES
               4 /app/oracle/oradata/orcl2/users.dbf                          1821369            1821372 YES
               5 /app/oracle/oradata/orcl2/tbs1.dbf                           1821369            1821372 YES

SQL> select group#,FIRST_CHANGE#, NEXT_CHANGE#  from v$log order by group#;
          GROUP#    FIRST_CHANGE#     NEXT_CHANGE#
---------------- ---------------- ----------------
               1                0                0
               2                0                0
               3                0                0
               4                0                0

查了很多资料没解决,请大侠们帮忙,谢谢。


SQL> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------
           1821372
           1821372
           1821372
           1821372
           1821372



SQL> startup mount
ORACLE instance started.

Total System Global Area  208769024 bytes
Fixed Size                  2211928 bytes
Variable Size             150998952 bytes
Database Buffers           50331648 bytes
Redo Buffers                5226496 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [0], [1821385], [0],
[1821572], [12583040], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [0], [1821384], [0],
[1821572], [12583040], [], [], [], [], [], []
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [0], [1821380], [0],
[1821572], [12583040], [], [], [], [], [], []
Process ID: 6750
Session ID: 17 Serial number: 3

出现了新的问题。
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-6-15 16:54 , Processed in 0.047758 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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