=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2008.01.27 21:24:36 =~=~=~=~=~=~=~=~=~=~=~= cat alert_SAPRD.log Sun Jan 27 18:30:08 2008 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 83886080 large_pool_size = 16777216 java_pool_size = 83886080 control_files = /PROD_dbsys/database/SAPRD/ctrl/control01.ctl, /PROD_dbsys/database/SAPRD/ctrl/control02.ctl, /PROD_dbsys/database/SAPRD/ctrl/control03.ctl db_block_size = 8192 db_cache_size = 33554432 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 db_domain = instance_name = SAPRD dispatchers = (PROTOCOL=TCP) (SERVICE=SAPRDXDB) utl_file_dir = * hash_join_enabled = TRUE background_dump_dest = /PROD_dbsys/database/SAPRD/trace/bdump user_dump_dest = /PROD_dbsys/database/SAPRD/trace/udump core_dump_dest = /PROD_dbsys/database/SAPRD/trace/cdump sort_area_size = 524288 db_name = SAPRD open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 25165824 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Sun Jan 27 18:30:09 2008 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Sun Jan 27 18:30:23 2008 CREATE DATABASE SAPRD MAXINSTANCES 1 MAXLOGHISTORY 1 MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/PROD_dbsys/database/SAPRD/data/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/PROD_dbsys/database/SAPRD/data/temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED UNDO TABLESPACE "UNDOTBS1" DATAFILE '/PROD_dbsys/database/SAPRD/data/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET WE8ISO8859P1 NATIONAL CHARACTER SET AL16UTF16 LOGFILE GROUP 1 ('/oracle/database/SAPRD/redo/redo01.log') SIZE 102400K, GROUP 2 ('/oracle/database/SAPRD/redo/redo02.log') SIZE 102400K, GROUP 3 ('/oracle/database/SAPRD/redo/redo03.log') SIZE 102400K Sun Jan 27 18:30:23 2008 Database mounted in Exclusive Mode. Sun Jan 27 18:30:41 2008 Successful mount of redo thread 1, with mount id 4285489215. Assigning activation ID 4285489215 (0xff6f603f) Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /oracle/database/SAPRD/redo/redo01.log Successful open of redo thread 1. Sun Jan 27 18:30:41 2008 WARNING: Default passwords for SYS and SYSTEM will be used. Sun Jan 27 18:30:41 2008 SMON: enabling cache recovery Please change the passwords. Sun Jan 27 18:30:41 2008 create tablespace SYSTEM datafile '/PROD_dbsys/database/SAPRD/data/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL online Completed: create tablespace SYSTEM datafile '/PROD_dbsys/da Sun Jan 27 18:30:48 2008 create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K) Completed: create rollback segment SYSTEM tablespace SYSTEM Sun Jan 27 18:30:52 2008 CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/PROD_dbsys/database/SAPRD/data/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED Created Undo Segment _SYSSMU1$ Created Undo Segment _SYSSMU2$ Created Undo Segment _SYSSMU3$ Created Undo Segment _SYSSMU4$ Created Undo Segment _SYSSMU5$ Created Undo Segment _SYSSMU6$ Created Undo Segment _SYSSMU7$ Created Undo Segment _SYSSMU8$ Created Undo Segment _SYSSMU9$ Created Undo Segment _SYSSMU10$ Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/PROD_d Sun Jan 27 18:30:57 2008 CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '/PROD_dbsys/database/SAPRD/data/temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '/PROD_ Sun Jan 27 18:30:57 2008 ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP Sun Jan 27 18:30:58 2008 SMON: enabling tx recovery Sun Jan 27 18:31:12 2008 replication_dependency_tracking turned off (no async multimaster replication found) Completed: CREATE DATABASE SAPRD MAXINSTANCES 1 MAXLOGHISTORY Sun Jan 27 18:32:23 2008 Shutting down instance: further logons disabled Shutting down instance (normal) License high water mark = 1 Waiting for dispatcher 'D000' to shutdown All dispatchers and shared servers shutdown Sun Jan 27 18:32:25 2008 ALTER DATABASE CLOSE NORMAL Sun Jan 27 18:32:25 2008 SMON: disabling tx recovery SMON: disabling cache recovery Sun Jan 27 18:32:25 2008 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. Sun Jan 27 18:32:26 2008 Completed: ALTER DATABASE CLOSE NORMAL Sun Jan 27 18:32:26 2008 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sun Jan 27 18:33:03 2008 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 83886080 large_pool_size = 16777216 java_pool_size = 83886080 control_files = /PROD_dbsys/database/SAPRD/ctrl/control01.ctl, /PROD_dbsys/database/SAPRD/ctrl/control02.ctl, /PROD_dbsys/database/SAPRD/ctrl/control03.ctl db_block_size = 8192 db_cache_size = 33554432 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 db_domain = instance_name = SAPRD dispatchers = (PROTOCOL=TCP) (SERVICE=SAPRDXDB) utl_file_dir = * hash_join_enabled = TRUE background_dump_dest = /PROD_dbsys/database/SAPRD/trace/bdump user_dump_dest = /PROD_dbsys/database/SAPRD/trace/udump core_dump_dest = /PROD_dbsys/database/SAPRD/trace/cdump sort_area_size = 524288 db_name = SAPRD open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 25165824 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Sun Jan 27 18:33:03 2008 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Sun Jan 27 18:33:03 2008 ALTER DATABASE MOUNT Sun Jan 27 18:33:07 2008 Successful mount of redo thread 1, with mount id 4285446879. Sun Jan 27 18:33:07 2008 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sun Jan 27 18:33:07 2008 ALTER DATABASE OPEN Sun Jan 27 18:33:07 2008 Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /oracle/database/SAPRD/redo/redo01.log Successful open of redo thread 1. Sun Jan 27 18:33:07 2008 SMON: enabling cache recovery Sun Jan 27 18:33:08 2008 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Sun Jan 27 18:33:08 2008 SMON: enabling tx recovery Sun Jan 27 18:33:08 2008 Database Characterset is WE8ISO8859P1 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN Sun Jan 27 19:16:43 2008 Thread 1 advanced to log sequence 2 Current log# 2 seq# 2 mem# 0: /oracle/database/SAPRD/redo/redo02.log Sun Jan 27 19:19:33 2008 Thread 1 advanced to log sequence 3 Current log# 3 seq# 3 mem# 0: /oracle/database/SAPRD/redo/redo03.log Sun Jan 27 19:26:01 2008 Shutting down instance: further logons disabled Sun Jan 27 19:26:15 2008 Shutting down instance (normal) License high water mark = 1 Waiting for dispatcher 'D000' to shutdown All dispatchers and shared servers shutdown Sun Jan 27 19:26:17 2008 ALTER DATABASE CLOSE NORMAL Sun Jan 27 19:26:17 2008 SMON: disabling tx recovery SMON: disabling cache recovery Sun Jan 27 19:26:17 2008 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 3 Successful close of redo thread 1. Sun Jan 27 19:26:17 2008 Completed: ALTER DATABASE CLOSE NORMAL Sun Jan 27 19:26:17 2008 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sun Jan 27 19:26:51 2008 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 83886080 large_pool_size = 16777216 java_pool_size = 83886080 control_files = /PROD_dbsys/database/SAPRD/ctrl/control01.ctl, /PROD_dbsys/database/SAPRD/ctrl/control02.ctl, /PROD_dbsys/database/SAPRD/ctrl/control03.ctl db_block_size = 8192 db_cache_size = 33554432 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 db_domain = instance_name = SAPRD dispatchers = (PROTOCOL=TCP) (SERVICE=SAPRDXDB) utl_file_dir = * hash_join_enabled = TRUE background_dump_dest = /PROD_dbsys/database/SAPRD/trace/bdump user_dump_dest = /PROD_dbsys/database/SAPRD/trace/udump core_dump_dest = /PROD_dbsys/database/SAPRD/trace/cdump sort_area_size = 524288 db_name = SAPRD open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 25165824 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Sun Jan 27 19:26:52 2008 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Sun Jan 27 19:26:52 2008 ALTER DATABASE MOUNT Sun Jan 27 19:26:56 2008 Successful mount of redo thread 1, with mount id 4285499004. Sun Jan 27 19:26:56 2008 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sun Jan 27 19:26:56 2008 ALTER DATABASE OPEN Sun Jan 27 19:26:56 2008 Thread 1 opened at log sequence 3 Current log# 3 seq# 3 mem# 0: /oracle/database/SAPRD/redo/redo03.log Successful open of redo thread 1. Sun Jan 27 19:26:56 2008 SMON: enabling cache recovery Sun Jan 27 19:26:56 2008 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Sun Jan 27 19:26:56 2008 SMON: enabling tx recovery Sun Jan 27 19:26:56 2008 Database Characterset is WE8ISO8859P1 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN Sun Jan 27 19:29:07 2008 create tablespace sa_data datafile '/PROD_dbmain/database/SAPRD/data/SA_DATA_01.dbf' size 6291456k online permanent extent management local uniform size 256k Sun Jan 27 19:29:07 2008 ORA-1119 signalled during: create tablespace sa_data datafile '/PROD_dbmain/d... Sun Jan 27 19:34:15 2008 create tablespace sa_data datafile 'PROD_dbmain/database/SAPRD/data/SA_DATA_01.DBF' SIZE 6291456k extent management local uniform size 256k Sun Jan 27 19:34:15 2008 ORA-1119 signalled during: create tablespace sa_data datafile 'PROD_dbmain/da... Sun Jan 27 19:35:14 2008 create tablespace sa_data datafile '/PROD_dbmain/database/SAPRD/data/SA_DATA_01.DBF' size 1024M extent management local uniform size 256k Sun Jan 27 19:35:32 2008 Completed: create tablespace sa_data datafile '/PROD_dbmain/d Sun Jan 27 19:58:43 2008 create tablespace bsp_data datafile '/PROD_dbdata/database/SAPRD/data/bsp_data01.dbf' size 1548288 k, '/PROD_dbdata/database/SAPRD/data/BSP_DATA_02.DBF' SIZE 2097152 K online permanent extent management local uniform size 64 k Sun Jan 27 19:59:02 2008 Errors in file /PROD_dbsys/database/SAPRD/trace/bdump/saprd_pmon_6634.trc: ORA-00471: DBWR process terminated with error Sun Jan 27 19:59:02 2008 PMON: terminating instance due to error 471 Instance terminated by PMON, pid = 6634 Sun Jan 27 20:00:27 2008 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 83886080 large_pool_size = 16777216 java_pool_size = 83886080 control_files = /PROD_dbsys/database/SAPRD/ctrl/control01.ctl, /PROD_dbsys/database/SAPRD/ctrl/control02.ctl, /PROD_dbsys/database/SAPRD/ctrl/control03.ctl db_block_size = 8192 db_cache_size = 33554432 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 db_domain = instance_name = SAPRD dispatchers = (PROTOCOL=TCP) (SERVICE=SAPRDXDB) utl_file_dir = * hash_join_enabled = TRUE background_dump_dest = /PROD_dbsys/database/SAPRD/trace/bdump user_dump_dest = /PROD_dbsys/database/SAPRD/trace/udump core_dump_dest = /PROD_dbsys/database/SAPRD/trace/cdump sort_area_size = 524288 db_name = SAPRD open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 25165824 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Sun Jan 27 20:00:27 2008 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Sun Jan 27 20:00:27 2008 ALTER DATABASE MOUNT Sun Jan 27 20:00:31 2008 Successful mount of redo thread 1, with mount id 4285481563. Sun Jan 27 20:00:31 2008 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sun Jan 27 20:00:31 2008 ALTER DATABASE OPEN Sun Jan 27 20:00:31 2008 Beginning crash recovery of 1 threads Sun Jan 27 20:00:31 2008 Started first pass scan Sun Jan 27 20:00:31 2008 Completed first pass scan 49 redo blocks read, 23 data blocks need recovery Sun Jan 27 20:00:31 2008 Started recovery at Thread 1: logseq 3, block 122001, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0 Mem# 0 errs 0: /oracle/database/SAPRD/redo/redo03.log Sun Jan 27 20:00:32 2008 Completed redo application Sun Jan 27 20:00:32 2008 Ended recovery at Thread 1: logseq 3, block 122050, scn 0.79464 23 data blocks read, 23 data blocks written, 49 redo blocks read Crash recovery completed successfully Sun Jan 27 20:00:32 2008 Thread 1 advanced to log sequence 4 Thread 1 opened at log sequence 4 Current log# 1 seq# 4 mem# 0: /oracle/database/SAPRD/redo/redo01.log Successful open of redo thread 1. Sun Jan 27 20:00:32 2008 SMON: enabling cache recovery Sun Jan 27 20:00:32 2008 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Sun Jan 27 20:00:32 2008 SMON: enabling tx recovery Sun Jan 27 20:00:32 2008 Database Characterset is WE8ISO8859P1 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN Sun Jan 27 20:01:46 2008 create tablespace bsp_data datafile '/PROD_dbdata/database/SAPRD/data/BSP_DATA_01.DBF' size 1024m Sun Jan 27 20:06:29 2008 create tablespace bsp_data datafile '/PROD_dbmain/database/SAPRD/data/bsp_data_01.dbf' size 1024m Sun Jan 27 20:06:43 2008 Errors in file /PROD_dbsys/database/SAPRD/trace/bdump/saprd_pmon_6689.trc: ORA-00470: LGWR process terminated with error Sun Jan 27 20:06:43 2008 PMON: terminating instance due to error 470 Instance terminated by PMON, pid = 6689 Sun Jan 27 20:07:13 2008 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 83886080 large_pool_size = 16777216 java_pool_size = 83886080 control_files = /PROD_dbsys/database/SAPRD/ctrl/control01.ctl, /PROD_dbsys/database/SAPRD/ctrl/control02.ctl, /PROD_dbsys/database/SAPRD/ctrl/control03.ctl db_block_size = 8192 db_cache_size = 33554432 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 db_domain = instance_name = SAPRD dispatchers = (PROTOCOL=TCP) (SERVICE=SAPRDXDB) utl_file_dir = * hash_join_enabled = TRUE background_dump_dest = /PROD_dbsys/database/SAPRD/trace/bdump user_dump_dest = /PROD_dbsys/database/SAPRD/trace/udump core_dump_dest = /PROD_dbsys/database/SAPRD/trace/cdump sort_area_size = 524288 db_name = SAPRD open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 25165824 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Sun Jan 27 20:07:13 2008 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Sun Jan 27 20:07:13 2008 ALTER DATABASE MOUNT Sun Jan 27 20:07:18 2008 Successful mount of redo thread 1, with mount id 4285500145. Sun Jan 27 20:07:18 2008 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sun Jan 27 20:07:18 2008 ALTER DATABASE OPEN Sun Jan 27 20:07:18 2008 Beginning crash recovery of 1 threads Sun Jan 27 20:07:18 2008 Started first pass scan Sun Jan 27 20:07:18 2008 Completed first pass scan 94 redo blocks read, 47 data blocks need recovery Sun Jan 27 20:07:18 2008 Started recovery at Thread 1: logseq 4, block 3, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0 Mem# 0 errs 0: /oracle/database/SAPRD/redo/redo01.log Sun Jan 27 20:07:18 2008 Completed redo application Sun Jan 27 20:07:18 2008 Ended recovery at Thread 1: logseq 4, block 97, scn 0.99660 47 data blocks read, 47 data blocks written, 94 redo blocks read Crash recovery completed successfully Sun Jan 27 20:07:19 2008 Thread 1 advanced to log sequence 5 Thread 1 opened at log sequence 5 Current log# 2 seq# 5 mem# 0: /oracle/database/SAPRD/redo/redo02.log Successful open of redo thread 1. Sun Jan 27 20:07:19 2008 SMON: enabling cache recovery Sun Jan 27 20:07:19 2008 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Sun Jan 27 20:07:19 2008 SMON: enabling tx recovery Sun Jan 27 20:07:19 2008 Database Characterset is WE8ISO8859P1 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN Sun Jan 27 20:07:19 2008 Deleted file /PROD_dbmain/database/SAPRD/data/bsp_data_01.dbf Sun Jan 27 20:07:30 2008 Shutting down instance: further logons disabled Shutting down instance (normal) License high water mark = 1 Waiting for dispatcher 'D000' to shutdown All dispatchers and shared servers shutdown Sun Jan 27 20:07:32 2008 ALTER DATABASE CLOSE NORMAL Sun Jan 27 20:07:32 2008 SMON: disabling tx recovery SMON: disabling cache recovery Sun Jan 27 20:07:32 2008 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 5 Successful close of redo thread 1. Sun Jan 27 20:07:33 2008 Completed: ALTER DATABASE CLOSE NORMAL Sun Jan 27 20:07:33 2008 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sun Jan 27 20:07:39 2008 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 83886080 large_pool_size = 16777216 java_pool_size = 83886080 control_files = /PROD_dbsys/database/SAPRD/ctrl/control01.ctl, /PROD_dbsys/database/SAPRD/ctrl/control02.ctl, /PROD_dbsys/database/SAPRD/ctrl/control03.ctl db_block_size = 8192 db_cache_size = 33554432 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 db_domain = instance_name = SAPRD dispatchers = (PROTOCOL=TCP) (SERVICE=SAPRDXDB) utl_file_dir = * hash_join_enabled = TRUE background_dump_dest = /PROD_dbsys/database/SAPRD/trace/bdump user_dump_dest = /PROD_dbsys/database/SAPRD/trace/udump core_dump_dest = /PROD_dbsys/database/SAPRD/trace/cdump sort_area_size = 524288 db_name = SAPRD open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 25165824 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Sun Jan 27 20:07:40 2008 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Sun Jan 27 20:07:40 2008 ALTER DATABASE MOUNT Sun Jan 27 20:07:44 2008 Successful mount of redo thread 1, with mount id 4285483532. Sun Jan 27 20:07:44 2008 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sun Jan 27 20:07:44 2008 ALTER DATABASE OPEN Sun Jan 27 20:07:44 2008 Thread 1 opened at log sequence 5 Current log# 2 seq# 5 mem# 0: /oracle/database/SAPRD/redo/redo02.log Successful open of redo thread 1. Sun Jan 27 20:07:44 2008 SMON: enabling cache recovery Sun Jan 27 20:07:44 2008 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Sun Jan 27 20:07:44 2008 SMON: enabling tx recovery Sun Jan 27 20:07:44 2008 Database Characterset is WE8ISO8859P1 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN Sun Jan 27 20:14:33 2008 Shutting down instance: further logons disabled Shutting down instance (normal) License high water mark = 1 Waiting for dispatcher 'D000' to shutdown All dispatchers and shared servers shutdown Sun Jan 27 20:14:35 2008 ALTER DATABASE CLOSE NORMAL Sun Jan 27 20:14:35 2008 SMON: disabling tx recovery SMON: disabling cache recovery Sun Jan 27 20:14:35 2008 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 5 Successful close of redo thread 1. Sun Jan 27 20:14:36 2008 Completed: ALTER DATABASE CLOSE NORMAL Sun Jan 27 20:14:36 2008 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ]0;oracle9@saprod:/PROD_dbsys/database/SAPRD/trace/bdump[oracle9@saprod bdump]$