Dump file c:\oracle\product\10.2.0\admin\scott\bdump\alert_scott.log Wed Jun 13 00:27:45 2012 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows XP Version V5.1 Service Pack 3 CPU : 1 - type 586, 1 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:98M/511M, Ph+PgF:916M/1246M, VA:1941M/2047M Wed Jun 13 00:27:45 2012 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 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.3.0. System parameters with non-default values: processes = 150 sga_target = 167772160 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL03.CTL db_block_size = 8192 compatible = 10.2.0.3.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0\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=scottXDB) job_queue_processes = 10 audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\CDUMP db_name = scott open_cursors = 300 pga_aggregate_target = 16777216 PSP0 started with pid=3, OS id=1808 MMAN started with pid=4, OS id=2848 PMON started with pid=2, OS id=2780 DBW0 started with pid=5, OS id=1992 LGWR started with pid=6, OS id=2852 CKPT started with pid=7, OS id=2236 SMON started with pid=8, OS id=264 RECO started with pid=9, OS id=2408 CJQ0 started with pid=10, OS id=2896 MMON started with pid=11, OS id=3300 Wed Jun 13 00:27:51 2012 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=12, OS id=336 Wed Jun 13 00:27:51 2012 starting up 1 shared server(s) ... Wed Jun 13 00:27:56 2012 The input backup piece C:\ORACLE\PRODUCT\10.2.0\DB_1\ASSISTANTS\DBCA\TEMPLATES\SEED_DATABASE.DFB is in compressed format. Full restore complete of datafile 4 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\USERS01.DBF. Elapsed time: 0:00:01 checkpoint is 521802 Full restore complete of datafile 2 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\UNDOTBS01.DBF. Elapsed time: 0:00:02 checkpoint is 521802 Wed Jun 13 00:29:08 2012 Full restore complete of datafile 3 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\SYSAUX01.DBF. Elapsed time: 0:01:12 checkpoint is 521802 last deallocation scn is 521589 Wed Jun 13 00:29:45 2012 Full restore complete of datafile 1 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\SYSTEM01.DBF. Elapsed time: 0:01:49 checkpoint is 521802 last deallocation scn is 515202 Wed Jun 13 00:29:46 2012 Create controlfile reuse set database "scott" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 Datafile 'C:\oracle\product\10.2.0\oradata\scott\SYSTEM01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\UNDOTBS01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\SYSAUX01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\USERS01.DBF' LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\scott\redo01.log') SIZE 51200K, GROUP 2 ('C:\oracle\product\10.2.0\oradata\scott\redo02.log') SIZE 51200K, GROUP 3 ('C:\oracle\product\10.2.0\oradata\scott\redo03.log') SIZE 51200K RESETLOGS WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command Default Temporary Tablespace will be necessary for a locally managed database in future release Setting recovery target incarnation to 1 Wed Jun 13 00:29:48 2012 Successful mount of redo thread 1, with mount id 577046906 Wed Jun 13 00:29:48 2012 Completed: Create controlfile reuse set database "scott" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 Datafile 'C:\oracle\product\10.2.0\oradata\scott\SYSTEM01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\UNDOTBS01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\SYSAUX01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\USERS01.DBF' LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\scott\redo01.log') SIZE 51200K, GROUP 2 ('C:\oracle\product\10.2.0\oradata\scott\redo02.log') SIZE 51200K, GROUP 3 ('C:\oracle\product\10.2.0\oradata\scott\redo03.log') SIZE 51200K RESETLOGS Shutting down instance: further logons disabled Wed Jun 13 00:29:49 2012 Stopping background process CJQ0 Wed Jun 13 00:29:49 2012 Stopping background process MMNL Wed Jun 13 00:29:49 2012 Stopping background process MMON Wed Jun 13 00:29:50 2012 Shutting down instance (immediate) License high water mark = 1 Wed Jun 13 00:29:50 2012 Stopping Job queue slave processes Wed Jun 13 00:29:50 2012 Job queue slave processes stopped Waiting for dispatcher 'D000' to shutdown All dispatchers and shared servers shutdown Wed Jun 13 00:29:51 2012 ALTER DATABASE CLOSE NORMAL ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL... Wed Jun 13 00:29:51 2012 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 Wed Jun 13 00:29:52 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.3.0. System parameters with non-default values: processes = 150 sga_target = 167772160 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL03.CTL db_block_size = 8192 compatible = 10.2.0.3.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0\flash_recovery_area db_recovery_file_dest_size= 2147483648 _no_recovery_through_resetlogs= TRUE undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=scottXDB) audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\CDUMP db_name = scott open_cursors = 300 pga_aggregate_target = 16777216 PMON started with pid=2, OS id=3940 PSP0 started with pid=3, OS id=3752 MMAN started with pid=4, OS id=3320 DBW0 started with pid=5, OS id=3360 LGWR started with pid=6, OS id=1156 CKPT started with pid=7, OS id=3228 SMON started with pid=8, OS id=1668 RECO started with pid=9, OS id=588 MMON started with pid=10, OS id=3592 Wed Jun 13 00:29:52 2012 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=11, OS id=4052 Wed Jun 13 00:29:52 2012 starting up 1 shared server(s) ... Wed Jun 13 00:29:53 2012 Create controlfile reuse set database "scott" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 Datafile 'C:\oracle\product\10.2.0\oradata\scott\SYSTEM01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\UNDOTBS01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\SYSAUX01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\USERS01.DBF' LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\scott\redo01.log') SIZE 51200K, GROUP 2 ('C:\oracle\product\10.2.0\oradata\scott\redo02.log') SIZE 51200K, GROUP 3 ('C:\oracle\product\10.2.0\oradata\scott\redo03.log') SIZE 51200K RESETLOGS Wed Jun 13 00:29:53 2012 WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command Default Temporary Tablespace will be necessary for a locally managed database in future release Setting recovery target incarnation to 1 Wed Jun 13 00:29:54 2012 Successful mount of redo thread 1, with mount id 577023105 Wed Jun 13 00:29:54 2012 Completed: Create controlfile reuse set database "scott" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 Datafile 'C:\oracle\product\10.2.0\oradata\scott\SYSTEM01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\UNDOTBS01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\SYSAUX01.DBF', 'C:\oracle\product\10.2.0\oradata\scott\USERS01.DBF' LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\scott\redo01.log') SIZE 51200K, GROUP 2 ('C:\oracle\product\10.2.0\oradata\scott\redo02.log') SIZE 51200K, GROUP 3 ('C:\oracle\product\10.2.0\oradata\scott\redo03.log') SIZE 51200K RESETLOGS Wed Jun 13 00:29:54 2012 Stopping background process MMNL Wed Jun 13 00:29:54 2012 Stopping background process MMON Starting background process MMON Starting background process MMNL MMON started with pid=10, OS id=3852 Wed Jun 13 00:29:54 2012 ALTER SYSTEM enable restricted session; MMNL started with pid=11, OS id=2392 Wed Jun 13 00:29:54 2012 alter database "scott" open resetlogs Wed Jun 13 00:29:55 2012 RESETLOGS after incomplete recovery UNTIL CHANGE 521802 Wed Jun 13 00:29:55 2012 Errors in file c:\oracle\product\10.2.0\admin\scott\udump\scott_ora_3364.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\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. Wed Jun 13 00:29:57 2012 Errors in file c:\oracle\product\10.2.0\admin\scott\udump\scott_ora_3364.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO02.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. Wed Jun 13 00:29:59 2012 Errors in file c:\oracle\product\10.2.0\admin\scott\udump\scott_ora_3364.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\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. Wed Jun 13 00:30:01 2012 Setting recovery target incarnation to 2 Wed Jun 13 00:30:01 2012 Assigning activation ID 577023105 (0x2264ac81) Thread 1 opened at log sequence 1 Current log# 3 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO03.LOG Successful open of redo thread 1 Wed Jun 13 00:30:02 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jun 13 00:30:02 2012 SMON: enabling cache recovery Wed Jun 13 00:30:05 2012 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 Wed Jun 13 00:30:06 2012 SMON: enabling tx recovery Wed Jun 13 00:30:06 2012 ********************************************************************* 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 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. ********************************************************** replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=15, OS id=484 Wed Jun 13 00:30:17 2012 LOGSTDBY: Validating controlfile with logical metadata Wed Jun 13 00:30:17 2012 LOGSTDBY: Validation complete Global Name changed to SCOTT Wed Jun 13 00:30:29 2012 Completed: alter database "scott" open resetlogs Wed Jun 13 00:30:30 2012 alter database rename global_name to "scott" Completed: alter database rename global_name to "scott" Wed Jun 13 00:30:30 2012 ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\product\10.2.0\oradata\scott\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\product\10.2.0\oradata\scott\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED Wed Jun 13 00:30:31 2012 ALTER DATABASE DEFAULT TABLESPACE "USERS" Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS" Wed Jun 13 00:30:44 2012 ALTER SYSTEM disable restricted session; Wed Jun 13 00:30:45 2012 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. Wed Jun 13 00:30:54 2012 The input backup piece C:\ORACLE\PRODUCT\10.2.0\DB_1\ASSISTANTS\DBCA\TEMPLATES\EXAMPLE01.DFB is in compressed format. Wed Jun 13 00:30:55 2012 Starting background process CJQ0 CJQ0 started with pid=18, OS id=3652 Wed Jun 13 00:31:06 2012 Full restore complete of datafile 5 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\EXAMPLE01.DBF. Elapsed time: 0:00:12 checkpoint is 538903 last deallocation scn is 538486 Wed Jun 13 00:31:14 2012 Plug in tablespace EXAMPLE with datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\EXAMPLE01.DBF' Wed Jun 13 00:32:12 2012 ALTER TABLESPACE example READ WRITE Wed Jun 13 00:32:13 2012 Completed: ALTER TABLESPACE example READ WRITE Wed Jun 13 00:33:41 2012 Starting background process EMN0 EMN0 started with pid=19, OS id=2640 Wed Jun 13 00:33:42 2012 Shutting down instance: further logons disabled Wed Jun 13 00:33:48 2012 Stopping background process QMNC Wed Jun 13 00:33:48 2012 Stopping background process CJQ0 Wed Jun 13 00:33:50 2012 Stopping background process MMNL Wed Jun 13 00:33:51 2012 Stopping background process MMON Wed Jun 13 00:33:53 2012 Shutting down instance (immediate) License high water mark = 5 All dispatchers and shared servers shutdown Wed Jun 13 00:33:59 2012 ALTER DATABASE CLOSE NORMAL Wed Jun 13 00:34:00 2012 SMON: disabling tx recovery SMON: disabling cache recovery Wed Jun 13 00:34:00 2012 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 1 Successful close of redo thread 1 Wed Jun 13 00:34:01 2012 Completed: ALTER DATABASE CLOSE NORMAL Wed Jun 13 00:34:01 2012 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 Wed Jun 13 00:34:04 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.3.0. System parameters with non-default values: processes = 150 sga_target = 167772160 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL03.CTL db_block_size = 8192 compatible = 10.2.0.3.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0\flash_recovery_area db_recovery_file_dest_size= 2147483648 _no_recovery_through_resetlogs= TRUE undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=scottXDB) audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\CDUMP db_name = scott open_cursors = 300 pga_aggregate_target = 16777216 PMON started with pid=2, OS id=4008 PSP0 started with pid=3, OS id=1720 MMAN started with pid=4, OS id=2076 DBW0 started with pid=5, OS id=120 LGWR started with pid=6, OS id=452 CKPT started with pid=7, OS id=2036 SMON started with pid=8, OS id=1528 RECO started with pid=9, OS id=4092 MMON started with pid=10, OS id=2336 MMNL started with pid=11, OS id=1604 Wed Jun 13 00:34:05 2012 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... Wed Jun 13 00:34:05 2012 ALTER DATABASE MOUNT Wed Jun 13 00:34:10 2012 Setting recovery target incarnation to 2 Wed Jun 13 00:34:10 2012 Successful mount of redo thread 1, with mount id 577010301 Wed Jun 13 00:34:10 2012 Database mounted in Exclusive Mode Completed: ALTER DATABASE MOUNT Wed Jun 13 00:34:10 2012 ALTER DATABASE OPEN Wed Jun 13 00:34:11 2012 Thread 1 opened at log sequence 1 Current log# 3 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO03.LOG Successful open of redo thread 1 Wed Jun 13 00:34:11 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jun 13 00:34:11 2012 SMON: enabling cache recovery Wed Jun 13 00:34:13 2012 Successfully onlined Undo Tablespace 1. Wed Jun 13 00:34:13 2012 SMON: enabling tx recovery Wed Jun 13 00:34:13 2012 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=14, OS id=3164 Wed Jun 13 00:34:26 2012 Completed: ALTER DATABASE OPEN Wed Jun 13 00:34:26 2012 Stopping background process MMNL Wed Jun 13 00:34:26 2012 Stopping background process MMON Wed Jun 13 00:34:26 2012 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. Wed Jun 13 00:34:27 2012 Starting background process MMON Starting background process MMNL MMON started with pid=16, OS id=3428 Wed Jun 13 00:34:27 2012 ALTER SYSTEM enable restricted session; MMNL started with pid=17, OS id=2232 Wed Jun 13 00:34:27 2012 alter database character set INTERNAL_CONVERT WE8MSWIN1252 Wed Jun 13 00:34:37 2012 Thread 1 advanced to log sequence 2 Current log# 1 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO01.LOG Wed Jun 13 00:34:39 2012 Updating character set in controlfile to WE8MSWIN1252 Synchronizing connection with database character set information Refreshing type attributes with new character set information Completed: alter database character set INTERNAL_CONVERT WE8MSWIN1252 Wed Jun 13 00:34:45 2012 ALTER SYSTEM disable restricted session; Wed Jun 13 00:35:02 2012 Starting background process EMN0 EMN0 started with pid=18, OS id=804 Wed Jun 13 00:35:02 2012 Shutting down instance: further logons disabled Wed Jun 13 00:35:12 2012 Stopping background process QMNC Wed Jun 13 00:35:13 2012 Stopping background process MMNL Wed Jun 13 00:35:13 2012 Stopping background process MMON Wed Jun 13 00:35:14 2012 Shutting down instance (immediate) License high water mark = 1 All dispatchers and shared servers shutdown Wed Jun 13 00:35:21 2012 ALTER DATABASE CLOSE NORMAL Wed Jun 13 00:35:22 2012 SMON: disabling tx recovery SMON: disabling cache recovery Wed Jun 13 00:35:22 2012 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 2 Successful close of redo thread 1 Wed Jun 13 00:35:22 2012 Completed: ALTER DATABASE CLOSE NORMAL Wed Jun 13 00:35:22 2012 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 Wed Jun 13 00:35:24 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.3.0. System parameters with non-default values: processes = 150 sga_target = 167772160 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL03.CTL db_block_size = 8192 compatible = 10.2.0.3.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0\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=scottXDB) job_queue_processes = 10 audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\CDUMP db_name = scott open_cursors = 300 pga_aggregate_target = 16777216 PMON started with pid=2, OS id=1536 PSP0 started with pid=3, OS id=3652 MMAN started with pid=4, OS id=3296 DBW0 started with pid=5, OS id=3576 LGWR started with pid=6, OS id=2372 CKPT started with pid=7, OS id=3584 SMON started with pid=8, OS id=1120 RECO started with pid=9, OS id=4044 CJQ0 started with pid=10, OS id=2184 MMON started with pid=11, OS id=848 Wed Jun 13 00:35:25 2012 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=12, OS id=3840 Wed Jun 13 00:35:25 2012 starting up 1 shared server(s) ... Wed Jun 13 00:35:25 2012 ALTER DATABASE MOUNT Wed Jun 13 00:35:29 2012 Setting recovery target incarnation to 2 Wed Jun 13 00:35:29 2012 Successful mount of redo thread 1, with mount id 577008333 Wed Jun 13 00:35:29 2012 Database mounted in Exclusive Mode Completed: ALTER DATABASE MOUNT Wed Jun 13 00:35:29 2012 ALTER DATABASE OPEN Wed Jun 13 00:35:30 2012 Thread 1 opened at log sequence 2 Current log# 1 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO01.LOG Successful open of redo thread 1 Wed Jun 13 00:35:30 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jun 13 00:35:30 2012 SMON: enabling cache recovery Wed Jun 13 00:35:32 2012 Successfully onlined Undo Tablespace 1. Wed Jun 13 00:35:32 2012 SMON: enabling tx recovery Wed Jun 13 00:35:32 2012 Database Characterset is WE8MSWIN1252 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=15, OS id=2652 Wed Jun 13 00:35:47 2012 Completed: ALTER DATABASE OPEN Wed Jun 13 00:35:49 2012 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. Wed Jun 13 00:39:36 2012 SERVER COMPONENT id=CPU_BGN: timestamp=2012-06-13 00:39:36 Wed Jun 13 00:40:06 2012 SERVER COMPONENT id=CATPROC: timestamp=2012-06-13 00:40:06 Wed Jun 13 00:40:46 2012 Thread 1 advanced to log sequence 3 Current log# 2 seq# 3 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO02.LOG Wed Jun 13 00:44:26 2012 Thread 1 advanced to log sequence 4 Current log# 3 seq# 4 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO03.LOG Wed Jun 13 00:46:43 2012 SERVER ACTION=CPU id=5923165: Patch2Vista SERVER COMPONENT id=CPU_END: timestamp=2012-06-13 00:46:43 Wed Jun 13 00:46:46 2012 SERVER COMPONENT id=UTLRP_BGN: timestamp=2012-06-13 00:46:46 Wed Jun 13 00:47:06 2012 SERVER COMPONENT id=UTLRP_END: timestamp=2012-06-13 00:47:06 Thu Jun 14 23:51:16 2012 MMNL absent for 168882 secs; Foregrounds taking over Fri Jun 15 00:29:47 2012 Thread 1 advanced to log sequence 5 Current log# 1 seq# 5 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO01.LOG Fri Jun 15 19:41:24 2012 MMNL absent for 65623 secs; Foregrounds taking over Dump file c:\oracle\product\10.2.0\admin\scott\bdump\alert_scott.log Fri Jun 15 20:14:16 2012 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows XP Version V5.1 Service Pack 3 CPU : 1 - type 586, 1 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:288M/511M, Ph+PgF:1054M/1246M, VA:1940M/2047M Fri Jun 15 20:14:16 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled Fri Jun 15 20:14:35 2012 ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.3.0. System parameters with non-default values: processes = 150 __shared_pool_size = 96468992 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 0 sga_target = 167772160 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL03.CTL db_block_size = 8192 __db_cache_size = 46137344 compatible = 10.2.0.3.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0\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=scottXDB) job_queue_processes = 10 audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\CDUMP db_name = scott open_cursors = 300 pga_aggregate_target = 16777216 PSP0 started with pid=3, OS id=2516 PMON started with pid=2, OS id=2444 MMAN started with pid=4, OS id=2584 DBW0 started with pid=5, OS id=2656 LGWR started with pid=6, OS id=2724 CKPT started with pid=7, OS id=2824 SMON started with pid=8, OS id=2924 RECO started with pid=9, OS id=3024 CJQ0 started with pid=10, OS id=3092 MMON started with pid=11, OS id=3160 MMNL started with pid=12, OS id=3228 Fri Jun 15 20:14:40 2012 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... Fri Jun 15 20:14:47 2012 alter database mount exclusive Fri Jun 15 20:14:54 2012 Setting recovery target incarnation to 2 Fri Jun 15 20:14:56 2012 Successful mount of redo thread 1, with mount id 577298488 Fri Jun 15 20:14:56 2012 Database mounted in Exclusive Mode Completed: alter database mount exclusive Fri Jun 15 20:14:57 2012 alter database open Fri Jun 15 20:15:01 2012 Beginning crash recovery of 1 threads Fri Jun 15 20:15:03 2012 Started redo scan Fri Jun 15 20:15:04 2012 Completed redo scan 139 redo blocks read, 29 data blocks need recovery Fri Jun 15 20:15:04 2012 Started redo application at Thread 1: logseq 5, block 17019 Fri Jun 15 20:15:05 2012 Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0 Mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO01.LOG Fri Jun 15 20:15:06 2012 Completed redo application Fri Jun 15 20:15:06 2012 Completed crash recovery at Thread 1: logseq 5, block 17158, scn 611180 29 data blocks read, 29 data blocks written, 139 redo blocks read Fri Jun 15 20:15:14 2012 Thread 1 advanced to log sequence 6 Thread 1 opened at log sequence 6 Current log# 2 seq# 6 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO02.LOG Successful open of redo thread 1 Fri Jun 15 20:15:16 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri Jun 15 20:15:16 2012 SMON: enabling cache recovery Fri Jun 15 20:15:23 2012 Successfully onlined Undo Tablespace 1. Fri Jun 15 20:15:23 2012 SMON: enabling tx recovery Fri Jun 15 20:15:25 2012 Database Characterset is WE8MSWIN1252 replication_dependency_tracking turned off (no async multimaster replication found) Fri Jun 15 20:15:36 2012 Starting background process QMNC QMNC started with pid=16, OS id=2016 Fri Jun 15 20:16:03 2012 Completed: alter database open Sat Jun 16 08:48:45 2012 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 Jun 16 08:49:34 2012 MMNL absent for 45170 secs; Foregrounds taking over Dump file c:\oracle\product\10.2.0\admin\scott\bdump\alert_scott.log Sat Jun 16 09:11:28 2012 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows XP Version V5.1 Service Pack 3 CPU : 1 - type 586, 1 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:313M/511M, Ph+PgF:1094M/1246M, VA:1941M/2047M Sat Jun 16 09:11:28 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled Sat Jun 16 09:11:40 2012 ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.3.0. System parameters with non-default values: processes = 150 __shared_pool_size = 96468992 __large_pool_size = 4194304 __java_pool_size = 8388608 __streams_pool_size = 0 sga_target = 167772160 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL03.CTL db_block_size = 8192 __db_cache_size = 54525952 compatible = 10.2.0.3.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0\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=scottXDB) job_queue_processes = 10 audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\CDUMP db_name = scott open_cursors = 300 pga_aggregate_target = 16777216 PSP0 started with pid=3, OS id=3260 PMON started with pid=2, OS id=3192 MMAN started with pid=4, OS id=3328 DBW0 started with pid=5, OS id=3404 LGWR started with pid=6, OS id=3504 CKPT started with pid=7, OS id=3636 SMON started with pid=8, OS id=3704 RECO started with pid=9, OS id=3772 CJQ0 started with pid=10, OS id=3840 MMON started with pid=11, OS id=3912 Sat Jun 16 09:11:42 2012 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=12, OS id=3980 Sat Jun 16 09:11:42 2012 starting up 1 shared server(s) ... Sat Jun 16 09:11:45 2012 alter database mount exclusive Sat Jun 16 09:11:50 2012 Setting recovery target incarnation to 2 Sat Jun 16 09:11:50 2012 Successful mount of redo thread 1, with mount id 577280081 Sat Jun 16 09:11:50 2012 Database mounted in Exclusive Mode Completed: alter database mount exclusive Sat Jun 16 09:11:51 2012 alter database open Sat Jun 16 09:11:51 2012 Beginning crash recovery of 1 threads Sat Jun 16 09:11:51 2012 Started redo scan Sat Jun 16 09:11:51 2012 Completed redo scan 738 redo blocks read, 72 data blocks need recovery Sat Jun 16 09:11:52 2012 Started redo application at Thread 1: logseq 6, block 33642 Sat Jun 16 09:11:52 2012 Recovery of Online Redo Log: Thread 1 Group 2 Seq 6 Reading mem 0 Mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO02.LOG Sat Jun 16 09:11:53 2012 Completed redo application Sat Jun 16 09:11:53 2012 Completed crash recovery at Thread 1: logseq 6, block 34380, scn 637652 72 data blocks read, 72 data blocks written, 738 redo blocks read Sat Jun 16 09:11:58 2012 Thread 1 advanced to log sequence 7 Thread 1 opened at log sequence 7 Current log# 3 seq# 7 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO03.LOG Successful open of redo thread 1 Sat Jun 16 09:11:58 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Jun 16 09:11:58 2012 SMON: enabling cache recovery Sat Jun 16 09:12:01 2012 Successfully onlined Undo Tablespace 1. Sat Jun 16 09:12:01 2012 SMON: enabling tx recovery Sat Jun 16 09:12:02 2012 Database Characterset is WE8MSWIN1252 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=16, OS id=2640 Sat Jun 16 09:12:20 2012 Completed: alter database open Sat Jun 16 09:12:22 2012 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 Jun 16 21:00:11 2012 MMNL absent for 30909 secs; Foregrounds taking over MMNL absent for 30909 secs; Foregrounds taking over MMNL absent for 30909 secs; Foregrounds taking over Dump file c:\oracle\product\10.2.0\admin\scott\bdump\alert_scott.log Sat Jun 16 22:40:09 2012 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows XP Version V5.1 Service Pack 3 CPU : 1 - type 586, 1 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:292M/511M, Ph+PgF:1071M/1246M, VA:1941M/2047M Sat Jun 16 22:40:09 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled Sat Jun 16 22:40:20 2012 ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.3.0. System parameters with non-default values: processes = 150 __shared_pool_size = 96468992 __large_pool_size = 4194304 __java_pool_size = 4194304 __streams_pool_size = 0 sga_target = 167772160 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL03.CTL db_block_size = 8192 __db_cache_size = 58720256 compatible = 10.2.0.3.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0\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=scottXDB) job_queue_processes = 10 audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\CDUMP db_name = scott open_cursors = 300 pga_aggregate_target = 16777216 MMAN started with pid=4, OS id=3224 PSP0 started with pid=3, OS id=3156 PMON started with pid=2, OS id=3088 DBW0 started with pid=5, OS id=3292 LGWR started with pid=6, OS id=3368 CKPT started with pid=7, OS id=3524 SMON started with pid=8, OS id=3592 RECO started with pid=9, OS id=3660 CJQ0 started with pid=10, OS id=3728 MMON started with pid=11, OS id=3796 Sat Jun 16 22:40:23 2012 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=12, OS id=3864 Sat Jun 16 22:40:23 2012 starting up 1 shared server(s) ... Sat Jun 16 22:40:27 2012 alter database mount exclusive Sat Jun 16 22:40:32 2012 Setting recovery target incarnation to 2 Sat Jun 16 22:40:32 2012 Successful mount of redo thread 1, with mount id 577365723 Sat Jun 16 22:40:32 2012 Database mounted in Exclusive Mode Completed: alter database mount exclusive Sat Jun 16 22:40:32 2012 alter database open Sat Jun 16 22:40:33 2012 Beginning crash recovery of 1 threads Sat Jun 16 22:40:33 2012 Started redo scan Sat Jun 16 22:40:34 2012 Completed redo scan 176 redo blocks read, 54 data blocks need recovery Sat Jun 16 22:40:34 2012 Started redo application at Thread 1: logseq 7, block 14972 Sat Jun 16 22:40:34 2012 Recovery of Online Redo Log: Thread 1 Group 3 Seq 7 Reading mem 0 Mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO03.LOG Sat Jun 16 22:40:35 2012 Completed redo application Sat Jun 16 22:40:35 2012 Completed crash recovery at Thread 1: logseq 7, block 15148, scn 667354 54 data blocks read, 54 data blocks written, 176 redo blocks read Sat Jun 16 22:40:39 2012 Thread 1 advanced to log sequence 8 Thread 1 opened at log sequence 8 Current log# 1 seq# 8 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO01.LOG Successful open of redo thread 1 Sat Jun 16 22:40:39 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Jun 16 22:40:39 2012 SMON: enabling cache recovery Sat Jun 16 22:40:47 2012 Successfully onlined Undo Tablespace 1. Sat Jun 16 22:40:47 2012 SMON: enabling tx recovery Sat Jun 16 22:40:49 2012 Database Characterset is WE8MSWIN1252 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=16, OS id=2404 Sat Jun 16 22:41:14 2012 Completed: alter database open Sat Jun 16 22:41:16 2012 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. Sun Jun 17 08:47:02 2012 MMNL absent for 30452 secs; Foregrounds taking over Dump file c:\oracle\product\10.2.0\admin\scott\bdump\alert_scott.log Sun Jun 17 13:20:01 2012 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows XP Version V5.1 Service Pack 3 CPU : 1 - type 586, 1 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:316M/511M, Ph+PgF:1098M/1246M, VA:1941M/2047M Sun Jun 17 13:20:01 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Sun Jun 17 13:20:11 2012 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.3.0. System parameters with non-default values: processes = 150 __shared_pool_size = 100663296 __large_pool_size = 4194304 __java_pool_size = 4194304 __streams_pool_size = 0 sga_target = 167772160 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL03.CTL db_block_size = 8192 __db_cache_size = 54525952 compatible = 10.2.0.3.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0\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=scottXDB) job_queue_processes = 10 audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\SCOTT\CDUMP db_name = scott open_cursors = 300 pga_aggregate_target = 16777216 PMON started with pid=2, OS id=272 PSP0 started with pid=3, OS id=592 MMAN started with pid=4, OS id=1148 DBW0 started with pid=5, OS id=1472 LGWR started with pid=6, OS id=1904 CKPT started with pid=7, OS id=1940 SMON started with pid=8, OS id=468 RECO started with pid=9, OS id=1100 CJQ0 started with pid=10, OS id=1408 MMON started with pid=11, OS id=1380 Sun Jun 17 13:20:22 2012 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=12, OS id=1304 Sun Jun 17 13:20:22 2012 starting up 1 shared server(s) ... Sun Jun 17 13:20:28 2012 alter database mount exclusive Sun Jun 17 13:20:34 2012 Setting recovery target incarnation to 2 Sun Jun 17 13:20:34 2012 Successful mount of redo thread 1, with mount id 577418524 Sun Jun 17 13:20:34 2012 Database mounted in Exclusive Mode Completed: alter database mount exclusive Sun Jun 17 13:20:34 2012 alter database open Sun Jun 17 13:20:35 2012 Beginning crash recovery of 1 threads Sun Jun 17 13:20:36 2012 Started redo scan Sun Jun 17 13:20:38 2012 Completed redo scan 144 redo blocks read, 46 data blocks need recovery Sun Jun 17 13:20:38 2012 Started redo application at Thread 1: logseq 8, block 29985 Sun Jun 17 13:20:40 2012 Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0 Mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO01.LOG Sun Jun 17 13:20:41 2012 Completed redo application Sun Jun 17 13:20:42 2012 Completed crash recovery at Thread 1: logseq 8, block 30129, scn 700743 46 data blocks read, 46 data blocks written, 144 redo blocks read Sun Jun 17 13:20:46 2012 Thread 1 advanced to log sequence 9 Thread 1 opened at log sequence 9 Current log# 2 seq# 9 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\REDO02.LOG Successful open of redo thread 1 Sun Jun 17 13:20:46 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Jun 17 13:20:47 2012 SMON: enabling cache recovery Sun Jun 17 13:20:58 2012 Successfully onlined Undo Tablespace 1. Sun Jun 17 13:20:58 2012 SMON: enabling tx recovery Sun Jun 17 13:21:00 2012 Database Characterset is WE8MSWIN1252 replication_dependency_tracking turned off (no async multimaster replication found) Sun Jun 17 13:21:10 2012 Starting background process QMNC QMNC started with pid=16, OS id=2684 Sun Jun 17 13:21:44 2012 Completed: alter database open Sun Jun 17 13:21:51 2012 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. Mon Jun 18 21:19:17 2012 MMNL absent for 102695 secs; Foregrounds taking over Tue Jun 19 10:21:28 2012 MMNL absent for 34776 secs; Foregrounds taking over Tue Jun 19 10:57:36 2012 MMNL absent for 1817 secs; Foregrounds taking over