- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-14 18:46:04
|
查看: 1392 |
回复: 0
*******************************************************************************
[YOU HAVE NEW MAIL]
omdrms10:/>su - oracle
omdrms10:/home/oracle>sqlplus '/as sysdba'
SQL*Plus: Release 9.2.0.4.0 - Production on Tue May 21 11:55:37 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2586808888 bytes
Fixed Size 746040 bytes
Variable Size 1006632960 bytes
Database Buffers 1577058304 bytes
Redo Buffers 2371584 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL>
alert.log 中对应日志
Tue May 21 11:57:14 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 550
sessions = 610
timed_statistics = TRUE
shared_pool_size = 385875968
sga_max_size = 2586808888
large_pool_size = 67108864
java_pool_size = 16777216
nls_date_format = DD-MON-RR
control_files = /RMSUAT/CHINACS/system/control01.ctl, /RMSUAT/CHINACS/system/control02.ctl
db_block_size = 8192
db_cache_size = 1577058304
compatible = 9.2.0
log_archive_start = FALSE
log_archive_dest_1 = LOCATION=/RMSUAT/CHINACS/archive
log_archive_dest_state_1 = ENABLE
log_archive_format = %t_%s.dbf
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
max_enabled_roles = 120
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CHINACS
job_queue_processes = 3
background_dump_dest = /RMSUAT/CHINACS/admin/bdump
user_dump_dest = /RMSUAT/CHINACS/admin/udump
core_dump_dest = /RMSUAT/CHINACS/admin/cdump
sort_area_size = 524288
db_name = CHINACS
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
CJQ0 started with pid=9
Tue May 21 11:57:15 2013
ALTER DATABASE MOUNT
Tue May 21 11:57:19 2013
Successful mount of redo thread 1, with mount id 3177414875.
Tue May 21 11:57:19 2013
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue May 21 11:57:19 2013
ALTER DATABASE OPEN
Tue May 21 11:57:19 2013
Beginning crash recovery of 1 threads
Tue May 21 11:57:19 2013
Started first pass scan
Tue May 21 11:57:20 2013
Completed first pass scan
48 redo blocks read, 5 data blocks need recovery
Tue May 21 11:57:20 2013
Started recovery at
Thread 1: logseq 4, block 2, scn 1603.3732743047
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
Mem# 0 errs 0: /RMSUAT/CHINACS/system/redo4.log
Tue May 21 11:57:20 2013
Completed redo application
Tue May 21 11:57:20 2013
Ended recovery at
Thread 1: logseq 4, block 50, scn 1603.3732763088
5 data blocks read, 5 data blocks written, 48 redo blocks read
Crash recovery completed successfully
Tue May 21 11:57:20 2013
Thread 1 advanced to log sequence 5
Thread 1 opened at log sequence 5
Current log# 5 seq# 5 mem# 0: /RMSUAT/CHINACS/system/redo5.log
Successful open of redo thread 1.
Tue May 21 11:57:20 2013
SMON: enabling cache recovery
Tue May 21 11:57:20 2013
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue May 21 11:57:20 2013
SMON: enabling tx recovery
Tue May 21 11:57:21 2013
Database Characterset is UTF8
Tue May 21 11:57:21 2013
Errors in file /RMSUAT/CHINACS/admin/udump/chinacs_ora_4309068.trc:
ORA-00600: internal error code, arguments: [4194], [4], [4], [], [], [], [], []
Recovery of Online Redo Log: Thread 1 Group 5 Seq 5 Reading mem 0
Mem# 0 errs 0: /RMSUAT/CHINACS/system/redo5.log
Recovery of Online Redo Log: Thread 1 Group 5 Seq 5 Reading mem 0
Mem# 0 errs 0: /RMSUAT/CHINACS/system/redo5.log
Tue May 21 11:57:21 2013
Errors in file /RMSUAT/CHINACS/admin/udump/chinacs_ora_4309068.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [4], [4], [], [], [], [], []
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_dbw0_4452400.trc:
ORA-00607: Internal error occurred while making a change to a data block
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_pmon_4031054.trc:
ORA-00607: Internal error occurred while making a change to a data block
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_lgwr_4468776.trc:
ORA-00607: Internal error occurred while making a change to a data block
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_dbw1_3506976.trc:
ORA-00607: Internal error occurred while making a change to a data block
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_ckpt_3502912.trc:
ORA-00607: Internal error occurred while making a change to a data block
Tue May 21 11:57:24 2013
Errors in file /RMSUAT/CHINACS/admin/bdump/chinacs_smon_4010504.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-12801: error signaled in parallel query server P001
ORA-30317: Internal
Instance terminated by USER, pid = 4309068
ORA-1092 signalled during: ALTER DATABASE OPEN...
|
|