- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
2#
发表于 2017-4-16 16:32:02
之前的操作在上面我都说了,现在我启用的隐含参数_allow_resetlogs_corruption=true,想强行打开数据库,就变成这样了,以下是alert文件的信息
Ended recovery at
Thread 1: logseq 2, block 3, scn 3.2247867976
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sun Aug 19 12:08:55 2007
Thread 1 advanced to log sequence 3
Thread 1 opened at log sequence 3
Current log# 2 seq# 3 mem# 0: /export/home/oracle/OraHome1/oradata/cy4dc02/red
o02.log
Successful open of redo thread 1.
Sun Aug 19 12:08:55 2007
SMON: enabling cache recovery
Sun Aug 19 12:08:55 2007
ARC0: Media recovery disabled
Sun Aug 19 12:08:55 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395
8.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248
361909], [8388613], [], []
Sun Aug 19 12:08:57 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395
8.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248
361909], [8388613], [], []
Sun Aug 19 12:08:57 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 13958
ORA-1092 signalled during: ALTER DATABASE OPEN...
Sun Aug 19 12:13:57 2007
USER: terminating instance due to error 1092
Instance terminated by USER, pid = 13958
Sun Aug 19 12:13:57 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395
8.trc:
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248
361909], [8388613], [], []
$ tail -200 alert_cy4dc02.log
_allow_resetlogs_corruption= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain = cy4.dqyt.petrochina
instance_name = cy4dc02
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=orac
le.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServe
r)
job_queue_processes = 14
background_dump_dest = /export/home/oracle/OraHome1/admin/cy4dc02/bdump
user_dump_dest = /export/home/oracle/OraHome1/admin/cy4dc02/udump
core_dump_dest = /export/home/oracle/OraHome1/admin/cy4dc02/cdump
sort_area_size = 109715200
db_name = cy4dc02
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Sun Aug 19 11:01:14 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL
=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL
=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL
=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=13
Sun Aug 19 11:01:14 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Sun Aug 19 11:01:14 2007
ARC0: Archival started
ARC0: Thread not mounted
Sun Aug 19 11:01:14 2007
ALTER DATABASE MOUNT
Sun Aug 19 11:01:21 2007
Successful mount of redo thread 1, with mount id 3059476989.
Sun Aug 19 11:01:21 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sun Aug 19 11:03:19 2007
alter database clear unarchived logfile group 1
Sun Aug 19 11:03:19 2007
Clearing online log 1 of thread 1 sequence number 0
Completed: alter database clear unarchived logfile group 1
Sun Aug 19 11:03:32 2007
alter database open
Sun Aug 19 11:03:32 2007
Beginning crash recovery of 1 threads
Sun Aug 19 11:03:32 2007
Started first pass scan
Sun Aug 19 11:03:32 2007
Completed first pass scan
Sun Aug 19 11:03:32 2007
Started recovery at
Thread 1: logseq 1, block 3, scn 3.2247827972
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1 Reading mem 0
Mem# 0 errs 0: /export/home/oracle/OraHome1/oradata/cy4dc02/redo03.log
Sun Aug 19 11:03:32 2007
Ended recovery at
Thread 1: logseq 1, block 3, scn 3.2247847973
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sun Aug 19 11:03:33 2007
Thread 1 advanced to log sequence 2
Thread 1 opened at log sequence 2
Current log# 1 seq# 2 mem# 0: /export/home/oracle/OraHome1/oradata/cy4dc02/red
o01.log
Successful open of redo thread 1.
Sun Aug 19 11:03:33 2007
ARC0: Media recovery disabled
Sun Aug 19 11:03:33 2007
SMON: enabling cache recovery
Sun Aug 19 11:03:33 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1382
0.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247847978], [3], [2248
361909], [8388613], [], []
Sun Aug 19 11:03:34 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1382
0.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247847978], [3], [2248
361909], [8388613], [], []
Sun Aug 19 11:03:34 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 13820
ORA-1092 signalled during: alter database open...
Sun Aug 19 11:08:35 2007
USER: terminating instance due to error 1092
Instance terminated by USER, pid = 13820
Sun Aug 19 11:08:35 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1382
0.trc:
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [3], [2247847978], [3], [2248
361909], [8388613], [], []
Sun Aug 19 12:08:43 2007
Starting ORACLE instance (force)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 9.0.1.0.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size = 50857600
java_pool_size = 67108864
resource_manager_plan = SYSTEM_PLAN
control_files = /export/home/oracle/OraHome1/oradata/cy4dc02/contro
l01.ctl, /export/home1/orasysdata/control02.ctl, /export/home2/oradata/control03
.ctl
db_block_size = 16384
ARC0: Media recovery disabled
Sun Aug 19 12:08:55 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395
8.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248
361909], [8388613], [], []
Sun Aug 19 12:08:57 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395
8.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248
361909], [8388613], [], []
Sun Aug 19 12:08:57 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 13958
ORA-1092 signalled during: ALTER DATABASE OPEN...
Sun Aug 19 12:13:57 2007
USER: terminating instance due to error 1092
Instance terminated by USER, pid = 13958
Sun Aug 19 12:13:57 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395
8.trc:
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248
361909], [8388613], [], []
$ |
|