- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-15 19:41:13
|
查看: 1292 |
回复: 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
出现了新的问题。
|
|