I have been working on this for more than 5 hours now(Please don't tell me this is not a supported Oracle version I know that), this is PROD database for one of our huge clients.
The database is mounted but it cannot open it when I issue 'ALTER DATABASE OPEN, I get
ORA-03113 end-of-communcation. Becuase is windows I already rebooted and still get this. See alert log, (DB in noarchivelog mode, no offline)
Thu Dec 24 05:57:48 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 05:57:50 2015
ALTER DATABASE MOUNT
Thu Dec 24 05:57:55 2015
Successful mount of redo thread 1, with mount id 3338330783.
Thu Dec 24 05:57:55 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
Thu Dec 24 05:58:40 2015
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Thu Dec 24 05:58:40 2015
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
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
Thu Dec 24 06:15:18 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 06:15:21 2015
ALTER DATABASE MOUNT
Thu Dec 24 06:15:25 2015
Successful mount of redo thread 1, with mount id 3338372537.
Thu Dec 24 06:15:25 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Dec 24 06:15:25 2015
ALTER DATABASE OPEN
Thu Dec 24 06:15:25 2015
Beginning crash recovery of 1 threads
Thu Dec 24 06:15:25 2015
Started first pass scan
Thu Dec 24 06:15:26 2015
Completed first pass scan
2 redo blocks read, 0 data blocks need recovery
Thu Dec 24 06:15:26 2015
Started recovery at
Thread 1: logseq 19007, block 2, scn 0.1257866170
Recovery of Online Redo Log: Thread 1 Group 5 Seq 19007 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO05.LOG
Thu Dec 24 06:15:26 2015
Ended recovery at
Thread 1: logseq 19007, block 4, scn 0.1257886204
0 data blocks read, 0 data blocks written, 2 redo blocks read
Crash recovery completed successfully
Thu Dec 24 06:15:26 2015
Thread 1 advanced to log sequence 19008
Thread 1 opened at log sequence 19008
Current log# 4 seq# 19008 mem# 0: D:\ORADATA\MTMS\REDO04.LOG
Successful open of redo thread 1.
Thu Dec 24 06:15:26 2015
SMON: enabling cache recovery
Thu Dec 24 06:16:23 2015
DBW0: terminating instance due to error 472
Instance terminated by DBW0, pid = 6084
Thu Dec 24 06:19:01 2015
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 = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 06:19:03 2015
ALTER DATABASE MOUNT
Thu Dec 24 06:19:08 2015
Successful mount of redo thread 1, with mount id 3338372759.
Thu Dec 24 06:19:08 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Dec 24 06:19:08 2015
ALTER DATABASE OPEN
Thu Dec 24 06:19:08 2015
Beginning crash recovery of 1 threads
Thu Dec 24 06:19:08 2015
Started first pass scan
Thu Dec 24 06:19:08 2015
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Thu Dec 24 06:19:08 2015
Started recovery at
Thread 1: logseq 19008, block 4, scn 0.1257886240
Recovery of Online Redo Log: Thread 1 Group 4 Seq 19008 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO04.LOG
Thu Dec 24 06:19:08 2015
Ended recovery at
Thread 1: logseq 19008, block 4, scn 0.1257906241
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Dec 24 06:19:08 2015
Thread 1 advanced to log sequence 19009
Thread 1 opened at log sequence 19009
Current log# 3 seq# 19009 mem# 0: D:\ORADATA\MTMS\REDO03.LOG
Successful open of redo thread 1.
Thu Dec 24 06:19:08 2015
SMON: enabling cache recovery
Thu Dec 24 06:20:06 2015
DBW0: terminating instance due to error 472
Instance terminated by DBW0, pid = 4448
Thu Dec 24 09:35:30 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 09:35:33 2015
ALTER DATABASE MOUNT
Thu Dec 24 09:35:38 2015
Successful mount of redo thread 1, with mount id 3338426021.
Thu Dec 24 09:35:38 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Dec 24 10:29:00 2015
alter database open
Thu Dec 24 10:29:00 2015
Beginning crash recovery of 1 threads
Thu Dec 24 10:29:00 2015
Started first pass scan
Thu Dec 24 10:29:00 2015
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Thu Dec 24 10:29:00 2015
Started recovery at
Thread 1: logseq 19009, block 4, scn 0.1257906277
Recovery of Online Redo Log: Thread 1 Group 3 Seq 19009 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO03.LOG
Thu Dec 24 10:29:00 2015
Ended recovery at
Thread 1: logseq 19009, block 4, scn 0.1257926278
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Dec 24 10:29:01 2015
Thread 1 advanced to log sequence 19010
Thread 1 opened at log sequence 19010
Current log# 5 seq# 19010 mem# 0: D:\ORADATA\MTMS\REDO05.LOG
Successful open of redo thread 1.
Thu Dec 24 10:29:01 2015
SMON: enabling cache recovery
Thu Dec 24 10:29:19 2015
CKPT: terminating instance due to error 472
Instance terminated by CKPT, pid = 2256
Thu Dec 24 10:33:42 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 10:33:52 2015
alter database mount
Thu Dec 24 10:33:56 2015
Successful mount of redo thread 1, with mount id 3338389328.
Thu Dec 24 10:33:56 2015
Database mounted in Exclusive Mode.
Completed: alter database mount
Thu Dec 24 10:34:01 2015
ALTER DATABASE RECOVER database
Media Recovery Start
Starting datafile 1 recovery in thread 1 sequence 19010
Datafile 1: 'D:\ORADATA\MTMS\SYSTEM01.DBF'
Starting datafile 3 recovery in thread 1 sequence 19010
Datafile 3: 'D:\ORADATA\MTMS\INDX01.DBF'
Starting datafile 4 recovery in thread 1 sequence 19010
Datafile 4: 'D:\ORADATA\MTMS\TOOLS01.DBF'
Starting datafile 5 recovery in thread 1 sequence 19010
Datafile 5: 'D:\ORADATA\MTMS\USERS01.DBF'
Starting datafile 6 recovery in thread 1 sequence 19010
Datafile 6: 'D:\ORADATA\MTMS\MTMSTAB.ORA'
Starting datafile 7 recovery in thread 1 sequence 19010
Datafile 7: 'D:\ORADATA\MTMS\MTMSIDX.ORA'
Starting datafile 8 recovery in thread 1 sequence 19010
Datafile 8: 'D:\ORACLE\ORA92\DATABASE\FILE_PATH'
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 5 Seq 19010 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO05.LOG
Media Recovery Complete
Completed: ALTER DATABASE RECOVER database
Thu Dec 24 10:35:11 2015
alter database open
Thu Dec 24 10:35:11 2015
Beginning crash recovery of 1 threads
Thu Dec 24 10:35:11 2015
Started first pass scan
Thu Dec 24 10:35:11 2015
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Thu Dec 24 10:35:11 2015
Started recovery at
Thread 1: logseq 19010, block 4, scn 0.1257926315
Recovery of Online Redo Log: Thread 1 Group 5 Seq 19010 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO05.LOG
Thu Dec 24 10:35:11 2015
Ended recovery at
Thread 1: logseq 19010, block 4, scn 0.1257946316
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Dec 24 10:35:11 2015
Thread 1 advanced to log sequence 19011
Thread 1 opened at log sequence 19011
Current log# 4 seq# 19011 mem# 0: D:\ORADATA\MTMS\REDO04.LOG
Successful open of redo thread 1.
Thu Dec 24 10:35:12 2015
SMON: enabling cache recovery
Thu Dec 24 10:35:48 2015
DBW0: terminating instance due to error 472
Instance terminated by DBW0, pid = 5332
Thu Dec 24 10:41:32 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 10:41:35 2015
ALTER DATABASE MOUNT
Thu Dec 24 10:41:39 2015
Successful mount of redo thread 1, with mount id 3338446879.
Thu Dec 24 10:41:39 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Dec 24 10:42:39 2015
alter database open
Thu Dec 24 10:42:40 2015
Beginning crash recovery of 1 threads
Thu Dec 24 10:42:40 2015
Started first pass scan
Thu Dec 24 10:42:40 2015
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Thu Dec 24 10:42:40 2015
Started recovery at
Thread 1: logseq 19011, block 4, scn 0.1257946352
Recovery of Online Redo Log: Thread 1 Group 4 Seq 19011 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO04.LOG
Thu Dec 24 10:42:40 2015
Ended recovery at
Thread 1: logseq 19011, block 4, scn 0.1257966353
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Dec 24 10:42:40 2015
Thread 1 advanced to log sequence 19012
Thread 1 opened at log sequence 19012
Current log# 3 seq# 19012 mem# 0: D:\ORADATA\MTMS\REDO03.LOG
Successful open of redo thread 1.
Thu Dec 24 10:42:40 2015
SMON: enabling cache recovery
Thu Dec 24 10:43:38 2015
DBW0: terminating instance due to error 472
Instance terminated by DBW0, pid = 5724
Thu Dec 24 12:11:41 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 12:11:44 2015
ALTER DATABASE MOUNT
Thu Dec 24 12:11:48 2015
Successful mount of redo thread 1, with mount id 3338441024.
Thu Dec 24 12:11:48 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Dec 24 12:12:36 2015
ALTER DATABASE CLEAR LOGFILE group 3
ORA-1624 signalled during: ALTER DATABASE CLEAR LOGFILE group 3...
Thu Dec 24 12:12:48 2015
ALTER DATABASE CLEAR LOGFILE group 4
Clearing online log 4 of thread 1 sequence number 19011
Completed: ALTER DATABASE CLEAR LOGFILE group 4
Thu Dec 24 12:12:53 2015
ALTER DATABASE CLEAR LOGFILE group 5
Clearing online log 5 of thread 1 sequence number 19010
Completed: ALTER DATABASE CLEAR LOGFILE group 5
Thu Dec 24 12:13:12 2015
ALTER DATABASE RECOVER database until cancel
Media Recovery Start
Starting datafile 1 recovery in thread 1 sequence 19012
Datafile 1: 'D:\ORADATA\MTMS\SYSTEM01.DBF'
Starting datafile 3 recovery in thread 1 sequence 19012
Datafile 3: 'D:\ORADATA\MTMS\INDX01.DBF'
Starting datafile 4 recovery in thread 1 sequence 19012
Datafile 4: 'D:\ORADATA\MTMS\TOOLS01.DBF'
Starting datafile 5 recovery in thread 1 sequence 19012
Datafile 5: 'D:\ORADATA\MTMS\USERS01.DBF'
Starting datafile 6 recovery in thread 1 sequence 19012
Datafile 6: 'D:\ORADATA\MTMS\MTMSTAB.ORA'
Starting datafile 7 recovery in thread 1 sequence 19012
Datafile 7: 'D:\ORADATA\MTMS\MTMSIDX.ORA'
Starting datafile 8 recovery in thread 1 sequence 19012
Datafile 8: 'D:\ORACLE\ORA92\DATABASE\FILE_PATH'
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER database until cancel ...
Thu Dec 24 12:13:25 2015
ALTER DATABASE RECOVER CANCEL
ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ...
Thu Dec 24 12:13:26 2015
ALTER DATABASE RECOVER CANCEL
ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...
Thu Dec 24 12:13:53 2015
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Thu Dec 24 12:16:02 2015
ALTER DATABASE RECOVER datafile 'D:\ORADATA\MTMS\SYSTEM01.DBF'
Media Recovery Datafile: 'D:\ORADATA\MTMS\SYSTEM01.DBF'
Media Recovery Start
Starting datafile 1 recovery in thread 1 sequence 19012
Datafile 1: 'D:\ORADATA\MTMS\SYSTEM01.DBF'
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 3 Seq 19012 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO03.LOG
Media Recovery Complete
Completed: ALTER DATABASE RECOVER datafile 'D:\ORADATA\MTMS\
Thu Dec 24 12:16:15 2015
alter database open resetlogs
ORA-1139 signalled during: alter database open resetlogs...
Thu Dec 24 12:16:27 2015
alter database open
Thu Dec 24 12:16:27 2015
Beginning crash recovery of 1 threads
Thu Dec 24 12:16:27 2015
Started first pass scan
Thu Dec 24 12:16:27 2015
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Thu Dec 24 12:16:27 2015
Started recovery at
Thread 1: logseq 19012, block 4, scn 0.1257966389
Recovery of Online Redo Log: Thread 1 Group 3 Seq 19012 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO03.LOG
Thu Dec 24 12:16:27 2015
Ended recovery at
Thread 1: logseq 19012, block 4, scn 0.1257986390
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Dec 24 12:16:28 2015
Thread 1 advanced to log sequence 19013
Thread 1 opened at log sequence 19013
Current log# 4 seq# 19013 mem# 0: D:\ORADATA\MTMS\REDO04.LOG
Successful open of redo thread 1.
Thu Dec 24 12:16:28 2015
SMON: enabling cache recovery
Thu Dec 24 12:16:52 2015
LGWR: terminating instance due to error 472
Instance terminated by LGWR, pid = 4208
Thu Dec 24 12:18:02 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 12:18:42 2015
alter database mount
Thu Dec 24 12:18:46 2015
Successful mount of redo thread 1, with mount id 3338400226.
Thu Dec 24 12:18:46 2015
Database mounted in Exclusive Mode.
Completed: alter database mount
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
Thu Dec 24 12:21:51 2015
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Thu Dec 24 12:21:51 2015
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
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
Thu Dec 24 12:22:34 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 12:22:44 2015
alter database mount
Thu Dec 24 12:22:48 2015
Successful mount of redo thread 1, with mount id 3338444500.
Thu Dec 24 12:22:48 2015
Database mounted in Exclusive Mode.
Completed: alter database mount
Thu Dec 24 12:22:59 2015
ALTER DATABASE RECOVER database
Media Recovery Start
Starting datafile 1 recovery in thread 1 sequence 19013
Datafile 1: 'D:\ORADATA\MTMS\SYSTEM01.DBF'
Starting datafile 3 recovery in thread 1 sequence 19013
Datafile 3: 'D:\ORADATA\MTMS\INDX01.DBF'
Starting datafile 4 recovery in thread 1 sequence 19013
Datafile 4: 'D:\ORADATA\MTMS\TOOLS01.DBF'
Starting datafile 5 recovery in thread 1 sequence 19013
Datafile 5: 'D:\ORADATA\MTMS\USERS01.DBF'
Starting datafile 6 recovery in thread 1 sequence 19013
Datafile 6: 'D:\ORADATA\MTMS\MTMSTAB.ORA'
Starting datafile 7 recovery in thread 1 sequence 19013
Datafile 7: 'D:\ORADATA\MTMS\MTMSIDX.ORA'
Starting datafile 8 recovery in thread 1 sequence 19013
Datafile 8: 'D:\ORACLE\ORA92\DATABASE\FILE_PATH'
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 4 Seq 19013 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO04.LOG
Media Recovery Complete
Completed: ALTER DATABASE RECOVER database
Thu Dec 24 12:25:00 2015
alter database open resetlogs
ORA-1139 signalled during: alter database open resetlogs...
Thu Dec 24 12:31:54 2015
ALTER DATABASE CLEAR LOGFILE GROUP 3
Clearing online log 3 of thread 1 sequence number 19012
Completed: ALTER DATABASE CLEAR LOGFILE GROUP 3
Thu Dec 24 12:34:51 2015
ALTER DATABASE RECOVER DATABASE UNTIL CANCEL
Media Recovery Start
Media Recovery Not Required
ORA-1547 signalled during: ALTER DATABASE RECOVER DATABASE UNTIL CANCEL ...
Thu Dec 24 12:39:58 2015
ALTER DATABASE RECOVER database
Media Recovery Start
Media Recovery failed with error 264
ORA-283 signalled during: ALTER DATABASE RECOVER database ...
Thu Dec 24 12:40:28 2015
ALTER DATABASE RECOVER datafile 'D:\ORADATA\MTMS\SYSTEM01.DBF'
Media Recovery Datafile: 'D:\ORADATA\MTMS\SYSTEM01.DBF'
Media Recovery Start
Media Recovery failed with error 264
ORA-283 signalled during: ALTER DATABASE RECOVER datafile 'D:\ORADATA\MTMS\...
Thu Dec 24 12:40:40 2015
alter database open resetlogs
ORA-1152 signalled during: alter database open resetlogs...
Thu Dec 24 12:44:32 2015
ALTER DATABASE RECOVER database
Media Recovery Start
Media Recovery failed with error 264
ORA-283 signalled during: ALTER DATABASE RECOVER database ...
Thu Dec 24 12:50:38 2015
ALTER DATABASE RECOVER database
Media Recovery Start
Media Recovery failed with error 264
ORA-283 signalled during: ALTER DATABASE RECOVER database ...
Thu Dec 24 13:01:32 2015
alter database open
ORA-1589 signalled during: alter database open...
Thu Dec 24 13:01:42 2015
alter database open resetlogs
ORA-1152 signalled during: alter database open resetlogs...
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
Thu Dec 24 13:02:14 2015
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Thu Dec 24 13:02:14 2015
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
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
Thu Dec 24 13:02:23 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 13:02:26 2015
ALTER DATABASE MOUNT
Thu Dec 24 13:02:30 2015
Successful mount of redo thread 1, with mount id 3338387490.
Thu Dec 24 13:02:30 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Dec 24 13:02:30 2015
ALTER DATABASE OPEN
ORA-1589 signalled during: ALTER DATABASE OPEN...
Thu Dec 24 13:05:12 2015
alter database open noresetlogs
Thu Dec 24 13:05:12 2015
Beginning crash recovery of 1 threads
Thu Dec 24 13:05:12 2015
Started first pass scan
Thu Dec 24 13:05:12 2015
Completed first pass scan
2 redo blocks read, 0 data blocks need recovery
Thu Dec 24 13:05:12 2015
Started recovery at
Thread 1: logseq 19013, block 2, scn 0.1257986392
Recovery of Online Redo Log: Thread 1 Group 4 Seq 19013 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO04.LOG
Thu Dec 24 13:05:12 2015
Ended recovery at
Thread 1: logseq 19013, block 4, scn 0.1258006426
0 data blocks read, 0 data blocks written, 2 redo blocks read
Crash recovery completed successfully
Thu Dec 24 13:05:13 2015
Thread 1 advanced to log sequence 19014
Thread 1 opened at log sequence 19014
Current log# 3 seq# 19014 mem# 0: D:\ORADATA\MTMS\REDO03.LOG
Successful open of redo thread 1.
Thu Dec 24 13:05:13 2015
SMON: enabling cache recovery
Thu Dec 24 13:05:31 2015
DBW0: terminating instance due to error 472
Instance terminated by DBW0, pid = 5380
Thu Dec 24 13:06:16 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 13:06:19 2015
ALTER DATABASE MOUNT
Thu Dec 24 13:06:23 2015
Successful mount of redo thread 1, with mount id 3338411531.
Thu Dec 24 13:06:23 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Dec 24 13:07:46 2015
ALTER DATABASE RECOVER database
Media Recovery Start
Starting datafile 1 recovery in thread 1 sequence 19014
Datafile 1: 'D:\ORADATA\MTMS\SYSTEM01.DBF'
Starting datafile 3 recovery in thread 1 sequence 19014
Datafile 3: 'D:\ORADATA\MTMS\INDX01.DBF'
Starting datafile 4 recovery in thread 1 sequence 19014
Datafile 4: 'D:\ORADATA\MTMS\TOOLS01.DBF'
Starting datafile 5 recovery in thread 1 sequence 19014
Datafile 5: 'D:\ORADATA\MTMS\USERS01.DBF'
Starting datafile 6 recovery in thread 1 sequence 19014
Datafile 6: 'D:\ORADATA\MTMS\MTMSTAB.ORA'
Starting datafile 7 recovery in thread 1 sequence 19014
Datafile 7: 'D:\ORADATA\MTMS\MTMSIDX.ORA'
Starting datafile 8 recovery in thread 1 sequence 19014
Datafile 8: 'D:\ORACLE\ORA92\DATABASE\FILE_PATH'
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 3 Seq 19014 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO03.LOG
Media Recovery Complete
Completed: ALTER DATABASE RECOVER database
Thu Dec 24 13:07:49 2015
ALTER DATABASE RECOVER database
Media Recovery Start
Media Recovery failed with error 264
ORA-283 signalled during: ALTER DATABASE RECOVER database ...
Thu Dec 24 13:07:55 2015
ALTER DATABASE RECOVER database
Media Recovery Start
Media Recovery failed with error 264
ORA-283 signalled during: ALTER DATABASE RECOVER database ...
Thu Dec 24 14:28:42 2015
/* OracleOEM */ ALTER DATABASE OPEN
Thu Dec 24 14:28:42 2015
Beginning crash recovery of 1 threads
Thu Dec 24 14:28:42 2015
Started first pass scan
Thu Dec 24 14:28:42 2015
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Thu Dec 24 14:28:42 2015
Started recovery at
Thread 1: logseq 19014, block 4, scn 0.1258006463
Recovery of Online Redo Log: Thread 1 Group 3 Seq 19014 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO03.LOG
Thu Dec 24 14:28:42 2015
Ended recovery at
Thread 1: logseq 19014, block 4, scn 0.1258026464
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Dec 24 14:28:43 2015
Thread 1 advanced to log sequence 19015
Thread 1 opened at log sequence 19015
Current log# 5 seq# 19015 mem# 0: D:\ORADATA\MTMS\REDO05.LOG
Successful open of redo thread 1.
Thu Dec 24 14:28:43 2015
SMON: enabling cache recovery
Thu Dec 24 14:29:18 2015
RECO: terminating instance due to error 472
Instance terminated by RECO, pid = 3520
Thu Dec 24 14:34:48 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Thu Dec 24 14:34:51 2015
ALTER DATABASE MOUNT
Thu Dec 24 14:34:56 2015
Successful mount of redo thread 1, with mount id 3338392267.
Thu Dec 24 14:34:56 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Dec 24 14:39:11 2015
ALTER DATABASE RECOVER database
Media Recovery Start
Starting datafile 1 recovery in thread 1 sequence 19015
Datafile 1: 'D:\ORADATA\MTMS\SYSTEM01.DBF'
Starting datafile 3 recovery in thread 1 sequence 19015
Datafile 3: 'D:\ORADATA\MTMS\INDX01.DBF'
Starting datafile 4 recovery in thread 1 sequence 19015
Datafile 4: 'D:\ORADATA\MTMS\TOOLS01.DBF'
Starting datafile 5 recovery in thread 1 sequence 19015
Datafile 5: 'D:\ORADATA\MTMS\USERS01.DBF'
Starting datafile 6 recovery in thread 1 sequence 19015
Datafile 6: 'D:\ORADATA\MTMS\MTMSTAB.ORA'
Starting datafile 7 recovery in thread 1 sequence 19015
Datafile 7: 'D:\ORADATA\MTMS\MTMSIDX.ORA'
Starting datafile 8 recovery in thread 1 sequence 19015
Datafile 8: 'D:\ORACLE\ORA92\DATABASE\FILE_PATH'
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 5 Seq 19015 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO05.LOG
Media Recovery Complete
Completed: ALTER DATABASE RECOVER database
Thu Dec 24 14:42:08 2015
alter database clear logfile group 3
Clearing online log 3 of thread 1 sequence number 19014
Completed: alter database clear logfile group 3
Thu Dec 24 14:42:14 2015
alter database clear logfile group 4
Clearing online log 4 of thread 1 sequence number 19013
Completed: alter database clear logfile group 4
Thu Dec 24 14:43:53 2015
alter database backup controlfile to 'D:\oracle\controlf.f'
Completed: alter database backup controlfile to 'D:\oracle\co
Thu Dec 24 14:46:04 2015
ALTER DATABASE RECOVER DATABASE UNTIL CANCEL
Media Recovery Start
Media Recovery Not Required
ORA-1547 signalled during: ALTER DATABASE RECOVER DATABASE UNTIL CANCEL ...
Thu Dec 24 14:49:22 2015
alter database open resetlogs
ORA-1152 signalled during: alter database open resetlogs...
Thu Dec 24 16:44:33 2015
Starting ORACLE instance (normal)
Fri Dec 25 17:43:23 2015
/* OracleOEM */ ALTER DATABASE OPEN NORESETLOGS
Fri Dec 25 17:43:24 2015
Beginning crash recovery of 1 threads
Fri Dec 25 17:43:24 2015
Started first pass scan
Fri Dec 25 17:43:24 2015
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Fri Dec 25 17:43:24 2015
Started recovery at
Thread 1: logseq 19015, block 4, scn 0.1258026501
Recovery of Online Redo Log: Thread 1 Group 5 Seq 19015 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO05.LOG
Fri Dec 25 17:43:24 2015
Ended recovery at
Thread 1: logseq 19015, block 4, scn 0.1258046502
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Fri Dec 25 17:43:24 2015
Thread 1 advanced to log sequence 19016
Thread 1 opened at log sequence 19016
Current log# 3 seq# 19016 mem# 0: D:\ORADATA\MTMS\REDO03.LOG
Successful open of redo thread 1.
Fri Dec 25 17:43:25 2015
SMON: enabling cache recovery
Fri Dec 25 17:43:56 2015
CKPT: terminating instance due to error 472
Fri Dec 25 17:44:02 2015
Starting ORACLE instance (normal)
Fri Dec 25 17:44:02 2015
Instance terminated by CKPT, pid = 1820
Fri Dec 25 17:44:33 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Fri Dec 25 17:44:36 2015
/* OracleOEM */ ALTER DATABASE MOUNT
Fri Dec 25 17:44:40 2015
Successful mount of redo thread 1, with mount id 3338493124.
Fri Dec 25 17:44:40 2015
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Fri Dec 25 17:44:40 2015
/* OracleOEM */ ALTER DATABASE OPEN
Fri Dec 25 17:44:40 2015
Beginning crash recovery of 1 threads
Fri Dec 25 17:44:40 2015
Started first pass scan
Fri Dec 25 17:44:40 2015
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Fri Dec 25 17:44:40 2015
Started recovery at
Thread 1: logseq 19016, block 4, scn 0.1258046539
Recovery of Online Redo Log: Thread 1 Group 3 Seq 19016 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO03.LOG
Fri Dec 25 17:44:40 2015
Ended recovery at
Thread 1: logseq 19016, block 4, scn 0.1258066540
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Fri Dec 25 17:44:41 2015
Thread 1 advanced to log sequence 19017
Thread 1 opened at log sequence 19017
Current log# 4 seq# 19017 mem# 0: D:\ORADATA\MTMS\REDO04.LOG
Successful open of redo thread 1.
Fri Dec 25 17:44:41 2015
SMON: enabling cache recovery
Fri Dec 25 17:45:38 2015
DBW0: terminating instance due to error 472
Instance terminated by DBW0, pid = 4348
Fri Dec 25 17:53:04 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle\admin\mtms\cdump
sort_area_size = 524288
db_name = mtms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 205520896
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
Fri Dec 25 17:53:07 2015
/* OracleOEM */ ALTER DATABASE MOUNT
Fri Dec 25 17:53:11 2015
Successful mount of redo thread 1, with mount id 3338504387.
Fri Dec 25 17:53:11 2015
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Fri Dec 25 17:53:11 2015
/* OracleOEM */ ALTER DATABASE OPEN
Fri Dec 25 17:53:11 2015
Beginning crash recovery of 1 threads
Fri Dec 25 17:53:11 2015
Started first pass scan
Fri Dec 25 17:53:11 2015
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Fri Dec 25 17:53:11 2015
Started recovery at
Thread 1: logseq 19017, block 4, scn 0.1258066576
Recovery of Online Redo Log: Thread 1 Group 4 Seq 19017 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\MTMS\REDO04.LOG
Fri Dec 25 17:53:11 2015
Ended recovery at
Thread 1: logseq 19017, block 4, scn 0.1258086577
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Fri Dec 25 17:53:12 2015
Thread 1 advanced to log sequence 19018
Thread 1 opened at log sequence 19018
Current log# 5 seq# 19018 mem# 0: D:\ORADATA\MTMS\REDO05.LOG
Successful open of redo thread 1.
Fri Dec 25 17:53:12 2015
SMON: enabling cache recovery
Fri Dec 25 17:54:09 2015
DBW0: terminating instance due to error 472
Instance terminated by DBW0, pid = 5264
Sun Dec 27 12:42:15 2015
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
event = 10046 trace name context forever, level 12:10015 trace name context forever, level 1:10228 trace name context forever, level 1
shared_pool_size = 209715200
large_pool_size = 8388608
java_pool_size = 0
control_files = d:\oradata\mtms\control01.ctl, d:\oradata\mtms\control02.ctl, d:\oradata\mtms\control03.ctl
db_block_size = 4096
db_cache_size = 620756992
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS_2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = mtms
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\mtms\bdump
user_dump_dest = d:\oracle\admin\mtms\udump
core_dump_dest = d:\oracle