Ocm Manual Create Database Alert Log
Wed Apr 1 14:35:00 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 1 Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/oracle/oracle/product/10.2.0/db_1/dbs/arch Autotune of undo retention is turned on. IMODE=BR ILAT =10 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.1.0. System parameters with non-default values: __shared_pool_size = 88080384 __large_pool_size = 4194304 __java_pool_size = 4194304 __streams_pool_size = 0 sga_target = 314572800 control_files = /u01/oracle/oracle/oradata/prod/control01.ora, /u01/oracle/oracle/oradata/prod/control02.ora db_block_size = 4096 __db_cache_size = 213909504 log_buffer = 2104320 undo_management = AUTO undo_tablespace = UNDOTBS db_name = prod PMON started with pid=2, OS id=8938 PSP0 started with pid=3, OS id=8940 MMAN started with pid=4, OS id=8942 DBW0 started with pid=5, OS id=8944 LGWR started with pid=6, OS id=8946 CKPT started with pid=7, OS id=8948 SMON started with pid=8, OS id=8950 RECO started with pid=9, OS id=8952 MMON started with pid=10, OS id=8954 MMNL started with pid=11, OS id=8957 Wed Apr 1 14:36:51 2009 CREATE DATABASE prod CONTROLFILE REUSE USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILE GROUP 1 ('/u01/oracle/oracle/oradata/prod/redo01.log') SIZE 10M REUSE, GROUP 2 ('/u01/oracle/oracle/oradata/prod/redo02.log') SIZE 10M REUSE, GROUP 3 ('/u01/oracle/oracle/oradata/prod/redo03.log') SIZE 10M REUSE MAXLOGFILES 50 MAXLOGMEMBERS 5 MAXLOGHISTORY 100 MAXDATAFILES 500 MAXINSTANCES 5 CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 DATAFILE '/u01/oracle/oracle/oradata/prod/system01.dbf' SIZE 325M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/u01/oracle/oracle/oradata/prod/sysaux01.dbf' SIZE 325M REUSE DEFAULT TABLESPACE users DATAFILE '/u01/oracle/oracle/oradata/prod/users01.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/oracle/oracle/oradata/prod/temp01.dbf' SIZE 20M AUTOEXTEND ON NEXT 10M UNDO TABLESPACE undotbs DATAFILE '/u01/oracle/oracle/oradata/prod/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED Wed Apr 1 14:36:52 2009 Database mounted in Exclusive Mode Wed Apr 1 14:36:54 2009 Successful mount of redo thread 1, with mount id 94859395 Assigning activation ID 94859395 (0x5a77083) Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /u01/oracle/oracle/oradata/prod/redo01.log Successful open of redo thread 1 Wed Apr 1 14:36:54 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Apr 1 14:36:54 2009 SMON: enabling cache recovery Wed Apr 1 14:36:54 2009 create tablespace SYSTEM datafile '/u01/oracle/oracle/oradata/prod/system01.dbf' SIZE 325M REUSE EXTENT MANAGEMENT LOCAL online Wed Apr 1 14:37:07 2009 Completed: create tablespace SYSTEM datafile '/u01/oracle/oracle/oradata/prod/system01.dbf' SIZE 325M REUSE EXTENT MANAGEMENT LOCAL online Wed Apr 1 14:37:07 2009 create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K) Completed: create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K) Wed Apr 1 14:37:12 2009 Thread 1 advanced to log sequence 2 Current log# 2 seq# 2 mem# 0: /u01/oracle/oracle/oradata/prod/redo02.log Wed Apr 1 14:37:12 2009 CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/u01/oracle/oracle/oradata/prod/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED Wed Apr 1 14:37:20 2009 Successfully onlined Undo Tablespace 1. Completed: CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/u01/oracle/oracle/oradata/prod/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED Wed Apr 1 14:37:20 2009 create tablespace SYSAUX datafile '/u01/oracle/oracle/oradata/prod/sysaux01.dbf' SIZE 325M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online Wed Apr 1 14:37:33 2009 Completed: create tablespace SYSAUX datafile '/u01/oracle/oracle/oradata/prod/sysaux01.dbf' SIZE 325M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online Wed Apr 1 14:37:33 2009 CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oracle/oracle/oradata/prod/temp01.dbf' SIZE 20M AUTOEXTEND ON NEXT 10M Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oracle/oracle/oradata/prod/temp01.dbf' SIZE 20M AUTOEXTEND ON NEXT 10M Wed Apr 1 14:37:33 2009 ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP Wed Apr 1 14:37:33 2009 CREATE TABLESPACE USERS DATAFILE '/u01/oracle/oracle/oradata/prod/users01.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M SEGMENT SPACE MANAGEMENT MANUAL Completed: CREATE TABLESPACE USERS DATAFILE '/u01/oracle/oracle/oradata/prod/users01.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M SEGMENT SPACE MANAGEMENT MANUAL Wed Apr 1 14:37:34 2009 ALTER DATABASE DEFAULT TABLESPACE USERS Completed: ALTER DATABASE DEFAULT TABLESPACE USERS Wed Apr 1 14:37:36 2009 SMON: enabling tx recovery Wed Apr 1 14:37:38 2009 Threshold validation cannot be done before catproc is loaded. replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=13, OS id=9181 Wed Apr 1 14:37:38 2009 Completed: CREATE DATABASE prod CONTROLFILE REUSE USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILE GROUP 1 ('/u01/oracle/oracle/oradata/prod/redo01.log') SIZE 10M REUSE, GROUP 2 ('/u01/oracle/oracle/oradata/prod/redo02.log') SIZE 10M REUSE, GROUP 3 ('/u01/oracle/oracle/oradata/prod/redo03.log') SIZE 10M REUSE MAXLOGFILES 50 MAXLOGMEMBERS 5 MAXLOGHISTORY 100 MAXDATAFILES 500 MAXINSTANCES 5 CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 DATAFILE '/u01/oracle/oracle/oradata/prod/system01.dbf' SIZE 325M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/u01/oracle/oracle/oradata/prod/sysaux01.dbf' SIZE 325M REUSE DEFAULT TABLESPACE users DATAFILE '/u01/oracle/oracle/oradata/prod/users01.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/oracle/oracle/oradata/prod/temp01.dbf' SIZE 20M AUTOEXTEND ON NEXT 10M UNDO TABLESPACE undotbs DATAFILE '/u01/oracle/oracle/oradata/prod/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED