Sun Oct 16 12:06:47 2005
alter database mount
Sun Oct 16 12:06:47 2005
ORA-00202: controlfile: '/data/data02/oradata/neva2dev/control01.ctl'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Sun Oct 16 12:06:50 2005
ORA-205 signalled during: alter database mount
...
Sun Oct 16 12:07:03 2005
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Sun Oct 16 12:07:04 2005
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun Oct 16 12:07:11 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = /data/data02/oradata/neva2dev/control01.ctl, /data/
data02/oradata/neva2dev/control02.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = neva2dev
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/neva2dev/bdump
user_dump_dest = /opt/oracle/admin/neva2dev/udump
core_dump_dest = /opt/oracle/admin/neva2dev/cdump
sort_area_size = 524288
db_name = neva2dev
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 268435456
aq_tm_processes = 1
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
QMN0 started with pid=9
Sun Oct 16 12:07:11 2005
ALTER DATABASE MOUNT
Sun Oct 16 12:07:11 2005
ORA-00202: controlfile: '/data/data02/oradata/neva2dev/control01.ctl'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Sun Oct 16 12:07:11 2005
ORA-205 signalled during: ALTER DATABASE MOUNT...
Sun Oct 16 12:24:19 2005
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Sun Oct 16 12:24:19 2005
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun Oct 16 12:41:00 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = /data/data02/oradata/neva2dev/control01.ctl, /data/
data02/oradata/neva2dev/control02.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = neva2dev
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/neva2dev/bdump
user_dump_dest = /opt/oracle/admin/neva2dev/udump
core_dump_dest = /opt/oracle/admin/neva2dev/cdump
sort_area_size = 524288
db_name = neva2dev
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 268435456
aq_tm_processes = 1
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
QMN0 started with pid=9
Sun Oct 16 12:41:01 2005
ALTER DATABASE MOUNT
Sun Oct 16 12:41:05 2005
Successful mount of redo thread 1, with mount id 3328332125.
Sun Oct 16 12:41:05 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sun Oct 16 12:41:05 2005
ALTER DATABASE OPEN
Sun Oct 16 12:41:05 2005
Beginning crash recovery of 1 threads
Sun Oct 16 12:41:05 2005
Started first pass scan
Sun Oct 16 12:41:09 2005
Completed first pass scan
293334 redo blocks read, 1327 data blocks need recovery
Sun Oct 16 12:41:09 2005
Started recovery at
Thread 1: logseq 1081, block 2, scn 0.164178338
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1081 Reading mem 0
Mem# 0 errs 0: /data/data02/oradata/neva2dev/redo0101.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1082 Reading mem 0
Mem# 0 errs 0: /data/data02/oradata/neva2dev/redo0201.log
Sun Oct 16 12:41:24 2005
Ended recovery at
Thread 1: logseq 1082, block 88539, scn 0.164524474
1327 data blocks read, 1327 data blocks written, 293334 redo blocks read
Crash recovery completed successfully
Sun Oct 16 12:41:24 2005
Thread 1 advanced to log sequence 1083
Thread 1 opened at log sequence 1083
Current log# 3 seq# 1083 mem# 0: /data/data02/oradata/neva2dev/redo0301.log
Successful open of redo thread 1.
Sun Oct 16 12:41:24 2005
SMON: enabling cache recovery
Sun Oct 16 12:41:25 2005
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.
Sun Oct 16 12:41:25 2005
SMON: enabling tx recovery
Sun Oct 16 12:41:25 2005
Database Characterset is ZHS16GBK
Sun Oct 16 12:41:25 2005
SMON: about to recover undo segment 23
SMON: mark undo segment 23 as available
SMON: about to recover undo segment 27
SMON: mark undo segment 27 as available
SMON: about to recover undo segment 42
SMON: mark undo segment 42 as available
SMON: about to recover undo segment 44
SMON: mark undo segment 44 as available
SMON: about to recover undo segment 50
SMON: mark undo segment 50 as available
SMON: about to recover undo segment 55
SMON: mark undo segment 55 as available
SMON: about to recover undo segment 69
SMON: mark undo segment 69 as available
SMON: about to recover undo segment 23
SMON: mark undo segment 23 as available
SMON: about to recover undo segment 27
SMON: mark undo segment 27 as available
SMON: about to recover undo segment 42
SMON: mark undo segment 42 as available
SMON: about to recover undo segment 44
SMON: mark undo segment 44 as available
SMON: about to recover undo segment 50
SMON: mark undo segment 50 as available
SMON: about to recover undo segment 55
SMON: mark undo segment 55 as available
SMON: about to recover undo segment 69
SMON: mark undo segment 69 as available
Sun Oct 16 12:41:27 2005
replication_dependency_tracking turned off (no async multimaster replication fou
nd)
Completed: ALTER DATABASE OPEN