Most Recent Alert Log Entries |
![](AlertLOG_files/t.htm) |
Page Refreshed | ![](AlertLOG_files/t.htm) | 24-Jul-2007 20:42:16 | ![](AlertLOG_files/t.htm) |
|
This
shows the last 100,000 bytes of the alert log. The log is constantly
growing, so select the browser's Refresh button to see the most recent
log entries.![](AlertLOG_files/t.htm)
Number of Lines Displayed | ![](AlertLOG_files/t.htm) | 1,882 |
Fri Jul 20 23:37:11 2007
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:558M/1022M, PG:2118M/2461M, VA:1959M/2047M
Fri Jul 20 23:37:11 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_fi db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\oracle\base\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=PRODXDB)
job_queue_processes = 10
background_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\BDUMP
user_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\UDUMP
core_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\CDUMP
sort_area_size = 65536
db_name = PROD
open_cursors = 300
pga_aggregate_target = 25165824
Fri Jul 20 23:37:17 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
CKPT started with pid=6, OS id=224
MMACJQ0 started with pid=9, OS id=168
SMON started with pid=7, OS id=236
PMON started with pid=2, OS id=184
LGWR started with pid=5, OS id=192
RECO started with pid=8, OS id=1844
DBW0 started with pid=4, OS id=936
Fri Jul 20 23:37:25 2007
The input backup piece F:\ORACLE\BASE\HOME\ASSISTANTS\DBCA\TEMPLATES\SEED_DATABASE.DFB is in compressed format.
Full restore complete of datafile 4 to datafile copy F:\ORACLE\BASE\ORADATA\PROD\USERS01.DBF
checkpoint is 318841
Fri Jul 20 23:37:57 2007
Full restore complete of datafile 2 to datafile copy F:\ORACLE\BASE\ORADATA\PROD\UNDOTBS01.DBF
checkpoint is 318841
Fri Jul 20 23:40:37 2007
Full restore complete of datafile 3 to datafile copy F:\ORACLE\BASE\ORADATA\PROD\SYSAUX01.DBF
checkpoint is 318841
Fri Jul 20 23:42:42 2007
Full restore complete of datafile 1 to datafile copy F:\ORACLE\BASE\ORADATA\PROD\SYSTEM01.DBF
checkpoint is 318841
Fri Jul 20 23:42:43 2007
Create controlfile reuse set database "PROD"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFIMAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'F:\oracle\base\oradata\PROD\SYSTEM01.DBF',
'F:\oracle\base\oradata\PROD\UNDOTBS01.DBF',
'F:\oracle\base\oradata\PROD\SYSAUX01.DBF',
'F:\oracle\base\oradata\PROD\USERS01.DBF'
LOGFILE GROUP 1 ('F:\oracle\base\oradata\PROD\redo01.log') SIZE 10240K,
GROUP 2 ('F:\oracle\base\oradata\PROD\redo02.log') SIZE 10240K,
GROUP 3 ('F:\oracle\base\oradata\PROD\redo03.log') SIZE 10240K RESETLOGS
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Fri Jul 20 23:42:46 2007
Controlfile identified with block size 16384
Fri Jul 20 23:42:46 2007
Controlfile created with 174 blocks of size 16384 bytes
Fri Jul 20 23:42:47 2007
Setting recovery target incarnation to 1
Fri Jul 20 23:42:47 2007
Setting recovery target incarnation to 1
Fri Jul 20 23:42:4Successful mount of redo thread 1, with mount id 40318323
Fri Jul 20 23:42:49 2007
Completed: Create controlfile reuse set database "PROD"
MAXIN
Shutting down instance: further logons disabled
Fri Jul 20 23:42:49 2007
Stopping background process CJQ0
Fri Jul 20 23:42:49 2007
Shutting down instance (immediate)
License high water mark = 1
Fri Jul 20 23:42:49 2007
Stopping Job queue slave processes
Fri Jul 20 23:42:49 2007
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Jul 20 23:42:50 2007
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Jul 20 23:42:50 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shFri Jul 20 23:42:56 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = F:\ORACLE\BASE\ORADATA\PROD\CONTROL01.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL02.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_reco db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=PRODXDB)
background_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\BDUMP
user_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\UDUMP
core_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\CDUMP
sort_area_size = 65536
db_name = PROD
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=1352
MMAN started with pid=3, OS id=1808
DBW0 started with pid=4, OS id=1816
LGWR started with pid=5, OS id=1064
CKPT started with pid=6, OS id=2016
SMON started with pid=7, OS id=1180
RECO started with pid=8, OS id=288
Fri Jul 20 23:42:56 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri Jul 20 23:42:56 2007
CreateMAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'F:\oracle\base\oradata\PROD\SYSTEM01.DBF',
'F:\oracle\base\oradata\PROD\UNDOTBS01.DBF',
'F:\oracle\base\oradata\PROD\SYSAUX01.DBF',
'F:\oracle\base\oradata\PROD\USERS01.DBF'
LOGFILE GROUP 1 ('F:\oracle\base\oradata\PROD\redo01.log') SIZE 10240K,
GROUP 2 ('F:\oracle\base\oradata\PROD\redo02.log') SIZE 10240K,
GROUP 3 ('F:\oracle\base\oradata\PROD\redo03.log') SIZE 10240K RESETLOGS
Fri Jul 20 23:42:56 2007
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Fri Jul 20 23:42:59 2007
Controlfile identified with block size 16384
Fri Jul 20 23:42:59 2007
Controlfile created with 174 blocks of size 16384 bytes
Fri Jul 20 23:43:01 2007
Setting recovery target incarnation to 1
Fri Jul 20 23Setting recovery target incarnation to 1
Fri Jul 20 23:43:01 2007
Successful mount of redo thread 1, with mount id 40268928
Fri Jul 20 23:43:02 2007
Completed: Create controlfile reuse set database "PROD"
MAXIN
Fri Jul 20 23:43:02 2007
alter database "PROD" open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 318841
Fri Jul 20 23:43:02 2007
Errors in file f:\oracle\base\admin\prod\udump\prod_ora_408.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Fri Jul 20 23:43:06 2007
Errors in file f:\oracle\base\admin\prod\udump\prod_ora_408.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system ca
Fri Jul 20 23:43:10 2007
Errors in file f:\oracle\base\admin\prod\udump\prod_ora_408.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Fri Jul 20 23:43:15 2007
Setting recovery target incarnation to 2
Fri Jul 20 23:43:15 2007
Setting recovery target incarnation to 2
Fri Jul 20 23:43:15 2007
Flashback Database Disabled
Fri Jul 20 23:43:16 2007
Assigning activation ID 40268928 (0x2667480)
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Successful open of redo thread 1
Fri Jul 20 23:43:17 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jul 20 23:43:17 SMON: enabling cache recovery
Fri Jul 20 23:43:20 2007
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Fri Jul 20 23:43:22 2007
SMON: enabling tx recovery
Fri Jul 20 23:43:22 2007
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is US7ASCII
Fri Jul 20 23:43:22 2007
PuFri Jul 20 23:43:22 2007
All processes have switched to database character set
Fri Jul 20 23:43:23 2007
Threshold validation cannot be done before catproc is loaded.
Threshold validation cannot be done before catproc is loaded.
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
Fri Jul 20 23:43:28 2007
Starting background process QMNC
QMNC started with pid=12, OS id=2012
Fri Jul 20 23:43:32 2007
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Jul 20 23:43:33 2007
Starting background process MMNL
MMNLFri Jul 20 23:43:40 2007
Completed: alter database "PROD" open resetlogs
Fri Jul 20 23:43:40 2007
alter database rename global_name to "PROD"
Completed: alter database rename global_name to "PROD"
Fri Jul 20 23:43:41 2007
ALTER TABLESPACE TEMP ADD TEMPFILE 'F:\oracle\base\oradata\PROD\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'F:\oracle\base
Fri Jul 20 23:43:42 2007
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Fri Jul 20 23:43:42 2007
Stopping background process MMNL
Fri Jul 20 23:43:57 2007
Starting background process MMON
MMON started with pid=13, OS id=244
Fri Jul 20 23:43:57 2007
Starting background process MMNL
MMNL started with pid=15, OS id=280
Fri Jul 20 23:44:01 2007
The input backup piece F:\ORACLE\BASE\HOME\ASSISTANTS\DBCA\TEMPLATES\EXAMPLE01.DFB is in compressed format.
Fri Jul 20 23:44:03 2007
db_recovery_file_dest_size of 2048 MB is 0.00% used. Thiuser-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Jul 20 23:44:10 2007
Starting background process CJQ0
CJQ0 started with pid=11, OS id=1308
Fri Jul 20 23:45:14 2007
Full restore complete of datafile 5 to datafile copy F:\ORACLE\BASE\ORADATA\PROD\EXAMPLE01.DBF
checkpoint is 334812
Fri Jul 20 23:45:17 2007
Plug in tablespace EXAMPLE with datafile
'F:\ORACLE\BASE\ORADATA\PROD\EXAMPLE01.DBF'
Fri Jul 20 23:46:02 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 2
Current log# 1 seq# 2 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Fri Jul 20 23:46:24 2007
ALTER TABLESPACE example READ WRITE
Fri Jul 20 23:46:27 2007
Completed: ALTER TABLESPACE example READ WRITE
Fri Jul 20 23:50:36 2007
Stopping background process MMNL
Fri Jul 20 23:50:38 2007
Stopping background process MMON
Fri Jul 20 23:50:39 2007
StartinMMNL started with pid=13, OS id=744
Fri Jul 20 23:50:39 2007
alter database character set INTERNAL_CONVERT WE8MSWIN1252
Fri Jul 20 23:50:39 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 3
Current log# 2 seq# 3 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Fri Jul 20 23:50:59 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 4
Current log# 3 seq# 4 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Fri Jul 20 23:51:12 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 5
Current log# 1 seq# 5 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Fri Jul 20 23:51:47 2007
Updating character set in controlfile to WE8MSWIN1252
Synchronizing connection with database character set information
Fri Jul 20 23:51:48 2007
Published database character set on system events channel
Refreshing type attributes with new character set information
Fri Jul 20 23:51:50 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 6
CurrFri Jul 20 23:51:59 2007
Completed: alter database character set INTERNAL_CONVERT WE8M
Fri Jul 20 23:51:59 2007
alter database national character set INTERNAL_CONVERT AL16UTF16
Fri Jul 20 23:52:35 2007
Completed: alter database national character set INTERNAL_CON
Fri Jul 20 23:52:35 2007
Stopping background process MMNL
Fri Jul 20 23:52:35 2007
Starting background process MMON
MMON started with pid=13, OS id=876
Fri Jul 20 23:52:35 2007
Starting background process MMNL
MMNL started with pid=15, OS id=892
Fri Jul 20 23:52:51 2007
Starting background process EMN0
EMN0 started with pid=17, OS id=1588
Fri Jul 20 23:52:51 2007
Shutting down instance: further logons disabled
Fri Jul 20 23:52:52 2007
Stopping background process CJQ0
Fri Jul 20 23:52:52 2007
Stopping background process QMNC
Fri Jul 20 23:52:53 2007
Stopping background process MMNL
Fri Jul 20 23:52:53 2007
Stopping background process MMON
Fri Jul 20 23:52:54 2007
Shutting down instance (immediate)
License high water mark = 2
AlFri Jul 20 23:52:56 2007
ALTER DATABASE CLOSE NORMAL
Fri Jul 20 23:52:58 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 7
Current log# 3 seq# 7 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Fri Jul 20 23:52:58 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jul 20 23:52:59 2007
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 7
Successful close of redo thread 1
Fri Jul 20 23:52:59 2007
Completed: ALTER DATABASE CLOSE NORMAL
Fri Jul 20 23:52:59 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Jul 20 23:53:02 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSLICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = F:\ORACLE\BASE\ORADATA\PROD\CONTROL01.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL02.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\oracle\base\flash_recovery_area
db_recovery_file_dest_size undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=PRODXDB)
job_queue_processes = 10
background_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\BDUMP
user_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\UDUMP
core_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\CDUMP
sort_area_size = 65536
db_name = PROD
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=1592
MMAN started with pid=3, OS id=1160
DBW0 started with pid=4, OS id=320
LGWR started with pid=5, OS id=1524
CKPT started with pid=6, OS id=400
SMON started with pid=7, OS id=1248
RECO started with pid=8, OS id=1896
CJQ0 started with pid=9, OS id=1552
Fri Jul 20 23:53:02 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri JALTER DATABASE MOUNT
Fri Jul 20 23:53:02 2007
Controlfile identified with block size 16384
Fri Jul 20 23:53:07 2007
Setting recovery target incarnation to 2
Fri Jul 20 23:53:07 2007
Successful mount of redo thread 1, with mount id 40316382
Fri Jul 20 23:53:07 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jul 20 23:53:08 2007
ALTER DATABASE OPEN
Fri Jul 20 23:53:09 2007
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 7
Current log# 3 seq# 7 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Successful open of redo thread 1
Fri Jul 20 23:53:09 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jul 20 23:53:10 2007
SMON: enabling cache recovery
Fri Jul 20 23:53:11 2007
Successfully onlined Undo Tablespace 1.
Fri Jul 20 23:53:11 2007
SMON: enabling tx recovery
Fri Jul 20 23:53:11 2007
Database Characterset isFri Jul 20 23:53:11 2007
Published database character set on system events channel
Fri Jul 20 23:53:11 2007
All processes have switched to database character set
Fri Jul 20 23:53:16 2007
Starting background process QMNC
QMNC started with pid=12, OS id=156
Fri Jul 20 23:53:19 2007
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Jul 20 23:53:21 2007
Starting background process MMON
MMON started with pid=14, OS id=152
Fri Jul 20 23:53:21 2007
Starting background process MMNL
MMNL started with pid=15, OS id=1864
Fri Jul 20 23:53:23 2007
Completed: ALTER DATABASE OPEN
Fri Jul 20 23:53:33 2007
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Jul 20 23:53:44 2007
kwqavqueue(): calling dbms_aq_sys_imp_internal.post_tts_work():
kwqavquFri Jul 20 23:54:02 2007
kwqavqueue(): calling dbms_aq_sys_imp_internal.post_tts_work():
kwqavqueue(): calling dbms_aq_sys_imp_internal.post_tts_rebuild_idx():
Sat Jul 21 00:06:42 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 8
Current log# 1 seq# 8 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Dump file f:\oracle\base\admin\prod\bdump\alert_prod.log
Sat Jul 21 00:21:35 2007
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:812M/1022M, PG:2334M/2461M, VA:1959M/2047M
Sat Jul 21 00:21:35 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-coIMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = F:\ORACLE\BASE\ORADATA\PROD\CONTROL01.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL02.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\oracle\base\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=PRODXDB)
job_queue_processes = 10
background_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\ user_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\UDUMP
core_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\CDUMP
sort_area_size = 65536
db_name = PROD
open_cursors = 300
pga_aggregate_target = 25165824
Sat Jul 21 00:21:42 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
RECO started with pid=8, OS id=1592
DBW0 started with pid=4, OS id=1576
LGWR started with pid=5, OS id=1580
CKPT started with pid=6, OS id=1584
SMON started with pid=7, OS id=1588
CJQ0 started with pid=9, OS id=1596
MMAN started with pid=3, OS id=1572
PMON started with pid=2, OS id=1568
Sat Jul 21 00:21:44 2007
alter database mount exclusive
Sat Jul 21 00:21:44 2007
Controlfile identified with block size 16384
Sat Jul 21 00:21:49 2007
Setting recovery target incarnation to 2
Sat Jul 21 00:21:49 2007
Successful mount of redo thread 1, with mount id 40277144
Sat Jul 21 00:21:49 2007Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sat Jul 21 00:21:49 2007
alter database open
Sat Jul 21 00:21:50 2007
Beginning crash recovery of 1 threads
Sat Jul 21 00:21:51 2007
Started first pass scan
Sat Jul 21 00:21:55 2007
Completed first pass scan
494 redo blocks read, 38 data blocks need recovery
Sat Jul 21 00:21:55 2007
Started redo application at
Thread 1: logseq 8, block 3703, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Sat Jul 21 00:21:58 2007
Completed redo application
Sat Jul 21 00:21:58 2007
Completed crash recovery at
Thread 1: logseq 8, block 4197, scn 0.372486
38 data blocks read, 38 data blocks written, 494 redo blocks read
Sat Jul 21 00:22:00 2007
Thread 1 advanced to log sequence 9
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log seq Current log# 2 seq# 9 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Successful open of redo thread 1
Sat Jul 21 00:22:00 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Jul 21 00:22:00 2007
SMON: enabling cache recovery
Sat Jul 21 00:22:03 2007
Successfully onlined Undo Tablespace 1.
Sat Jul 21 00:22:03 2007
SMON: enabling tx recovery
Sat Jul 21 00:22:03 2007
Database Characterset is WE8MSWIN1252
Sat Jul 21 00:22:03 2007
Published database character set on system events channel
Sat Jul 21 00:22:03 2007
All processes have switched to database character set
Sat Jul 21 00:22:09 2007
Starting background process QMNC
QMNC started with pid=13, OS id=1656
Sat Jul 21 00:22:15 2007
replication_dependency_tracking turned off (no async multimaster replication found)
Sat Jul 21 00:22:19 2007
Starting background process MMON
MMON started with pid=14, OS id=1704
Sat Jul 21 00:22:19 2007
Starting background process MMNL
MMNL started with pid=15, OS id=1708
Sat Jul 21 0Completed: alter database open
Sat Jul 21 00:35:30 2007
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sat Jul 21 01:00:39 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 10
Current log# 3 seq# 10 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Sat Jul 21 10:02:16 2007
KTSMG_UPDATE_MQL(): MMNL absent for 29874 secs; Foregrounds taking over
Sat Jul 21 10:04:23 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 11
Current log# 1 seq# 11 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Sat Jul 21 10:05:58 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 12
Current log# 2 seq# 12 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Sat Jul 21 20:09:42 2007
KTSMG_UPDATE_MQL(): MMNL absent for 34869 secs; ForegrouSat Jul 21 20:09:42 2007
KTSMG_UPDATE_MQL(): MMNL absent for 34869 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 34869 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 34869 secs; Foregrounds taking over
Sat Jul 21 20:11:10 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 13
Current log# 3 seq# 13 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Sat Jul 21 20:30:31 2007
Starting background process EMN0
EMN0 started with pid=27, OS id=456
Sat Jul 21 20:30:31 2007
Shutting down instance: further logons disabled
Sat Jul 21 20:30:33 2007
Stopping background process CJQ0
Sat Jul 21 20:30:33 2007
Stopping background process MMNL
Sat Jul 21 20:30:34 2007
Stopping background process MMON
Sat Jul 21 20:30:36 2007
Shutting down instance (immediate)
License high water mark = 20
Sat Jul 21 20:30:36 2007
Stopping Job queue slave processes
Sat Jul 21 20:30:36 2007
Job queue slave processes stopped
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Sat Jul 21 20:30:43 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Jul 21 20:30:43 2007
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 13
Successful close of redo thread 1
Sat Jul 21 20:30:44 2007
Completed: ALTER DATABASE CLOSE NORMAL
Sat Jul 21 20:30:44 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Jul 21 20:31:00 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retenDynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = F:\ORACLE\BASE\ORADATA\PROD\CONTROL01.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL02.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\oracle\base\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (S job_queue_processes = 10
background_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\BDUMP
user_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\UDUMP
core_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\CDUMP
sort_area_size = 65536
db_name = PROD
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=2168
MMAN started with pid=3, OS id=652
DBW0 started with pid=4, OS id=2500
LGWR started with pid=5, OS id=4012
CKPT started with pid=6, OS id=2584
SMON started with pid=7, OS id=600
RECO started with pid=8, OS id=2308
CJQ0 started with pid=9, OS id=2216
Sat Jul 21 20:31:00 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Jul 21 20:31:00 2007
ALTER DATABASE MOUNT
Sat Jul 21 20:31:00 2007
Controlfile identified with block size 16384
Sat Jul 21 20:31:05 2007
Setting recovery target incarnation to 2
Sat Jul 21 20:31:05 2007Successful mount of redo thread 1, with mount id 40362500
Sat Jul 21 20:31:05 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Jul 21 20:31:34 2007
alter database archivelog
Sat Jul 21 20:31:34 2007
Completed: alter database archivelog
Dump file f:\oracle\base\admin\prod\bdump\alert_prod.log
Mon Jul 23 09:39:00 2007
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:812M/1022M, PG:2334M/2461M, VA:1959M/2047M
Mon Jul 23 09:39:00 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYSStarting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = F:\ORACLE\BASE\ORADATA\PROD\CONTROL01.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL02.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\oracle\base\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=PRODXDB)
job_queue_processes = 10
background_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\BDUMP
user_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\UDUM core_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\CDUMP
sort_area_size = 65536
db_name = PROD
open_cursors = 300
pga_aggregate_target = 25165824
Mon Jul 23 09:39:06 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
CKPT started with pid=6, OS id=1564
SMON started with pid=7, OS id=1568
PMON started with pid=2, OS id=1548
RECO started with pid=8, OS id=1572
CJQ0 started with pid=9, OS id=1576
MMAN started with pid=3, OS id=1552
DBW0 started with pid=4, OS id=1556
LGWR started with pid=5, OS id=1560
Mon Jul 23 09:39:09 2007
alter database mount exclusive
Mon Jul 23 09:39:09 2007
Controlfile identified with block size 16384
Mon Jul 23 09:39:14 2007
Setting recovery target incarnation to 2
Mon Jul 23 09:39:15 2007
Successful mount of redo thread 1, with mount id 40521789
Mon Jul 23 09:39:15 2007
Database mounted in Exclusive Mode.
Completed: alter databasMon Jul 23 09:39:16 2007
alter database open
Mon Jul 23 09:39:20 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=13, OS id=1640
ARC0: Archival started
ARC1 started with pid=14, OS id=1644
Mon Jul 23 09:39:20 2007
LGWR: STARTING ARCH PROCESSES COMPLETE
Mon Jul 23 09:39:20 2007
ARC1: Archival started
Mon Jul 23 09:39:20 2007
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Mon Jul 23 09:39:20 2007
ARC1: Becoming the heartbeat ARCH
Mon Jul 23 09:39:20 2007
LGWR: Primary database is in CLUSTER CONSISTENT mode
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 2 at log switch
Thread 1 opened at log sequence 13
Current log# 3 seq# 13 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Successful open of redo thread 1
Mon Jul 23 09:39:21 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jul 23 09:49:58 2007
SMON: enabling cache recovery
Mon Jul 23 09:50:13 2007
SuccessfuMon Jul 23 09:50:13 2007
SMON: enabling tx recovery
Mon Jul 23 09:50:13 2007
Database Characterset is WE8MSWIN1252
Mon Jul 23 09:50:13 2007
Published database character set on system events channel
Mon Jul 23 09:50:14 2007
All processes have switched to database character set
Mon Jul 23 09:50:20 2007
Starting background process QMNC
QMNC started with pid=15, OS id=2008
Mon Jul 23 09:50:25 2007
replication_dependency_tracking turned off (no async multimaster replication found)
Mon Jul 23 09:50:28 2007
Starting background process MMON
MMON started with pid=16, OS id=2016
Mon Jul 23 09:50:28 2007
Starting background process MMNL
MMNL started with pid=17, OS id=2020
Mon Jul 23 09:50:32 2007
Completed: alter database open
Mon Jul 23 09:53:08 2007
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesysteMon Jul 23 09:53:45 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 14
Current log# 1 seq# 14 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Mon Jul 23 09:53:46 2007
ARC1: Evaluating archive log 3 thread 1 sequence 13
Mon Jul 23 09:53:57 2007
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_13_3B8QND9R_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_13_3B8QND9R_.ARC
Mon Jul 23 10:01:00 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 15
Current log# 2 seq# 15 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Mon Jul 23 10:01:01 2007
ARC1: Evaluating archive log 1 thread 1 sequence 14
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_14_3B8R1XJM_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_14_3B8R1XJM_.ARC
Mon Jul 2Private_strands 7 at log switch
Thread 1 advanced to log sequence 16
Current log# 3 seq# 16 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Mon Jul 23 10:08:09 2007
ARC1: Evaluating archive log 2 thread 1 sequence 15
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_15_3B8RHB5V_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_15_3B8RHB5V_.ARC
Mon Jul 23 11:00:32 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 17
Current log# 1 seq# 17 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Mon Jul 23 11:00:32 2007
ARC1: Evaluating archive log 3 thread 1 sequence 16
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_16_3B8VKK0Z_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_16_3B8VKK0Z_.ARC
Mon Jul 23 17:09:34 2007
KTSMG_UPDATE_MQL(): MMNL absent foMon Jul 23 18:00:07 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 18
Current log# 2 seq# 18 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Mon Jul 23 18:00:08 2007
ARC1: Evaluating archive log 1 thread 1 sequence 17
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_17_3B9N48NZ_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_17_3B9N48NZ_.ARC
Mon Jul 23 19:08:39 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 19
Current log# 3 seq# 19 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Mon Jul 23 19:08:40 2007
ARC1: Evaluating archive log 2 thread 1 sequence 18
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_18_3B9R4SGN_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_18_3B9R4SGN_.ARC
Dump file f:\oracle\base\admin\proMon Jul 23 20:48:35 2007
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:811M/1022M, PG:2334M/2461M, VA:1959M/2047M
Mon Jul 23 20:48:35 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = F:\ORACLE\BASE\ORADATA\PROD\CONTROL01 db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\oracle\base\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=PRODXDB)
job_queue_processes = 10
background_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\BDUMP
user_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\UDUMP
core_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\CDUMP
sort_area_size = 65536
db_name = PROD
open_cursors = 300
pga_aggregate_target = 25165824
Mon Jul 23 20:48:41 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
LGWR started with pid=5, OS id=1504
CJDBW0 started with pid=4, OS id=1500
SMON started with pid=7, OS id=1512
RECO started with pid=8, OS id=1516
MMAN started with pid=3, OS id=1496
CKPT started with pid=6, OS id=1508
PMON started with pid=2, OS id=1492
Mon Jul 23 20:48:43 2007
alter database mount exclusive
Mon Jul 23 20:48:43 2007
Controlfile identified with block size 16384
Mon Jul 23 20:48:48 2007
Setting recovery target incarnation to 2
Mon Jul 23 20:48:48 2007
Successful mount of redo thread 1, with mount id 40587819
Mon Jul 23 20:48:48 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Jul 23 20:48:49 2007
alter database open
Mon Jul 23 20:48:51 2007
Beginning crash recovery of 1 threads
Mon Jul 23 20:48:52 2007
Started first pass scan
Mon Jul 23 20:48:57 2007
Completed first pass scan
2148 redo blocks read, 177 data blocks need recovery
Mon Jul 23 20:48:57 2007
Started redo application at
Thread 1: logseq 19, block 5075, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq Mem# 0 errs 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Mon Jul 23 20:49:02 2007
Completed redo application
Mon Jul 23 20:49:02 2007
Completed crash recovery at
Thread 1: logseq 19, block 7223, scn 0.425164
177 data blocks read, 177 data blocks written, 2148 redo blocks read
Mon Jul 23 20:49:04 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=13, OS id=1596
ARC0: Archival started
Mon Jul 23 20:49:05 2007
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=14, OS id=1708
ARC1: Archival started
Mon Jul 23 20:49:05 2007
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Mon Jul 23 20:49:05 2007
ARC1: Becoming the heartbeat ARCH
Mon Jul 23 20:49:05 2007
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 20
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 20
Current log# 1 seq# 20 mem# 0: F:\ORACLESuccessful open of redo thread 1
Mon Jul 23 21:39:34 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jul 23 21:39:35 2007
ARC0: Evaluating archive log 3 thread 1 sequence 19
Mon Jul 23 21:39:35 2007
ARC1: Evaluating archive log 3 thread 1 sequence 19
ARC1: Unable to archive log 3 thread 1 sequence 19
Log actively being archived by another process
Mon Jul 23 21:39:36 2007
SMON: enabling cache recovery
Mon Jul 23 21:39:36 2007
ARC1: Evaluating archive log 3 thread 1 sequence 19
ARC1: Unable to archive log 3 thread 1 sequence 19
Log actively being archived by another process
Mon Jul 23 21:39:37 2007
db_recovery_file_dest_size of 2048 MB is 2.99% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Jul 23 21:39:39 2007
ARC1: Evaluating archive log 3 thread 1 sequence 19
MoCommitting creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_19_3BB0ZSSD_.ARC'
Mon Jul 23 21:39:41 2007
ARC1: Unable to archive log 3 thread 1 sequence 19
Log actively being archived by another process
Mon Jul 23 21:39:41 2007
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_19_3BB0ZSSD_.ARC
Mon Jul 23 21:39:41 2007
ARC1: Evaluating archive log 3 thread 1 sequence 19
ARC1: Unable to archive log 3 thread 1 sequence 19
Log actively being archived by another process
Mon Jul 23 21:39:48 2007
Successfully onlined Undo Tablespace 1.
Mon Jul 23 21:39:48 2007
SMON: enabling tx recovery
Mon Jul 23 21:39:48 2007
Database Characterset is WE8MSWIN1252
Mon Jul 23 21:39:48 2007
Published database character set on system events channel
Mon Jul 23 21:39:48 2007
All processes have switched to database character set
Mon Jul 23 21:39:54 2007
Starting background process QMNC
QMNC started with pid=15,Mon Jul 23 21:40:00 2007
replication_dependency_tracking turned off (no async multimaster replication found)
Mon Jul 23 21:40:02 2007
Starting background process MMON
Starting background process MMNL
MMON started with pid=16, OS id=1984
MMNL started with pid=17, OS id=1988
Mon Jul 23 21:40:07 2007
Completed: alter database open
Mon Jul 23 22:38:04 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 21
Current log# 2 seq# 21 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Mon Jul 23 22:38:05 2007
ARC1: Evaluating archive log 1 thread 1 sequence 20
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_20_3BB4FG2S_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_20_3BB4FG2S_.ARC
Mon Jul 23 23:05:45 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 22
Current log# 3 seq# 22 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Mon Jul 23 23:05:46 2ARC1: Evaluating archive log 2 thread 1 sequence 21
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_21_3BB61BOC_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_21_3BB61BOC_.ARC
Mon Jul 23 23:07:37 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 23
Current log# 1 seq# 23 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Mon Jul 23 23:07:37 2007
ARC1: Evaluating archive log 3 thread 1 sequence 22
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_22_3BB64T1T_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_22_3BB64T1T_.ARC
Mon Jul 23 23:37:56 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 24
Current log# 2 seq# 24 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Mon Jul 23 23:37:56 2007
ARC1: Evaluating archive log 1 tCommitting creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_23_3BB7XO85_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_23\O1_MF_1_23_3BB7XO85_.ARC
Tue Jul 24 00:05:04 2007
The input backup piece E:\ORCLBACKUP\BACKUPSET\01INJD52_1_1 is in compressed format.
Tue Jul 24 00:09:11 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 25
Current log# 3 seq# 25 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Tue Jul 24 00:09:11 2007
ARC1: Evaluating archive log 2 thread 1 sequence 24
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_24_3BB9R7W6_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_24_3BB9R7W6_.ARC
Tue Jul 24 00:20:35 2007
ALTER SYSTEM SET fast_start_mttr_target=60 SCOPE=SPFILE;
Tue Jul 24 00:20:35 2007
ALTER SYSTEM SET log_archive_dest_1='LOCATION=E:\orclBackup\ArTue Jul 24 00:20:36 2007
ALTER SYSTEM SET log_archive_dest_10='LOCATION=USE_DB_RECOVERY_FILE_DEST OPTIONAL REOPEN=300' SCOPE=SPFILE;
Tue Jul 24 00:20:36 2007
ALTER SYSTEM SET db_flashback_retention_target=2880 SCOPE=SPFILE;
Tue Jul 24 01:11:23 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 26
Current log# 1 seq# 26 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Tue Jul 24 01:11:24 2007
ARC1: Evaluating archive log 3 thread 1 sequence 25
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_25_3BBFDWND_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_25_3BBFDWND_.ARC
Tue Jul 24 13:03:47 2007
KTSMG_UPDATE_MQL(): MMNL absent for 41083 secs; Foregrounds taking over
Tue Jul 24 13:06:50 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 27
Current log# 2 seq# 27 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Tue Jul 24 13:06:51 2007
ARC1:Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_26_3BCQBDC7_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_26_3BCQBDC7_.ARC
Tue Jul 24 13:08:07 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 28
Current log# 3 seq# 28 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Tue Jul 24 13:08:07 2007
ARC1: Evaluating archive log 2 thread 1 sequence 27
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_27_3BCQDQY8_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_27_3BCQDQY8_.ARC
Tue Jul 24 13:34:56 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 29
Current log# 1 seq# 29 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Tue Jul 24 13:34:56 2007
ARC1: Evaluating archive log 3 thread 1 sequence 28
Committing creation of archivelog Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_28_3BCRZ1CQ_.ARC
Tue Jul 24 13:58:50 2007
Starting background process EMN0
EMN0 started with pid=30, OS id=2896
Tue Jul 24 13:58:50 2007
Shutting down instance: further logons disabled
Tue Jul 24 13:58:51 2007
Stopping background process CJQ0
Tue Jul 24 13:58:51 2007
Stopping background process QMNC
Tue Jul 24 13:58:53 2007
Stopping background process MMNL
Tue Jul 24 13:58:53 2007
Stopping background process MMON
Tue Jul 24 13:58:55 2007
Shutting down instance (immediate)
License high water mark = 22
Tue Jul 24 13:58:55 2007
Stopping Job queue slave processes
Tue Jul 24 13:58:55 2007
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Tue Jul 24 13:59:01 2007
ALTER DATABASE CLOSE NORMAL
Tue Jul 24 13:59:01 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jul 24 13:59:02 2007
Shutting down archive processes
Archiving is disabled
Tue Jul 24 13:59:ARCH shutting down
ARC0: Archival stopped
Tue Jul 24 13:59:02 2007
ARCH shutting down
ARC1: Archival stopped
Tue Jul 24 13:59:03 2007
Thread 1 closed at log sequence 29
Successful close of redo thread 1
Tue Jul 24 13:59:03 2007
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jul 24 13:59:03 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Jul 24 14:02:14 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = F:\ORACLE\BASE\ORADATA\PROD\CONTROL01.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL02.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
log_archive_dest_1 = LOCATION=E:\orclBackup\ArchiveLOG OPTIONAL REOPEN=300
log_archive_dest_10 = LOCATION=USE_DB_RECOVERY_FILE_DEST OPTIONAL REOPEN=300
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\oracle\base\flash_recovery_area
db_recovery_file_dest_size= 2147483648
fast_start_mttr_target = 60
db_flashback_retention_target= 2880
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_do dispatchers = (PROTOCOL=TCP) (SERVICE=PRODXDB)
job_queue_processes = 10
background_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\BDUMP
user_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\UDUMP
core_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\CDUMP
sort_area_size = 65536
db_name = PROD
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=3608
MMAN started with pid=3, OS id=3524
DBW0 started with pid=4, OS id=112
LGWR started with pid=5, OS id=1688
CKPT started with pid=6, OS id=2148
SMON started with pid=7, OS id=3408
RECO started with pid=8, OS id=3908
CJQ0 started with pid=9, OS id=1664
Tue Jul 24 14:02:14 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Tue Jul 24 14:02:15 2007
ALTER DATABASE MOUNT
Tue Jul 24 14:02:15 2007
Controlfile identified with block size 16384
Tue Jul 24 14:02:19 2007
SeTue Jul 24 14:02:20 2007
Successful mount of redo thread 1, with mount id 40617831
Tue Jul 24 14:02:20 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Jul 24 14:30:34 2007
Starting ORACLE instance (normal)
Tue Jul 24 14:35:13 2007
ALTER DATABASE ADD LOGFILE MEMBER
'E:\oracle\PROD\REDO01.LOG' TO GROUP 1,
'E:\oracle\PROD\REDO02.LOG' TO GROUP 2,
'E:\oracle\PROD\REDO03.LOG' TO GROUP 3
Tue Jul 24 14:35:27 2007
Starting control autobackup
Control autobackup written to DISK device
handle 'E:\ORCLBACKUP\AUTOBACKUP\C-40310912-20070724-00'
Completed: ALTER DATABASE ADD LOGFILE MEMBER
'E:\oracle\PROD\
Tue Jul 24 14:39:37 2007
ALTER DATABASE DROP LOGFILE MEMBER
'F:\oracle\base\oradata\PROD\REDO01.LOG',
'F:\oracle\base\oradata\PROD\REDO02.LOG',
'F:\oracle\base\oradata\PROD\REDO03.LOG'
Tue Jul 24 14:39:37 2007
ORA-362 signalled during: ALTER DATABASE DROP LOGFILE MEMBER
'F:\oracle\base...
Tue Jul 24 14:41:27 2007
Starting ORACLE instance (normal)
Tue Jul 24 14:41:44 2ALTER DATABASE OPEN
Tue Jul 24 14:41:45 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=12, OS id=1692
ARC0: Archival started
ARC1 started with pid=14, OS id=3992
ARC1: Archival started
Tue Jul 24 14:41:45 2007
LGWR: STARTING ARCH PROCESSES COMPLETE
LGWR: Primary database is in CLUSTER CONSISTENT mode
Tue Jul 24 14:41:45 2007
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Jul 24 14:41:45 2007
ARC1: Becoming the heartbeat ARCH
Tue Jul 24 14:41:45 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_lgwr_1688.trc:
ORA-00313: open failed for members of log group 1 of thread 1
Tue Jul 24 14:41:45 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_lgwr_1688.trc:
ORA-00313: open failed for members of log group 2 of thread 1
Tue Jul 24 14:41:46 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_lgwr_1688.trc:
ORA-00313: open failed for members of log group 3 of thread 1
Tue Jul 24 14:41:46 2007
FAST_START_MTTR_TARGET 60 is out of the valid MTue Jul 24 14:41:46 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_lgwr_1688.trc:
ORA-00313: open failed for members of log group 1 of thread 1
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 5 at log switch
Thread 1 opened at log sequence 29
Current log# 1 seq# 29 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Successful open of redo thread 1
Tue Jul 24 14:41:47 2007
SMON: enabling cache recovery
Tue Jul 24 14:41:48 2007
Successfully onlined Undo Tablespace 1.
Tue Jul 24 14:41:48 2007
SMON: enabling tx recovery
Tue Jul 24 14:41:48 2007
Database Characterset is WE8MSWIN1252
Tue Jul 24 14:41:48 2007
Published database character set on system events channel
Tue Jul 24 14:41:48 2007
All processes have switched to database character set
Tue Jul 24 14:41:54 2007
Starting background process QMNC
QMNC started with pid=15, OS id=1504
Tue Jul 24 14:41:58 2007
replication_dependency_tracking turned off (no Tue Jul 24 14:41:59 2007
Starting background process MMON
MMON started with pid=16, OS id=1512
Tue Jul 24 14:42:00 2007
Starting background process MMNL
MMNL started with pid=17, OS id=3248
Tue Jul 24 14:42:00 2007
FAST_START_MTTR_TARGET 60 is out of the valid MTTR range, use 1151 instead.
Tue Jul 24 14:42:03 2007
Completed: ALTER DATABASE OPEN
Tue Jul 24 14:42:13 2007
db_recovery_file_dest_size of 2048 MB is 7.18% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Jul 24 14:42:30 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 30
Current log# 2 seq# 30 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Current log# 2 seq# 30 mem# 1: E:\ORACLE\PROD\REDO02.LOG
Tue Jul 24 14:42:31 2007
ARC1: Evaluating archive log 1 thread 1 sequence 29
Tue Jul 24 14:42:31 2007
Errors in file f:\oracle\base\aORA-00313: open failed for members of log group 1 of thread 1
Tue Jul 24 14:42:31 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_arc1_3992.trc:
ORA-00313: open failed for members of log group 1 of thread 1
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_29_3BCWXQRW_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_29_3BCWXQRW_.ARC
Committing creation of archivelog 'E:\ORCLBACKUP\ARCHIVELOG\ARC00029_0628472583.001'
Tue Jul 24 14:42:44 2007
ALTER DATABASE DROP LOGFILE MEMBER
'F:\oracle\base\oradata\PROD\REDO01.LOG',
'F:\oracle\base\oradata\PROD\REDO02.LOG',
'F:\oracle\base\oradata\PROD\REDO03.LOG'
Tue Jul 24 14:42:44 2007
ORA-362 signalled during: ALTER DATABASE DROP LOGFILE MEMBER
'F:\oracle\base...
Tue Jul 24 15:09:56 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 31
Current log# 3 seq# 31 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
CTue Jul 24 15:09:57 2007
ARC1: Evaluating archive log 2 thread 1 sequence 30
Tue Jul 24 15:10:08 2007
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_30_3BCYK5L2_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_30_3BCYK5L2_.ARC
Committing creation of archivelog 'E:\ORCLBACKUP\ARCHIVELOG\ARC00030_0628472583.001'
Tue Jul 24 15:31:28 2007
Errors in file f:\oracle\base\admin\prod\udump\prod_ora_3360.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x6CA3AA] [] [] [] []
Tue Jul 24 16:00:06 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_j000_3924.trc:
ORA-12012: error on auto execute of job 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "WKSYS.WK$UPD_INST", line 9
ORA-06512: at "WKSYS.WK$UPD_INST_TRG20", line 1
ORA-04088: error during execution of trigger 'WKSYS.WK$UPD_INST_TRG20'
ORA-06512: at "WKSYS.WK_JOB", line 442
ORA-04063ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Tue Jul 24 16:02:07 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_j000_3924.trc:
ORA-12012: error on auto execute of job 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "WKSYS.WK$UPD_INST", line 9
ORA-06512: at "WKSYS.WK$UPD_INST_TRG20", line 1
ORA-04088: error during execution of trigger 'WKSYS.WK$UPD_INST_TRG20'
ORA-06512: at "WKSYS.WK_JOB", line 442
ORA-04063: package body "WKSYS.WK_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Tue Jul 24 16:06:08 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_j000_3924.trc:
ORA-12012: error on auto execute of job 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "WKSYS.WK$UPD_INST", line 9
ORA-06512: at "WKSYS.WK$UPD_INST_TRG20", line 1
ORA-04088: error during execution of trigger 'WKSYS.WK$UPD_INST_TRG20'
ORA-06512: at "WKSYS.WK_JOB", line 442
ORA-04063: paORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Tue Jul 24 16:58:30 2007
KTSMG_UPDATE_MQL(): MMNL absent for 2968 secs; Foregrounds taking over
Tue Jul 24 16:59:26 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_j000_3924.trc:
ORA-12012: error on auto execute of job 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "WKSYS.WK$UPD_INST", line 9
ORA-06512: at "WKSYS.WK$UPD_INST_TRG20", line 1
ORA-04088: error during execution of trigger 'WKSYS.WK$UPD_INST_TRG20'
ORA-06512: at "WKSYS.WK_JOB", line 442
ORA-04063: package body "WKSYS.WK_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Tue Jul 24 17:00:02 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_j000_3924.trc:
ORA-12012: error on auto execute of job 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "WKSYS.WK$UPD_INST", line 9
ORA-06512: at "WKSYS.WK$UPD_INST_TRG20", line 1
ORA-04088: error during exeORA-06512: at "WKSYS.WK_JOB", line 442
ORA-04063: package body "WKSYS.WK_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Tue Jul 24 17:04:55 2007
Errors in file f:\oracle\base\admin\prod\udump\prod_ora_2004.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x6CA3AA] [] [] [] []
Tue Jul 24 17:05:23 2007
Errors in file f:\oracle\base\admin\prod\udump\prod_ora_1308.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x6CA3AA] [] [] [] []
Tue Jul 24 17:05:37 2007
Errors in file f:\oracle\base\admin\prod\udump\prod_ora_3052.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x6CA3AA] [] [] [] []
Tue Jul 24 17:09:25 2007
Errors in file f:\oracle\base\admin\prod\udump\prod_ora_552.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x6CA3AA] [] [] [] []
Tue Jul 24 17:13:21 2007
Errors in file f:\oracle\base\admin\prod\udump\prod_ora_1772.trc:
ORA-07445: exception encou
Tue Jul 24 17:14:31 2007
ALTER SYSTEM SET sga_target='168820736' SCOPE=BOTH;
Tue Jul 24 17:14:35 2007
ALTER SYSTEM SET db_cache_size='4194304' SCOPE=BOTH;
Tue Jul 24 17:14:38 2007
ALTER SYSTEM SET java_pool_size='0' SCOPE=BOTH;
Tue Jul 24 17:14:38 2007
ALTER SYSTEM SET large_pool_size='0' SCOPE=BOTH;
Tue Jul 24 17:14:38 2007
ALTER SYSTEM SET shared_pool_size='0' SCOPE=BOTH;
Tue Jul 24 19:54:15 2007
KTSMG_UPDATE_MQL(): MMNL absent for 8665 secs; Foregrounds taking over
Tue Jul 24 19:54:15 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_j001_2984.trc:
ORA-12012: error on auto execute of job 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "WKSYS.WK$UPD_INST", line 9
ORA-06512: at "WKSYS.WK$UPD_INST_TRG20", line 1
ORA-04088: error during execution of trigger 'WKSYS.WK$UPD_INST_TRG20'
ORA-06512: at "WKSYS.WK_JOB", line 442
ORA-04063: package body "WKSYS.WK_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Tue JulPrivate_strands 7 at log switch
Thread 1 advanced to log sequence 32
Current log# 1 seq# 32 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Current log# 1 seq# 32 mem# 1: E:\ORACLE\PROD\REDO01.LOG
Tue Jul 24 19:55:27 2007
ARC1: Evaluating archive log 3 thread 1 sequence 31
Tue Jul 24 19:55:41 2007
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_31_3BDH8JRF_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_31_3BDH8JRF_.ARC
Committing creation of archivelog 'E:\ORCLBACKUP\ARCHIVELOG\ARC00031_0628472583.001'
Dump file f:\oracle\base\admin\prod\bdump\alert_prod.log
Tue Jul 24 20:00:10 2007
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:799M/1022M, PG:2317M/2461M, VA:1959M/2047M
Tue Jul 24 20:00:10 2007
Starting ORACLE instance (normal)
LICENSE_MLICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 83886080
shared_pool_size = 8388608
__large_pool_size = 4194304
large_pool_size = 4194304
__java_pool_size = 50331648
java_pool_size = 4194304
sga_target = 171966464
control_files = F:\ORACLE\BASE\ORADATA\PROD\CONTROL01.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL02.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 29360128
db_cache_size = 4194304
compatible = 10.1.0.2.0
log_archive_dest_1 log_archive_dest_10 = LOCATION=USE_DB_RECOVERY_FILE_DEST OPTIONAL REOPEN=300
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\oracle\base\flash_recovery_area
db_recovery_file_dest_size= 2147483648
fast_start_mttr_target = 60
db_flashback_retention_target= 2880
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=PRODXDB)
job_queue_processes = 10
background_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\BDUMP
user_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\UDUMP
core_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\CDUMP
sort_area_size = 65536
db_name = PROD
open_cursors = 300
pga_aggregate_target = 25165824
Tue Jul 24 20:00:16 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) CKPT started with pid=6, OS id=1864
PMON started with pid=2, OS id=1848
DBW0 started with pid=4, OS id=1856
SMON started with pid=7, OS id=1868
RECO started with pid=8, OS id=1872
CJQ0 started with pid=9, OS id=1876
LGWR started with pid=5, OS id=1860
MMAN started with pid=3, OS id=1852
Tue Jul 24 20:00:18 2007
alter database mount exclusive
Tue Jul 24 20:00:18 2007
Controlfile identified with block size 16384
Tue Jul 24 20:00:22 2007
Setting recovery target incarnation to 2
Tue Jul 24 20:00:23 2007
Successful mount of redo thread 1, with mount id 40602450
Tue Jul 24 20:00:23 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 24 20:00:23 2007
alter database open
Tue Jul 24 20:00:24 2007
Beginning crash recovery of 1 threads
Tue Jul 24 20:00:25 2007
Started first pass scan
Tue Jul 24 20:00:31 2007
Completed first pass scan
4196 redo blocks read, 393 data blocks need recovery
Tue Jul 24 20:00:31 2007
Started redo application at
Thread 1: logseq 3Recovery of Online Redo Log: Thread 1 Group 3 Seq 31 Reading mem 0
Mem# 0 errs 0: F:\ORACLE\BASE\ORADATA\PROD\REDO03.LOG
Mem# 1 errs 0: E:\ORACLE\PROD\REDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 1 Seq 32 Reading mem 0
Mem# 0 errs 0: F:\ORACLE\BASE\ORADATA\PROD\REDO01.LOG
Mem# 1 errs 0: E:\ORACLE\PROD\REDO01.LOG
Tue Jul 24 20:00:36 2007
Completed redo application
Tue Jul 24 20:00:36 2007
Completed crash recovery at
Thread 1: logseq 32, block 1155, scn 0.488924
393 data blocks read, 393 data blocks written, 4196 redo blocks read
Tue Jul 24 20:00:37 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=13, OS id=1988
ARC0: Archival started
ARC1 started with pid=14, OS id=1996
ARC1: Archival started
Tue Jul 24 20:00:37 2007
LGWR: STARTING ARCH PROCESSES COMPLETE
Tue Jul 24 20:00:37 2007
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Jul 24 20:00:37 2007
ARC1: Becoming the heartbeat ARCH
Tue Jul 24 20:00:37 2007
LGWR: Primary database is in CLUFAST_START_MTTR_TARGET 60 is out of the valid MTTR range, use 1151 instead.
Thread 1 advanced to log sequence 33
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 33
Current log# 2 seq# 33 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Current log# 2 seq# 33 mem# 1: E:\ORACLE\PROD\REDO02.LOG
Successful open of redo thread 1
Tue Jul 24 20:00:39 2007
ARC1: Evaluating archive log 1 thread 1 sequence 32
Tue Jul 24 20:00:39 2007
ARC0: Evaluating archive log 1 thread 1 sequence 32
Tue Jul 24 20:00:39 2007
ARC1: Unable to archive log 1 thread 1 sequence 32
Log actively being archived by another process
Tue Jul 24 20:00:39 2007
SMON: enabling cache recovery
Tue Jul 24 20:00:39 2007
ARC1: Evaluating archive log 1 thread 1 sequence 32
ARC1: Unable to archive log 1 thread 1 sequence 32
Log actively being archived by another process
Tue Jul 24 20:00:41 20db_recovery_file_dest_size of 2048 MB is 8.27% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Committing creation of archivelog 'F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_32_3BDHL91G_.ARC'
Created Oracle managed file F:\ORACLE\BASE\FLASH_RECOVERY_AREA\PROD\ARCHIVELOG\2007_07_24\O1_MF_1_32_3BDHL91G_.ARC
Committing creation of archivelog 'E:\ORCLBACKUP\ARCHIVELOG\ARC00032_0628472583.001'
Tue Jul 24 20:00:46 2007
Successfully onlined Undo Tablespace 1.
Tue Jul 24 20:00:46 2007
SMON: enabling tx recovery
Tue Jul 24 20:00:47 2007
Database Characterset is WE8MSWIN1252
Tue Jul 24 20:00:47 2007
Published database character set on system events channel
Tue Jul 24 20:00:47 2007
All processes have switched to database character set
Tue Jul 24 20:00:55 2007
Starting background process QMNC
QMNC starTue Jul 24 20:01:01 2007
replication_dependency_tracking turned off (no async multimaster replication found)
Tue Jul 24 20:01:03 2007
Starting background process MMON
MMON started with pid=16, OS id=212
Tue Jul 24 20:01:03 2007
Starting background process MMNL
MMNL started with pid=17, OS id=220
Tue Jul 24 20:01:07 2007
FAST_START_MTTR_TARGET 60 is out of the valid MTTR range, use 873 instead.
Tue Jul 24 20:01:08 2007
Completed: alter database open
Tue Jul 24 20:01:36 2007
Errors in file f:\oracle\base\admin\prod\bdump\prod_j001_204.trc:
ORA-12012: error on auto execute of job 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "WKSYS.WK$UPD_INST", line 9
ORA-06512: at "WKSYS.WK$UPD_INST_TRG20", line 1
ORA-04088: error during execution of trigger 'WKSYS.WK$UPD_INST_TRG20'
ORA-06512: at "WKSYS.WK_JOB", line 442
ORA-04063: package body "WKSYS.WK_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Tue Jul 24 20:09:16 2007
ErroORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x6CA3AA] [] [] [] []
Tue Jul 24 20:10:28 2007
Starting background process EMN0
EMN0 started with pid=23, OS id=2900
Tue Jul 24 20:10:28 2007
Shutting down instance: further logons disabled
Tue Jul 24 20:10:28 2007
Stopping background process CJQ0
Tue Jul 24 20:10:28 2007
Stopping background process QMNC
Tue Jul 24 20:10:29 2007
Stopping background process MMNL
Tue Jul 24 20:10:30 2007
Stopping background process MMON
Tue Jul 24 20:10:32 2007
Shutting down instance (immediate)
License high water mark = 14
Tue Jul 24 20:10:32 2007
Stopping Job queue slave processes
Tue Jul 24 20:10:35 2007
Waiting for Job queue slaves to complete
Tue Jul 24 20:10:35 2007
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Tue Jul 24 20:10:38 2007
ALTER DATABASE CLOSE NORMAL
Tue Jul 24 20:10:39 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jul 24 20:10:39 2007
Shutting down archive processes
ATue Jul 24 20:10:39 2007
ARCH shutting down
ARC0: Archival stopped
Tue Jul 24 20:10:39 2007
ARCH shutting down
ARC1: Archival stopped
Tue Jul 24 20:10:40 2007
Thread 1 closed at log sequence 33
Successful close of redo thread 1
Tue Jul 24 20:10:40 2007
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jul 24 20:10:40 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Jul 24 20:22:17 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 83886080
shared_pool_size = 8388608
__large_pool_size = 4194304
large_pool_size = 4194304
__java_pool_size = 50331648
java_pool_size = 4194304
sga_target = 171966464
control_files = F:\ORACLE\BASE\ORADATA\PROD\CONTROL01.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL02.CTL, F:\ORACLE\BASE\ORADATA\PROD\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 29360128
db_cache_size = 4194304
compatible = 10.1.0.2.0
log_archive_dest_1 = LOCATION=E:\orclBackup\ArchiveLOG OPTIONAL REOPEN=300
log_archive_dest_10 = LOCATION=USE_DB_RECOVERY_FILE_DEST OPTIONAL REOPEN=300
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\oracle\base\flash_recovery_area
db_recovery_fil fast_start_mttr_target = 60
db_flashback_retention_target= 2880
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=PRODXDB)
job_queue_processes = 10
background_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\BDUMP
user_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\UDUMP
core_dump_dest = F:\ORACLE\BASE\ADMIN\PROD\CDUMP
sort_area_size = 65536
db_name = PROD
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=1340
MMAN started with pid=3, OS id=2064
DBW0 started with pid=4, OS id=2204
LGWR started with pid=5, OS id=2272
CKPT started with pid=6, OS id=2248
SMON started with pid=7, OS id=2244
RECO started with pid=8, OS id=2360
CJQ0 started with pid=9, OS id=732
Tue Jul 24 20:22:18 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(Pstarting up 1 shared server(s) ...
Tue Jul 24 20:22:18 2007
ALTER DATABASE MOUNT
Tue Jul 24 20:22:18 2007
Controlfile identified with block size 16384
Tue Jul 24 20:22:23 2007
Setting recovery target incarnation to 2
Tue Jul 24 20:22:23 2007
Successful mount of redo thread 1, with mount id 40610426
Tue Jul 24 20:22:23 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Jul 24 20:22:24 2007
ALTER DATABASE OPEN
Tue Jul 24 20:22:24 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=12, OS id=2236
ARC0: Archival started
ARC1 started with pid=14, OS id=2224
ARC1: Archival started
Tue Jul 24 20:22:25 2007
LGWR: STARTING ARCH PROCESSES COMPLETE
LGWR: Primary database is in CLUSTER CONSISTENT mode
Tue Jul 24 20:22:25 2007
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Jul 24 20:22:25 2007
ARC1: Becoming the heartbeat ARCH
Tue Jul 24 20:22:25 2007
FAST_START_MTTR_TARGET 60 is out of the valid MTTR range, use 873 instead.
Maximum redo genMaximum redo generation change vector size = 116476 bytes
Private_strands 6 at log switch
Thread 1 opened at log sequence 33
Current log# 2 seq# 33 mem# 0: F:\ORACLE\BASE\ORADATA\PROD\REDO02.LOG
Current log# 2 seq# 33 mem# 1: E:\ORACLE\PROD\REDO02.LOG
Successful open of redo thread 1
Tue Jul 24 20:22:26 2007
SMON: enabling cache recovery
Tue Jul 24 20:22:28 2007
Successfully onlined Undo Tablespace 1.
Tue Jul 24 20:22:28 2007
SMON: enabling tx recovery
Tue Jul 24 20:22:29 2007
Database Characterset is WE8MSWIN1252
Tue Jul 24 20:22:29 2007
Published database character set on system events channel
Tue Jul 24 20:22:29 2007
All processes have switched to database character set
Tue Jul 24 20:22:35 2007
Starting background process QMNC
QMNC started with pid=15, OS id=2460
Tue Jul 24 20:22:38 2007
replication_dependency_tracking turned off (no async multimaster replication found)
Tue Jul 24 20:22:40 2007
Starting background process MMON
MMON started with pid=17, OS id=2560
Tue Jul 24 20:2Starting background process MMNL
MMNL started with pid=18, OS id=2556
Tue Jul 24 20:22:45 2007
Completed: ALTER DATABASE OPEN
Tue Jul 24 20:22:46 2007
FAST_START_MTTR_TARGET 60 is out of the valid MTTR range, use 661 instead.
Tue Jul 24 20:22:53 2007
db_recovery_file_dest_size of 2048 MB is 8.27% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Jul 24 20:24:35 2007
Errors in file f:\oracle\base\admin\prod\udump\prod_ora_2492.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x6CA3AA] [] [] [] []