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