Fri Sep 5 15:31:03 2003
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 7.3.4.0.0.
System parameters with non-default values:
processes = 100
timed_statistics = TRUE
shared_pool_size = 28000000
nls_language = simplified chinese
nls_territory = China
control_files = /data/oradata/ECS/control01.ctl, /index/oradata/ECS/control02.ctl, /log/oradata/ECS/control03.ctl
compatible = 7.3.4
log_buffer = 1024000
log_checkpoint_interval = 2684354560
db_files = 99
checkpoint_process = TRUE
log_checkpoints_to_alert = TRUE
rollback_segments = r01, r02, r03, r04
sequence_cache_hash_buckets= 10
remote_login_passwordfile= NONE
mts_service = ECS
mts_servers = 0
mts_max_servers = 0
mts_max_dispatchers = 0
audit_trail = FALSE
sort_area_size = 2048000
sort_area_retained_size = 2048000
sort_direct_writes = AUTO
db_name = ECS
open_cursors = 100
ifile = /usr/local/app/oracle/admin/ECS/pfile/configECS.ora
partition_view_enabled = TRUE
job_queue_processes = 8
background_dump_dest = /usr/local/app/oracle/admin/ECS/bdump
user_dump_dest = /usr/local/app/oracle/admin/ECS/udump
core_dump_dest = /usr/local/app/oracle/admin/ECS/cdump
PMON started
DBWR started
LGWR started
CKPT started
RECO started
SNP0 started
SNP1 started
SNP2 started
SNP3 started
SNP4 started
SNP5 started
SNP6 started
SNP7 started
Fri Sep 5 15:31:03 2003
alter database mount exclusive
Fri Sep 5 15:31:03 2003
Successful mount of redo thread 1.
Fri Sep 5 15:31:03 2003
Completed: alter database mount exclusive
Fri Sep 5 15:31:03 2003
alter database open
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 2 Seq 389 Reading mem 0
Mem# 0 errs 0: /index/oradata/ECS/redoECS02.log
ORA-1172 signalled during: alter database open...
Shutting down instance (normal)
License high water mark = 9
Fri Sep 5 15:31:05 2003
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Sep 5 15:31:05 2003
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
4. 在startup.log 有:
Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Production
With the distributed and paTNSLSNR for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production
System parameter file is /usr/local/app/oracle/product/7.3.4/network/admin/listener.ora
Log messages written to /usr/local/app/oracle/product/7.3.4/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=172.16.24.102)(PORT=1521))
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=data)(Port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production
Start Date 05-SEP-03 18:13:30
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /usr/local/app/oracle/product/7.3.4/network/admin/listener.ora
Listener Log File /usr/local/app/oracle/product/7.3.4/network/log/listener.log
Services Summary...
ECS has 1 service handler(s)
The command completed successfully
/sbin/init.d/oracle: starting up
Mon Sep 8 08:18:37 CST 2003
LSNRCTL for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production on 08-SEP-03 08:18:37
Copyright (c) Oracle Corporation 1994. All rights reserved.
Oracle Server Manager Release 2.3.4.0.0 - Production
Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Production
With the distributed and parallel query options
PL/SQL Release 2.3.4.0.0 - Production
SVRMGR>; Connected to an idle instance.
SVRMGR>; ORACLE instance started.
Total System Global Area 55884096 bytes
Fixed Size 50832 bytes
Variable Size 30233264 bytes
Database Buffers 24576000 bytes
Redo Buffers 1024000 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 6785 of file 10
ORA-01151: use media recovery to recover block, restore backup if needed
SVRMGR>;
Server Manager complete.