Home » RDBMS Server » Server Administration » logging on to oracle8i
| logging on to oracle8i [message #62758] |
Wed, 11 August 2004 22:04  |
dhananjaya R
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
i am using the following oracle ver:
SQL*Plus: Release 8.1.6.0.0 - Production on Thu Aug 12 11:11:08 2004
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
SQL>
********************************
this is my alert log file(aimsALRT.log)
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Mon Jul 19 15:24:35 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Mon Jul 19 15:24:38 2004
CREATE DATABASE aims
LOGFILE 'C:Oracleoradataaimsredo01.log' SIZE 1024K,
'C:Oracleoradataaimsredo02.log' SIZE 1024K,
'C:Oracleoradataaimsredo03.log' SIZE 1024K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'C:Oracleoradataaimssystem01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1
Mon Jul 19 15:24:39 2004
Database mounted in Exclusive Mode.
Mon Jul 19 15:24:43 2004
Successful mount of redo thread 1, with mount id 2232614518.
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Successful open of redo thread 1.
Mon Jul 19 15:24:43 2004
SMON: enabling cache recovery
Mon Jul 19 15:24:43 2004
create tablespace SYSTEM datafile 'C:Oracleoradataaimssystem01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
default storage (initial 10K next 10K) online
Mon Jul 19 15:24:47 2004
Completed: create tablespace SYSTEM datafile 'C:Oracleorad
Mon Jul 19 15:24:47 2004
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Mon Jul 19 15:24:48 2004
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 3
Current log# 3 seq# 3 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 4
Current log# 1 seq# 4 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 5
Current log# 2 seq# 5 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 6
Current log# 3 seq# 6 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 7
Current log# 1 seq# 7 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 8
Current log# 2 seq# 8 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Mon Jul 19 15:25:01 2004
SMON: enabling tx recovery
Mon Jul 19 15:25:03 2004
Completed: CREATE DATABASE aims
LOGFILE 'C:Oracleoradataai
Mon Jul 19 15:25:18 2004
ALTER TABLESPACE SYSTEM
DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 50)
Completed: ALTER TABLESPACE SYSTEM
DEFAULT STORAGE ( INITIAL
Mon Jul 19 15:25:18 2004
ALTER TABLESPACE SYSTEM
MINIMUM EXTENT 64K
Completed: ALTER TABLESPACE SYSTEM
MINIMUM EXTENT 64K
Mon Jul 19 15:25:18 2004
CREATE TABLESPACE RBS DATAFILE 'C:Oracleoradataaimsrbs01.dbf' SIZE 520M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096)
Mon Jul 19 15:25:39 2004
Completed: CREATE TABLESPACE RBS DATAFILE 'C:Oracleoradata
Mon Jul 19 15:25:39 2004
CREATE TABLESPACE USERS DATAFILE 'C:Oracleoradataaimsusers01.dbf' SIZE 108M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0)
Completed: CREATE TABLESPACE USERS DATAFILE 'C:Oracleoradat
Mon Jul 19 15:25:44 2004
CREATE TABLESPACE TEMP DATAFILE 'C:Oracleoradataaimstemp01.dbf' SIZE 72M REUSE
AUTOEXTEND ON NEXT 640K
MINIMUM EXTENT 64K
DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) TEMPORARY
Completed: CREATE TABLESPACE TEMP DATAFILE 'C:Oracleoradata
Mon Jul 19 15:25:48 2004
CREATE TABLESPACE TOOLS DATAFILE 'C:Oracleoradataaimstools01.dbf' SIZE 12M REUSE
AUTOEXTEND ON NEXT 320K
MINIMUM EXTENT 32K
DEFAULT STORAGE ( INITIAL 32K NEXT 32K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0)
Completed: CREATE TABLESPACE TOOLS DATAFILE 'C:Oracleoradat
Mon Jul 19 15:25:50 2004
CREATE TABLESPACE INDX DATAFILE 'C:Oracleoradataaimsindx01.dbf' SIZE 58M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0)
Completed: CREATE TABLESPACE INDX DATAFILE 'C:Oracleoradata
Mon Jul 19 15:25:53 2004
CREATE PUBLIC ROLLBACK SEGMENT RBS0 TABLESPACE RBS
STORAGE ( OPTIMAL 4096K )
Completed: CREATE PUBLIC ROLLBACK SEGMENT RBS0 TABLESPACE RBS
Mon Jul 19 15:25:53 2004
CREATE PUBLIC ROLLBACK SEGMENT RBS1 TABLESPACE RBS
STORAGE ( OPTIMAL 4096K )
Completed: CREATE PUBLIC ROLLBACK SEGMENT RBS1 TABLESPACE RBS
Mon Jul 19 15:25:53 2004
ALTER ROLLBACK SEGMENT "RBS0" ONLINE
Completed: ALTER ROLLBACK SEGMENT "RBS0" ONLINE
Mon Jul 19 15:25:53 2004
ALTER ROLLBACK SEGMENT "RBS1" ONLINE
Completed: ALTER ROLLBACK SEGMENT "RBS1" ONLINE
Mon Jul 19 15:25:57 2004
Thread 1 advanced to log sequence 9
Current log# 3 seq# 9 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 10
Current log# 1 seq# 10 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 11
Current log# 2 seq# 11 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 12
Current log# 3 seq# 12 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 13
Current log# 1 seq# 13 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 14
Current log# 2 seq# 14 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 15
Current log# 3 seq# 15 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 16
Current log# 1 seq# 16 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 17
Current log# 2 seq# 17 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 18
Current log# 3 seq# 18 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 19
Current log# 1 seq# 19 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 20
Current log# 2 seq# 20 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 21
Current log# 3 seq# 21 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 22
Current log# 1 seq# 22 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 23
Current log# 2 seq# 23 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 24
Current log# 3 seq# 24 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 25
Current log# 1 seq# 25 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 26
Current log# 2 seq# 26 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 27
Current log# 3 seq# 27 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 28
Current log# 1 seq# 28 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 29
Current log# 2 seq# 29 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 30
Current log# 3 seq# 30 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 31
Current log# 1 seq# 31 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 32
Current log# 2 seq# 32 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 33
Current log# 3 seq# 33 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 34
Current log# 1 seq# 34 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 35
Current log# 2 seq# 35 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 36
Current log# 3 seq# 36 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 37
Current log# 1 seq# 37 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 38
Current log# 2 seq# 38 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 39
Current log# 3 seq# 39 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 40
Current log# 1 seq# 40 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 41
Current log# 2 seq# 41 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 42
Current log# 3 seq# 42 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 43
Current log# 1 seq# 43 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 44
Checkpoint not complete
Current log# 1 seq# 43 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 44
Current log# 2 seq# 44 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 45
Current log# 3 seq# 45 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 46
Checkpoint not complete
Current log# 3 seq# 45 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 46
Current log# 1 seq# 46 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 47
Current log# 2 seq# 47 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 cannot allocate new log, sequence 48
Checkpoint not complete
Current log# 2 seq# 47 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 48
Current log# 3 seq# 48 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 49
Current log# 1 seq# 49 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 50
Current log# 2 seq# 50 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 51
Current log# 3 seq# 51 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 52
Checkpoint not complete
Current log# 3 seq# 51 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 52
Current log# 1 seq# 52 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 53
Current log# 2 seq# 53 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 cannot allocate new log, sequence 54
Checkpoint not complete
Current log# 2 seq# 53 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 54
Current log# 3 seq# 54 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 55
Current log# 1 seq# 55 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 56
Current log# 2 seq# 56 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 57
Current log# 3 seq# 57 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 58
Current log# 1 seq# 58 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 59
Current log# 2 seq# 59 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 60
Current log# 3 seq# 60 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 61
Checkpoint not complete
Current log# 3 seq# 60 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 61
Current log# 1 seq# 61 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 62
Current log# 2 seq# 62 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 63
Current log# 3 seq# 63 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 64
Current log# 1 seq# 64 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 65
Current log# 2 seq# 65 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 cannot allocate new log, sequence 66
Checkpoint not complete
Current log# 2 seq# 65 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 66
Current log# 3 seq# 66 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 67
Current log# 1 seq# 67 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 68
Current log# 2 seq# 68 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 69
Current log# 3 seq# 69 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 70
Current log# 1 seq# 70 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 71
Current log# 2 seq# 71 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Mon Jul 19 15:29:33 2004
Thread 1 advanced to log sequence 72
Current log# 3 seq# 72 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 73
Current log# 1 seq# 73 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 74
Current log# 2 seq# 74 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 75
Current log# 3 seq# 75 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 76
Checkpoint not complete
Current log# 3 seq# 75 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 76
Current log# 1 seq# 76 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 77
Current log# 2 seq# 77 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 78
Current log# 3 seq# 78 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 79
Current log# 1 seq# 79 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 80
Checkpoint not complete
Current log# 1 seq# 79 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 80
Current log# 2 seq# 80 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 81
Current log# 3 seq# 81 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 82
Checkpoint not complete
Current log# 3 seq# 81 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 82
Current log# 1 seq# 82 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 83
Current log# 2 seq# 83 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 84
Current log# 3 seq# 84 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 85
Current log# 1 seq# 85 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 86
Current log# 2 seq# 86 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 87
Current log# 3 seq# 87 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 88
Current log# 1 seq# 88 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 89
Current log# 2 seq# 89 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 90
Current log# 3 seq# 90 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 91
Current log# 1 seq# 91 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 92
Checkpoint not complete
Current log# 1 seq# 91 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 92
Current log# 2 seq# 92 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 93
Current log# 3 seq# 93 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 94
Current log# 1 seq# 94 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 95
Current log# 2 seq# 95 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 96
Current log# 3 seq# 96 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 97
Checkpoint not complete
Current log# 3 seq# 96 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 97
Current log# 1 seq# 97 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 98
Current log# 2 seq# 98 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 99
Current log# 3 seq# 99 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 100
Checkpoint not complete
Current log# 3 seq# 99 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 100
Current log# 1 seq# 100 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 101
Current log# 2 seq# 101 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 102
Current log# 3 seq# 102 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 103
Current log# 1 seq# 103 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 104
Current log# 2 seq# 104 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 105
Current log# 3 seq# 105 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 106
Current log# 1 seq# 106 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 107
Current log# 2 seq# 107 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 108
Current log# 3 seq# 108 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 109
Current log# 1 seq# 109 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 110
Current log# 2 seq# 110 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 111
Current log# 3 seq# 111 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 112
Current log# 1 seq# 112 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 113
Checkpoint not complete
Current log# 1 seq# 112 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 113
Current log# 2 seq# 113 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 114
Current log# 3 seq# 114 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 115
Current log# 1 seq# 115 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 116
Checkpoint not complete
Current log# 1 seq# 115 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 116
Current log# 2 seq# 116 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 117
Current log# 3 seq# 117 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 118
Current log# 1 seq# 118 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 119
Checkpoint not complete
Current log# 1 seq# 118 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 119
Current log# 2 seq# 119 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 120
Current log# 3 seq# 120 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 121
Current log# 1 seq# 121 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 122
Current log# 2 seq# 122 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 123
Current log# 3 seq# 123 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 124
Current log# 1 seq# 124 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 125
Checkpoint not complete
Current log# 1 seq# 124 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 125
Current log# 2 seq# 125 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 126
Current log# 3 seq# 126 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 127
Current log# 1 seq# 127 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 128
Current log# 2 seq# 128 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 cannot allocate new log, sequence 129
Checkpoint not complete
Current log# 2 seq# 128 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 129
Current log# 3 seq# 129 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 130
Current log# 1 seq# 130 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 131
Current log# 2 seq# 131 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 132
Current log# 3 seq# 132 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 133
Current log# 1 seq# 133 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 134
Current log# 2 seq# 134 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 cannot allocate new log, sequence 135
Checkpoint not complete
Current log# 2 seq# 134 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 135
Current log# 3 seq# 135 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 136
Current log# 1 seq# 136 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 137
Checkpoint not complete
Current log# 1 seq# 136 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 137
Current log# 2 seq# 137 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 138
Current log# 3 seq# 138 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 139
Current log# 1 seq# 139 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 140
Checkpoint not complete
Current log# 1 seq# 139 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 140
Current log# 2 seq# 140 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 141
Current log# 3 seq# 141 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 142
Checkpoint not complete
Current log# 3 seq# 141 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 142
Current log# 1 seq# 142 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 143
Current log# 2 seq# 143 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 144
Current log# 3 seq# 144 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 145
Checkpoint not complete
Current log# 3 seq# 144 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 145
Current log# 1 seq# 145 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 146
Current log# 2 seq# 146 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 147
Current log# 3 seq# 147 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 148
Current log# 1 seq# 148 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 149
Current log# 2 seq# 149 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 150
Current log# 3 seq# 150 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 151
Checkpoint not complete
Current log# 3 seq# 150 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 151
Current log# 1 seq# 151 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 152
Current log# 2 seq# 152 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 153
Current log# 3 seq# 153 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 154
Checkpoint not complete
Current log# 3 seq# 153 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 154
Current log# 1 seq# 154 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 155
Current log# 2 seq# 155 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 156
Current log# 3 seq# 156 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 157
Current log# 1 seq# 157 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 158
Current log# 2 seq# 158 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 159
Current log# 3 seq# 159 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 160
Current log# 1 seq# 160 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 161
Current log# 2 seq# 161 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 162
Current log# 3 seq# 162 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 163
Current log# 1 seq# 163 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 164
Current log# 2 seq# 164 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Mon Jul 19 15:34:26 2004
Thread 1 advanced to log sequence 165
Current log# 3 seq# 165 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 166
Checkpoint not complete
Current log# 3 seq# 165 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 166
Current log# 1 seq# 166 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 167
Current log# 2 seq# 167 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 cannot allocate new log, sequence 168
Checkpoint not complete
Current log# 2 seq# 167 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 168
Current log# 3 seq# 168 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 169
Current log# 1 seq# 169 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 170
Current log# 2 seq# 170 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 171
Current log# 3 seq# 171 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 172
Checkpoint not complete
Current log# 3 seq# 171 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 172
Current log# 1 seq# 172 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 173
Current log# 2 seq# 173 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 174
Current log# 3 seq# 174 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 cannot allocate new log, sequence 175
Checkpoint not complete
Current log# 3 seq# 174 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 175
Current log# 1 seq# 175 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 176
Current log# 2 seq# 176 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 177
Current log# 3 seq# 177 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 178
Current log# 1 seq# 178 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 179
Current log# 2 seq# 179 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 180
Current log# 3 seq# 180 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 181
Current log# 1 seq# 181 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 182
Current log# 2 seq# 182 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 183
Current log# 3 seq# 183 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 184
Current log# 1 seq# 184 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 185
Current log# 2 seq# 185 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 186
Current log# 3 seq# 186 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 187
Current log# 1 seq# 187 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 188
Current log# 2 seq# 188 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 189
Current log# 3 seq# 189 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 190
Current log# 1 seq# 190 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 191
Current log# 2 seq# 191 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Mon Jul 19 15:35:57 2004
Thread 1 advanced to log sequence 192
Current log# 3 seq# 192 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Mon Jul 19 15:40:52 2004
Thread 1 advanced to log sequence 193
Current log# 1 seq# 193 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 194
Current log# 2 seq# 194 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 195
Current log# 3 seq# 195 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 196
Current log# 1 seq# 196 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 197
Current log# 2 seq# 197 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 198
Current log# 3 seq# 198 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 199
Current log# 1 seq# 199 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Jul 20 14:08:16 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Tue Jul 20 14:08:21 2004
alter database mount exclusive
Tue Jul 20 14:08:26 2004
Successful mount of redo thread 1, with mount id 2232688154.
Tue Jul 20 14:08:26 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 20 14:08:26 2004
alter database open
Beginning crash recovery of 1 threads
Tue Jul 20 14:08:27 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 199 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO01.LOG
Tue Jul 20 14:08:27 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Tue Jul 20 14:08:28 2004
Thread 1 advanced to log sequence 200
Thread 1 opened at log sequence 200
Current log# 2 seq# 200 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Successful open of redo thread 1.
Tue Jul 20 14:08:29 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Jul 20 14:08:33 2004
Completed: alter database open
Tue Jul 20 14:13:30 2004
Thread 1 advanced to log sequence 201
Current log# 3 seq# 201 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 202
Current log# 1 seq# 202 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 203
Current log# 2 seq# 203 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 204
Current log# 3 seq# 204 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 205
Current log# 1 seq# 205 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Tue Jul 20 14:14:08 2004
Thread 1 advanced to log sequence 206
Current log# 2 seq# 206 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Tue Jul 20 14:14:29 2004
Thread 1 advanced to log sequence 207
Current log# 3 seq# 207 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Wed Jul 21 09:32:31 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Wed Jul 21 09:32:36 2004
alter database mount exclusive
Wed Jul 21 09:32:41 2004
Successful mount of redo thread 1, with mount id 2232720121.
Wed Jul 21 09:32:41 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Jul 21 09:32:41 2004
alter database open
Beginning crash recovery of 1 threads
Wed Jul 21 09:32:42 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 207 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO03.LOG
Wed Jul 21 09:32:42 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Wed Jul 21 09:32:43 2004
Thread 1 advanced to log sequence 208
Thread 1 opened at log sequence 208
Current log# 1 seq# 208 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Successful open of redo thread 1.
Wed Jul 21 09:32:43 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Jul 21 09:32:47 2004
Completed: alter database open
Wed Jul 21 09:36:38 2004
Thread 1 advanced to log sequence 209
Current log# 2 seq# 209 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Wed Jul 21 09:40:56 2004
Thread 1 advanced to log sequence 210
Current log# 3 seq# 210 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 211
Current log# 1 seq# 211 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 212
Checkpoint not complete
Current log# 1 seq# 211 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 212
Current log# 2 seq# 212 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 213
Current log# 3 seq# 213 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 214
Current log# 1 seq# 214 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 215
Checkpoint not complete
Current log# 1 seq# 214 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 215
Current log# 2 seq# 215 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 216
Current log# 3 seq# 216 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Mon Jul 26 13:47:14 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Mon Jul 26 13:47:20 2004
alter database mount exclusive
Mon Jul 26 13:47:24 2004
Successful mount of redo thread 1, with mount id 2233175084.
Mon Jul 26 13:47:24 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Jul 26 13:47:25 2004
alter database open
Beginning crash recovery of 1 threads
Mon Jul 26 13:47:25 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 216 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO03.LOG
Mon Jul 26 13:47:25 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Mon Jul 26 13:47:26 2004
Thread 1 advanced to log sequence 217
Thread 1 opened at log sequence 217
Current log# 1 seq# 217 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Successful open of redo thread 1.
Mon Jul 26 13:47:27 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Jul 26 13:47:30 2004
Completed: alter database open
Mon Jul 26 13:52:26 2004
Thread 1 advanced to log sequence 218
Current log# 2 seq# 218 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Mon Jul 26 13:55:30 2004
Thread 1 advanced to log sequence 219
Current log# 3 seq# 219 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 220
Current log# 1 seq# 220 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 221
Current log# 2 seq# 221 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 222
Current log# 3 seq# 222 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 223
Current log# 1 seq# 223 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 224
Checkpoint not complete
Current log# 1 seq# 223 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 224
Current log# 2 seq# 224 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 225
Current log# 3 seq# 225 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Mon Jul 26 13:58:24 2004
Thread 1 advanced to log sequence 226
Current log# 1 seq# 226 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 227
Current log# 2 seq# 227 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Mon Jul 26 13:58:37 2004
kccrsz: expanded controlfile section 9 from 226 to 453 records
requested to grow by 2 record(s); added 1 block(s) of records
Thread 1 advanced to log sequence 228
Current log# 3 seq# 228 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 229
Current log# 1 seq# 229 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 230
Current log# 2 seq# 230 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Mon Jul 26 14:46:48 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Mon Jul 26 14:46:53 2004
alter database mount exclusive
Mon Jul 26 14:46:58 2004
Successful mount of redo thread 1, with mount id 2233188129.
Mon Jul 26 14:46:58 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Jul 26 14:46:58 2004
alter database open
Beginning crash recovery of 1 threads
Mon Jul 26 14:46:59 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 230 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO02.LOG
Mon Jul 26 14:46:59 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Mon Jul 26 14:47:00 2004
Thread 1 advanced to log sequence 231
Thread 1 opened at log sequence 231
Current log# 3 seq# 231 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Successful open of redo thread 1.
Mon Jul 26 14:47:01 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Jul 26 14:47:04 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Mon Jul 26 15:10:19 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Mon Jul 26 15:10:25 2004
alter database mount exclusive
Mon Jul 26 15:10:30 2004
Successful mount of redo thread 1, with mount id 2233185701.
Mon Jul 26 15:10:30 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Jul 26 15:10:30 2004
alter database open
Beginning crash recovery of 1 threads
Mon Jul 26 15:10:30 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 231 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO03.LOG
Mon Jul 26 15:10:31 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 10 data blocks read, 10 data blocks written, 25 redo blocks read
Crash recovery completed successfully
Mon Jul 26 15:10:32 2004
Thread 1 advanced to log sequence 232
Thread 1 opened at log sequence 232
Current log# 1 seq# 232 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Successful open of redo thread 1.
Mon Jul 26 15:10:32 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Jul 26 15:10:39 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Jul 27 10:15:59 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Tue Jul 27 10:16:05 2004
alter database mount exclusive
Tue Jul 27 10:16:09 2004
Successful mount of redo thread 1, with mount id 2233245993.
Tue Jul 27 10:16:09 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 27 10:16:09 2004
alter database open
Beginning crash recovery of 1 threads
Tue Jul 27 10:16:10 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 232 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO01.LOG
Tue Jul 27 10:16:12 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Tue Jul 27 10:16:13 2004
Thread 1 advanced to log sequence 233
Thread 1 opened at log sequence 233
Current log# 2 seq# 233 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Successful open of redo thread 1.
Tue Jul 27 10:16:13 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Jul 27 10:16:17 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Wed Jul 28 11:25:27 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Wed Jul 28 11:25:33 2004
alter database mount exclusive
Wed Jul 28 11:25:38 2004
Successful mount of redo thread 1, with mount id 2233371633.
Wed Jul 28 11:25:38 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Jul 28 11:25:38 2004
alter database open
Beginning crash recovery of 1 threads
Wed Jul 28 11:25:38 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 233 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO02.LOG
Wed Jul 28 11:25:39 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Wed Jul 28 11:25:40 2004
Thread 1 advanced to log sequence 234
Thread 1 opened at log sequence 234
Current log# 3 seq# 234 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Successful open of redo thread 1.
Wed Jul 28 11:25:40 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Jul 28 11:25:44 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Thu Jul 29 16:06:14 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Thu Jul 29 16:06:19 2004
alter database mount exclusive
Thu Jul 29 16:06:24 2004
Successful mount of redo thread 1, with mount id 2233441343.
Thu Jul 29 16:06:24 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Jul 29 16:06:24 2004
alter database open
Beginning crash recovery of 1 threads
Thu Jul 29 16:06:25 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 234 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO03.LOG
Thu Jul 29 16:06:25 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Jul 29 16:06:26 2004
Thread 1 advanced to log sequence 235
Thread 1 opened at log sequence 235
Current log# 1 seq# 235 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Successful open of redo thread 1.
Thu Jul 29 16:06:26 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Jul 29 16:06:30 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Fri Jul 30 17:27:51 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Fri Jul 30 17:27:57 2004
alter database mount exclusive
Fri Jul 30 17:28:01 2004
Successful mount of redo thread 1, with mount id 2233605601.
Fri Jul 30 17:28:01 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Jul 30 17:28:01 2004
alter database open
Beginning crash recovery of 1 threads
Fri Jul 30 17:28:03 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 235 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO01.LOG
Fri Jul 30 17:28:04 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Fri Jul 30 17:28:05 2004
Thread 1 advanced to log sequence 236
Thread 1 opened at log sequence 236
Current log# 2 seq# 236 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Successful open of redo thread 1.
Fri Jul 30 17:28:05 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Jul 30 17:28:12 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Fri Jul 30 17:34:15 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Fri Jul 30 17:35:56 2004
Shutting down instance (immediate)
License high water mark = 1
Fri Jul 30 17:35:56 2004
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Fri Jul 30 17:36:57 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Fri Jul 30 17:36:59 2004
alter database mount exclusive
Fri Jul 30 17:37:04 2004
Successful mount of redo thread 1, with mount id 2233574399.
Fri Jul 30 17:37:05 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Jul 30 17:37:05 2004
alter database open
Beginning crash recovery of 1 threads
Fri Jul 30 17:37:06 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 236 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO02.LOG
Fri Jul 30 17:37:07 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 8 data blocks read, 8 data blocks written, 15 redo blocks read
Crash recovery completed successfully
Fri Jul 30 17:37:08 2004
Thread 1 advanced to log sequence 237
Thread 1 opened at log sequence 237
Current log# 3 seq# 237 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Successful open of redo thread 1.
Fri Jul 30 17:37:09 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Jul 30 17:37:15 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Sat Jul 31 11:45:23 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Sat Jul 31 11:45:28 2004
alter database mount exclusive
Sat Jul 31 11:45:33 2004
Successful mount of redo thread 1, with mount id 2233679133.
Sat Jul 31 11:45:33 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sat Jul 31 11:45:33 2004
alter database open
Beginning crash recovery of 1 threads
Sat Jul 31 11:45:34 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 237 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO03.LOG
Sat Jul 31 11:45:35 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 8 data blocks read, 8 data blocks written, 15 redo blocks read
Crash recovery completed successfully
Sat Jul 31 11:45:36 2004
Thread 1 advanced to log sequence 238
Thread 1 opened at log sequence 238
Current log# 1 seq# 238 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Successful open of redo thread 1.
Sat Jul 31 11:45:36 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Sat Jul 31 11:45:42 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Mon Aug 02 16:11:11 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Mon Aug 02 16:11:16 2004
alter database mount exclusive
Mon Aug 02 16:11:21 2004
Successful mount of redo thread 1, with mount id 2233849704.
Mon Aug 02 16:11:21 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Aug 02 16:11:21 2004
alter database open
Beginning crash recovery of 1 threads
Mon Aug 02 16:11:22 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 238 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO01.LOG
Mon Aug 02 16:11:22 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Mon Aug 02 16:11:23 2004
Thread 1 advanced to log sequence 239
Thread 1 opened at log sequence 239
Current log# 2 seq# 239 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Successful open of redo thread 1.
Mon Aug 02 16:11:24 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Aug 02 16:11:27 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Aug 03 11:36:24 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Tue Aug 03 11:36:30 2004
alter database mount exclusive
Tue Aug 03 11:36:34 2004
Successful mount of redo thread 1, with mount id 2233933698.
Tue Aug 03 11:36:34 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Aug 03 11:36:35 2004
alter database open
Beginning crash recovery of 1 threads
Tue Aug 03 11:36:35 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 239 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO02.LOG
Tue Aug 03 11:36:36 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Tue Aug 03 11:36:36 2004
Thread 1 advanced to log sequence 240
Thread 1 opened at log sequence 240
Current log# 3 seq# 240 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Successful open of redo thread 1.
Tue Aug 03 11:36:37 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Aug 03 11:36:41 2004
Completed: alter database open
Shutting down instance (immediate)
License high water mark = 1
Tue Aug 03 11:39:11 2004
alter database close normal
Tue Aug 03 11:39:11 2004
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Aug 03 11:39:12 2004
Thread 1 closed at log sequence 240
Tue Aug 03 11:39:12 2004
Completed: alter database close normal
Tue Aug 03 11:39:12 2004
alter database dismount
Completed: alter database dismount
archiving is disabled
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Aug 03 11:46:16 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Tue Aug 03 11:47:27 2004
Shutting down instance (immediate)
License high water mark = 1
Tue Aug 03 11:47:27 2004
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Aug 03 11:48:47 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Tue Aug 03 11:48:49 2004
alter database mount exclusive
Tue Aug 03 11:48:54 2004
Successful mount of redo thread 1, with mount id 2233919078.
Tue Aug 03 11:48:54 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Aug 03 11:48:54 2004
alter database open
Tue Aug 03 11:48:56 2004
Thread 1 opened at log sequence 240
Current log# 3 seq# 240 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Successful open of redo thread 1.
Tue Aug 03 11:48:56 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Aug 03 11:49:02 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Mon Aug 09 10:00:02 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Mon Aug 09 10:00:06 2004
alter database mount exclusive
Mon Aug 09 10:00:11 2004
Successful mount of redo thread 1, with mount id 2234408683.
Mon Aug 09 10:00:11 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Aug 09 10:00:11 2004
alter database open
Beginning crash recovery of 1 threads
Mon Aug 09 10:00:12 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 240 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO03.LOG
Mon Aug 09 10:00:12 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Mon Aug 09 10:00:13 2004
Thread 1 advanced to log sequence 241
Thread 1 opened at log sequence 241
Current log# 1 seq# 241 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Successful open of redo thread 1.
Mon Aug 09 10:00:14 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Aug 09 10:00:18 2004
Completed: alter database open
Mon Aug 09 10:00:48 2004
Thread 1 advanced to log sequence 242
Current log# 2 seq# 242 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 243
Current log# 3 seq# 243 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 244
Current log# 1 seq# 244 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 245
Current log# 2 seq# 245 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Mon Aug 09 10:01:53 2004
Thread 1 advanced to log sequence 246
Current log# 3 seq# 246 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 247
Current log# 1 seq# 247 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Aug 10 16:11:43 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Tue Aug 10 16:13:37 2004
Shutting down instance (immediate)
License high water mark = 1
Tue Aug 10 16:13:37 2004
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Aug 10 16:14:19 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Tue Aug 10 16:14:21 2004
alter database mount exclusive
Tue Aug 10 16:14:26 2004
Successful mount of redo thread 1, with mount id 2234499874.
Tue Aug 10 16:14:26 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Aug 10 16:14:26 2004
alter database open
Beginning crash recovery of 1 threads
Tue Aug 10 16:14:27 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 247 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO01.LOG
Tue Aug 10 16:14:27 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Tue Aug 10 16:14:28 2004
Thread 1 advanced to log sequence 248
Thread 1 opened at log sequence 248
Current log# 2 seq# 248 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Successful open of redo thread 1.
Tue Aug 10 16:14:29 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Aug 10 16:14:32 2004
Completed: alter database open
Tue Aug 10 16:15:35 2004
Thread 1 advanced to log sequence 249
Current log# 3 seq# 249 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 250
Current log# 1 seq# 250 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 251
Current log# 2 seq# 251 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 252
Current log# 3 seq# 252 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 253
Current log# 1 seq# 253 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Aug 10 16:25:29 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Tue Aug 10 16:25:35 2004
alter database mount exclusive
Tue Aug 10 16:25:39 2004
Successful mount of redo thread 1, with mount id 2234494147.
Tue Aug 10 16:25:39 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Aug 10 16:25:40 2004
alter database open
Beginning crash recovery of 1 threads
Tue Aug 10 16:25:41 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 252 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 1 Seq 253 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO01.LOG
Tue Aug 10 16:25:42 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 122 data blocks read, 73 data blocks written, 1832 redo blocks read
Crash recovery completed successfully
Tue Aug 10 16:25:43 2004
Thread 1 advanced to log sequence 254
Thread 1 opened at log sequence 254
Current log# 2 seq# 254 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Successful open of redo thread 1.
Tue Aug 10 16:25:43 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Aug 10 16:25:46 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Aug 10 16:29:57 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Tue Aug 10 16:29:59 2004
alter database mount exclusive
Tue Aug 10 16:30:04 2004
Successful mount of redo thread 1, with mount id 2234509004.
Tue Aug 10 16:30:04 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Aug 10 16:30:04 2004
alter database open
Beginning crash recovery of 1 threads
Tue Aug 10 16:30:04 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 254 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO02.LOG
Tue Aug 10 16:30:05 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 11 data blocks read, 11 data blocks written, 25 redo blocks read
Crash recovery completed successfully
Tue Aug 10 16:30:06 2004
Thread 1 advanced to log sequence 255
Thread 1 opened at log sequence 255
Current log# 3 seq# 255 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Successful open of redo thread 1.
Tue Aug 10 16:30:06 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Aug 10 16:30:08 2004
Completed: alter database open
Shutting down instance (immediate)
License high water mark = 1
Tue Aug 10 16:32:28 2004
alter database close normal
Tue Aug 10 16:32:28 2004
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Aug 10 16:32:29 2004
Thread 1 closed at log sequence 255
Tue Aug 10 16:32:29 2004
Completed: alter database close normal
Tue Aug 10 16:32:29 2004
alter database dismount
Completed: alter database dismount
archiving is disabled
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Aug 10 16:37:07 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Tue Aug 10 16:44:26 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Tue Aug 10 16:44:28 2004
alter database mount exclusive
Tue Aug 10 16:44:33 2004
Successful mount of redo thread 1, with mount id 2234519088.
Tue Aug 10 16:44:33 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Aug 10 16:44:33 2004
alter database open
Tue Aug 10 16:44:34 2004
Thread 1 opened at log sequence 255
Current log# 3 seq# 255 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Successful open of redo thread 1.
Tue Aug 10 16:44:34 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Aug 10 16:44:38 2004
Completed: alter database open
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Wed Aug 11 12:28:39 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Wed Aug 11 12:28:44 2004
alter database mount exclusive
Wed Aug 11 12:28:49 2004
Successful mount of redo thread 1, with mount id 2234582721.
Wed Aug 11 12:28:49 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Aug 11 12:28:49 2004
alter database open
Beginning crash recovery of 1 threads
Wed Aug 11 12:28:50 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 255 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO03.LOG
Wed Aug 11 12:28:51 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Wed Aug 11 12:28:51 2004
Thread 1 advanced to log sequence 256
Thread 1 opened at log sequence 256
Current log# 1 seq# 256 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Successful open of redo thread 1.
Wed Aug 11 12:28:52 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Aug 11 12:28:55 2004
Completed: alter database open
Wed Aug 11 14:04:37 2004
Thread 1 advanced to log sequence 257
Current log# 2 seq# 257 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Wed Aug 11 14:06:33 2004
Thread 1 advanced to log sequence 258
Current log# 3 seq# 258 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 259
Current log# 1 seq# 259 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 cannot allocate new log, sequence 260
Checkpoint not complete
Current log# 1 seq# 259 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 260
Current log# 2 seq# 260 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 261
Current log# 3 seq# 261 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Thread 1 advanced to log sequence 262
Current log# 1 seq# 262 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Thread 1 advanced to log sequence 263
Current log# 2 seq# 263 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thread 1 advanced to log sequence 264
Current log# 3 seq# 264 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
Dump file C:OracleadminaimsbdumpaimsALRT.LOG
Thu Aug 12 08:50:30 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 171895808
large_pool_size = 614400
java_pool_size = 32768
control_files = C:Oracleoradataaimscontrol01.ctl, C:Oracleoradataaimscontrol02.ctl, C:Oracleoradataaimscontrol03.ctl
db_block_buffers = 62950
db_block_size = 8192
compatible = 8.0.5
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = aims
service_names = aims
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = aims
open_cursors = 100
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = C:Oracleadminaimsbdump
user_dump_dest = C:Oracleadminaimsudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Thu Aug 12 08:50:35 2004
alter database mount exclusive
Thu Aug 12 08:50:40 2004
Successful mount of redo thread 1, with mount id 2234645792.
Thu Aug 12 08:50:40 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Aug 12 08:50:40 2004
alter database open
Beginning crash recovery of 1 threads
Thu Aug 12 08:50:41 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 264 Reading mem 0
Mem# 0 errs 0: C:ORACLEORADATAAIMSREDO03.LOG
Thu Aug 12 08:50:42 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Aug 12 08:50:42 2004
Thread 1 advanced to log sequence 265
Thread 1 opened at log sequence 265
Current log# 1 seq# 265 mem# 0: C:ORACLEORADATAAIMSREDO01.LOG
Successful open of redo thread 1.
Thu Aug 12 08:50:43 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Aug 12 08:50:46 2004
Completed: alter database open
Thu Aug 12 09:06:37 2004
Thread 1 advanced to log sequence 266
Current log# 2 seq# 266 mem# 0: C:ORACLEORADATAAIMSREDO02.LOG
Thu Aug 12 10:45:04 2004
Thread 1 advanced to log sequence 267
Current log# 3 seq# 267 mem# 0: C:ORACLEORADATAAIMSREDO03.LOG
============================================
Please see my prev logging on to oracle 8i problem
|
|
|
|
| Re: logging on to oracle8i [message #62759 is a reply to message #62758] |
Wed, 11 August 2004 23:27  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Well everything seems Ok from ur alert.log, your DB is up and running properly. So whts the problem?
In your previous post i said that first restart the machine and after that if will unable to connect to the DB then check the service if it is not started then check the alert.log to get the exact status of the DB.
Daljit Singh
|
|
|
|
| Re: logging on to oracle8i [message #62761 is a reply to message #62759] |
Thu, 12 August 2004 01:36 |
dhananjaya R
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
hi daljit,
the problem is, whenever i restart my machine, i have stop the ORACLE.exe process in the task manager and start the service OracleAims in the control panel/services. when i do this i am able to login to oracle8i with service name "aims". but if i dont do it the service "aims" will be in starting state forever.
-dan
|
|
|
|
| Re: logging on to oracle8i [message #62762 is a reply to message #62761] |
Thu, 12 August 2004 03:01 |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
I am also saying the same thing, after restarting ur machine if you find your aims service in starting stage at that point just check the alert.log (before restarting it) to check where it is hanging and what it stage of the database.
Daljit Singh
|
|
|
|
Goto Forum:
Current Time: Fri Sep 27 08:33:31 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
