- 最后登录
- 2014-2-24
- 在线时间
- 5 小时
- 威望
- 0
- 金钱
- 45
- 注册时间
- 2013-11-19
- 阅读权限
- 10
- 帖子
- 14
- 精华
- 0
- 积分
- 0
- UID
- 1404
|
1#
发表于 2014-2-19 18:01:55
|
查看: 5380 |
回复: 16
数据库版本:10.1.0.2
OS:windows xp
无归档,无备份
异常断电之后数据库无法OPEN,报错提示:
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-00322: 日志 3 (用于线程 1) 不是当前副本
ORA-00312: 联机日志 3 线程 1:
'C:\XXXXXX\10.1.0\ORADATA\XXXXX\REDO03.LOG'
查看v$log信息如下
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
1 1 950 10485760 1 NO CURRENT
31017735 12-2月 -14
2 1 948 10485760 1 NO INACTIVE
31006691 12-2月 -14
3 1 949 10485760 1 NO ACTIVE
31012600 12-2月 -14
redo03的日志组状态时ACTIVE
准备做不完全恢复,使用_allow_resetlogs_corruption参数跳过一致性检查
SQL> show parameter all
NAME TYPE VALUE
------------------------------------ ----------- -----------------
_allow_resetlogs_corruption boolean TRUE
SQL> recover database until cancel;
ORA-00279: 更改 31012600 (在 02/12/2014 13:15:59 生成) 对于线程 1 是必需的
ORA-00289: 建议:
C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\xxxx\ARCHIVELOG\2014_02_19\O1_MF
_1_949_%U_.ARC
ORA-00280: 更改 31012600 (用于线程 1) 在序列 #949 中
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: 警告: RECOVER 成功但 OPEN RESETLOGS 将出现如下错误
ORA-01194: 文件 1 需要更多的恢复来保持一致性
ORA-01110: 数据文件 1: 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\xxxxx\SYSTEM01.DBF'
ORA-01112: 未启动介质恢复
SQL> alter database open resetlogs;
alter database open resetlogs
*
第 1 行出现错误:
ORA-01092: ORACLE 例程终止。强制断开连接
警告日志文件中有如下记录
ORA-00600: 内部错误代码, 参数: [kcbgtcr_13], [], [], [], [], [], [], []
Wed Feb 19 15:35:46 2014
Errors in file c:\oracle\product\10.1.0\admin\xxxx\udump\pstc_ora_732.trc:
ORA-00600: 内部错误代码, 参数: [kcbgtcr_13], [], [], [], [], [], [], []
Wed Feb 19 15:35:46 2014
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Wed Feb 19 15:35:46 2014
Errors in file c:\oracle\product\10.1.0\admin\xxxxx\bdump\pstc_lgwr_1556.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Wed Feb 19 15:35:46 2014
Errors in file c:\oracle\product\10.1.0\admin\xxxxx\bdump\pstc_mman_492.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Wed Feb 19 15:35:46 2014
Errors in file c:\oracle\product\10.1.0\admin\xxxx\bdump\pstc_ckpt_716.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Wed Feb 19 15:35:46 2014
Errors in file c:\oracle\product\10.1.0\admin\xxxxx\bdump\pstc_reco_1732.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Wed Feb 19 15:35:46 2014
Errors in file c:\oracle\product\10.1.0\admin\xxxxx\bdump\pstc_smon_780.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Wed Feb 19 15:35:46 2014
Errors in file c:\oracle\product\10.1.0\admin\xxxxx\bdump\pstc_dbw0_1276.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Instance terminated by USER, pid = 732
ORA-1092 signalled during: alter database open resetlogs...
刘大,帮忙看看啊;
|
|