error dep

Sun Sep 22 00:02:51 2013
Starting ORACLE instance (normal)
Sun Sep 22 00:05:47 2013
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_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in client-side pfile /oracle/app/oracle/admin/post/pfile/init.ora on machine newmac
System parameters with non-default values:
  processes                = 150
  memory_target            = 592M
  control_files            = "/oracle/app/oracle/oradata/post/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/post/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=postXDB)"
  local_listener           = "LISTENER_POST"
  audit_file_dest          = "/oracle/app/oracle/admin/post/adump"
  audit_trail              = "DB"
  db_name                  = "post"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Sun Sep 22 00:06:04 2013
PMON started with pid=2, OS id=30807 
Sun Sep 22 00:06:06 2013
VKTM started with pid=3, OS id=30809 
VKTM running at (100ms) precision 
Sun Sep 22 00:06:10 2013
GEN0 started with pid=4, OS id=30813 
Sun Sep 22 00:06:13 2013
DBRM started with pid=6, OS id=30817 
Sun Sep 22 00:06:14 2013
DIAG started with pid=5, OS id=30815 
Sun Sep 22 00:06:16 2013
DIA0 started with pid=8, OS id=30828 
Sun Sep 22 00:06:17 2013
PSP0 started with pid=7, OS id=30821 
Sun Sep 22 00:06:18 2013
MMAN started with pid=9, OS id=30830 
Sun Sep 22 00:06:24 2013
LGWR started with pid=11, OS id=30840 
Sun Sep 22 00:06:23 2013
DBW0 started with pid=10, OS id=30838 
Sun Sep 22 00:06:25 2013
CKPT started with pid=12, OS id=30842 
Sun Sep 22 00:06:27 2013
SMON started with pid=13, OS id=30844 
Sun Sep 22 00:06:28 2013
RECO started with pid=14, OS id=30846 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Sep 22 00:06:30 2013
MMNL started with pid=16, OS id=30850 
Sun Sep 22 00:06:30 2013
MMON started with pid=15, OS id=30848 
Sun Sep 22 00:06:31 2013
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Sun Sep 22 00:09:41 2013
Full restore complete of datafile 4 to datafile copy /oracle/app/oracle/oradata/post/users01.dbf.  Elapsed time: 0:01:39 
  checkpoint is 754487
Full restore complete of datafile 3 to datafile copy /oracle/app/oracle/oradata/post/undotbs01.dbf.  Elapsed time: 0:01:52 
  checkpoint is 754487
Sun Sep 22 00:21:32 2013
Full restore complete of datafile 2 to datafile copy /oracle/app/oracle/oradata/post/sysaux01.dbf.  Elapsed time: 0:13:40 
  checkpoint is 754487
  last deallocation scn is 754293
Sun Sep 22 00:24:03 2013
Full restore complete of datafile 1 to datafile copy /oracle/app/oracle/oradata/post/system01.dbf.  Elapsed time: 0:16:43 
  checkpoint is 754487
  last deallocation scn is 749189
Sun Sep 22 00:24:36 2013
Create controlfile reuse set database "post"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/oracle/app/oracle/oradata/post/system01.dbf',
'/oracle/app/oracle/oradata/post/sysaux01.dbf',
'/oracle/app/oracle/oradata/post/undotbs01.dbf',
'/oracle/app/oracle/oradata/post/users01.dbf'
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/post/redo01.log') SIZE 51200K,
GROUP 2 ('/oracle/app/oracle/oradata/post/redo02.log') SIZE 51200K,
GROUP 3 ('/oracle/app/oracle/oradata/post/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
Sun Sep 22 00:24:41 2013
Successful mount of redo thread 1, with mount id 4292869828
Completed: Create controlfile reuse set database "post"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/oracle/app/oracle/oradata/post/system01.dbf',
'/oracle/app/oracle/oradata/post/sysaux01.dbf',
'/oracle/app/oracle/oradata/post/undotbs01.dbf',
'/oracle/app/oracle/oradata/post/users01.dbf'
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/post/redo01.log') SIZE 51200K,
GROUP 2 ('/oracle/app/oracle/oradata/post/redo02.log') SIZE 51200K,
GROUP 3 ('/oracle/app/oracle/oradata/post/redo03.log') SIZE 51200K RESETLOGS
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Sun Sep 22 00:24:48 2013
Stopping background process VKTM: 
Sun Sep 22 00:24:53 2013
Instance shutdown complete
Sun Sep 22 00:24:56 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in client-side pfile /oracle/app/oracle/cfgtoollogs/dbca/post/initpostTemp.ora on machine newmac
System parameters with non-default values:
  processes                = 150
  memory_target            = 592M
  control_files            = "/oracle/app/oracle/oradata/post/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/post/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  _no_recovery_through_resetlogs= TRUE
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=postXDB)"
  local_listener           = "LISTENER_POST"
  audit_file_dest          = "/oracle/app/oracle/admin/post/adump"
  audit_trail              = "DB"
  db_name                  = "post"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Sun Sep 22 00:25:15 2013
PMON started with pid=2, OS id=31195 
Sun Sep 22 00:25:15 2013
GEN0 started with pid=4, OS id=31201 
Sun Sep 22 00:25:16 2013
DIAG started with pid=5, OS id=31203 
Sun Sep 22 00:25:16 2013
VKTM started with pid=3, OS id=31197 
VKTM running at (100ms) precision 
Sun Sep 22 00:25:17 2013
PSP0 started with pid=7, OS id=31207 
Sun Sep 22 00:25:17 2013
DIA0 started with pid=8, OS id=31209 
Sun Sep 22 00:25:17 2013
DBRM started with pid=6, OS id=31205 
Sun Sep 22 00:25:17 2013
MMAN started with pid=9, OS id=31211 
Sun Sep 22 00:25:21 2013
LGWR started with pid=11, OS id=31215 
Sun Sep 22 00:25:22 2013
DBW0 started with pid=10, OS id=31213 
Sun Sep 22 00:25:23 2013
CKPT started with pid=12, OS id=31217 
Sun Sep 22 00:25:24 2013
RECO started with pid=14, OS id=31221 
Sun Sep 22 00:25:24 2013
MMON started with pid=15, OS id=31223 
Sun Sep 22 00:25:24 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Sep 22 00:25:24 2013
MMNL started with pid=16, OS id=31225 
Sun Sep 22 00:25:24 2013
SMON started with pid=13, OS id=31219 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Sun Sep 22 00:25:28 2013
Create controlfile reuse set database "post"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/oracle/app/oracle/oradata/post/system01.dbf',
'/oracle/app/oracle/oradata/post/sysaux01.dbf',
'/oracle/app/oracle/oradata/post/undotbs01.dbf',
'/oracle/app/oracle/oradata/post/users01.dbf'
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/post/redo01.log') SIZE 51200K,
GROUP 2 ('/oracle/app/oracle/oradata/post/redo02.log') SIZE 51200K,
GROUP 3 ('/oracle/app/oracle/oradata/post/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
Successful mount of redo thread 1, with mount id 4292874238
Completed: Create controlfile reuse set database "post"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/oracle/app/oracle/oradata/post/system01.dbf',
'/oracle/app/oracle/oradata/post/sysaux01.dbf',
'/oracle/app/oracle/oradata/post/undotbs01.dbf',
'/oracle/app/oracle/oradata/post/users01.dbf'
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/post/redo01.log') SIZE 51200K,
GROUP 2 ('/oracle/app/oracle/oradata/post/redo02.log') SIZE 51200K,
GROUP 3 ('/oracle/app/oracle/oradata/post/redo03.log') SIZE 51200K RESETLOGS
Stopping background process MMNL
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
ALTER SYSTEM enable restricted session;
Sun Sep 22 00:25:37 2013
MMNL started with pid=16, OS id=31262 
alter database "post" open resetlogs
Sun Sep 22 00:25:37 2013
MMON started with pid=15, OS id=31257 
RESETLOGS after incomplete recovery UNTIL CHANGE 754487
Errors in file /oracle/app/oracle/diag/rdbms/post/post/trace/post_ora_31232.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/app/oracle/oradata/post/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/post/post/trace/post_ora_31232.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/app/oracle/oradata/post/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/post/post/trace/post_ora_31232.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle/app/oracle/oradata/post/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/post/post/trace/post_ora_31232.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle/app/oracle/oradata/post/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Sun Sep 22 00:25:48 2013
Checker run found 5 new persistent data failures
Sun Sep 22 00:25:57 2013
Errors in file /oracle/app/oracle/diag/rdbms/post/post/trace/post_ora_31232.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle/app/oracle/oradata/post/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/post/post/trace/post_ora_31232.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle/app/oracle/oradata/post/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Sun Sep 22 00:26:12 2013
Setting recovery target incarnation to 2
Sun Sep 22 00:26:12 2013
Assigning activation ID 4292874238 (0xffe00ffe)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /oracle/app/oracle/oradata/post/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Sep 22 00:26:13 2013
SMON: enabling cache recovery
Sun Sep 22 00:26:17 2013
Successfully onlined Undo Tablespace 2.
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
*********************************************************************
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 <tablespace_name> ADD TEMPFILE
 
         Alternatively, if these temporary tablespaces are no longer
         needed, then they can be dropped.
           Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is US7ASCII
Create Relation IPS_PACKAGE_UNPACK_HISTORY
No Resource Manager plan active
**********************************************************
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.
If files cannot be cataloged, then manually delete them
using OS command.
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
Sun Sep 22 00:26:28 2013
QMNC started with pid=20, OS id=31312 
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Global Name changed to POST
Sun Sep 22 00:26:38 2013
Completed: alter database "post" open resetlogs
alter database rename global_name to "post"
Completed: alter database rename global_name to "post"
ALTER TABLESPACE TEMP ADD TEMPFILE '/oracle/app/oracle/oradata/post/temp01.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE '/oracle/app/oracle/oradata/post/temp01.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
alter database character set INTERNAL_CONVERT WE8MSWIN1252
Sun Sep 22 00:28:28 2013
Thread 1 advanced to log sequence 2 (LGWR switch)
  Current log# 2 seq# 2 mem# 0: /oracle/app/oracle/oradata/post/redo02.log
Sun Sep 22 00:29:08 2013
Updating character set in controlfile to WE8MSWIN1252
Synchronizing connection with database character set information
Refreshing type attributes with new character set information
Sun Sep 22 00:29:32 2013
Starting background process SMCO
Sun Sep 22 00:29:32 2013
SMCO started with pid=24, OS id=31369 
Sun Sep 22 00:29:33 2013
Completed: alter database character set INTERNAL_CONVERT WE8MSWIN1252
Sun Sep 22 00:29:40 2013
ALTER SYSTEM disable restricted session;
Sun Sep 22 00:30:04 2013
Starting background process CJQ0
Sun Sep 22 00:30:04 2013
CJQ0 started with pid=32, OS id=31412 
Sun Sep 22 00:30:04 2013
db_recovery_file_dest_size of 3852 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 Sep 22 00:31:20 2013
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Sun Sep 22 00:31:50 2013
Stopping background process CJQ0
Sun Sep 22 00:31:50 2013
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 6
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Sun Sep 22 00:31:56 2013
SMON: disabling tx recovery
SMON: disabling cache recovery
Sun Sep 22 00:31:57 2013
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
Completed: ALTER DATABASE CLOSE NORMAL
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
Sun Sep 22 00:32:00 2013
Stopping background process VKTM: 
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun Sep 22 00:32:05 2013
Instance shutdown complete
Sun Sep 22 00:32:07 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/db/dbs/spfilepost.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 592M
  control_files            = "/oracle/app/oracle/oradata/post/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/post/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=postXDB)"
  local_listener           = "LISTENER_POST"
  audit_file_dest          = "/oracle/app/oracle/admin/post/adump"
  audit_trail              = "DB"
  db_name                  = "post"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Sun Sep 22 00:32:22 2013
PMON started with pid=2, OS id=31518 
Sun Sep 22 00:32:22 2013
VKTM started with pid=3, OS id=31520 
VKTM running at (100ms) precision 
Sun Sep 22 00:32:23 2013
DIAG started with pid=5, OS id=31526 
Sun Sep 22 00:32:23 2013
GEN0 started with pid=4, OS id=31524 
Sun Sep 22 00:32:24 2013
DBRM started with pid=6, OS id=31528 
Sun Sep 22 00:32:24 2013
PSP0 started with pid=7, OS id=31530 
Sun Sep 22 00:32:25 2013
DIA0 started with pid=8, OS id=31532 
Sun Sep 22 00:32:25 2013
MMAN started with pid=9, OS id=31534 
Sun Sep 22 00:32:26 2013
DBW0 started with pid=10, OS id=31536 
Sun Sep 22 00:32:26 2013
LGWR started with pid=11, OS id=31538 
Sun Sep 22 00:32:26 2013
CKPT started with pid=12, OS id=31540 
Sun Sep 22 00:32:27 2013
SMON started with pid=13, OS id=31542 
Sun Sep 22 00:32:27 2013
MMON started with pid=15, OS id=31546 
Sun Sep 22 00:32:27 2013
RECO started with pid=14, OS id=31544 
Sun Sep 22 00:32:27 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Sep 22 00:32:27 2013
MMNL started with pid=16, OS id=31548 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Sun Sep 22 00:32:29 2013
ALTER DATABASE   MOUNT
Changing di2dbun from  to post
Successful mount of redo thread 1, with mount id 4292844449
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Sun Sep 22 00:32:43 2013
ALTER DATABASE OPEN
Sun Sep 22 00:32:44 2013
Thread 1 opened at log sequence 2
  Current log# 2 seq# 2 mem# 0: /oracle/app/oracle/oradata/post/redo02.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
Sun Sep 22 00:32:45 2013
SMON: enabling cache recovery
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Completed: ALTER DATABASE OPEN
Sun Sep 22 00:32:52 2013
QMNC started with pid=20, OS id=31615 
Starting background process SMCO
Sun Sep 22 00:32:57 2013
SMCO started with pid=22, OS id=31622 
Sun Sep 22 00:33:01 2013
Starting background process CJQ0
Sun Sep 22 00:33:01 2013
CJQ0 started with pid=24, OS id=31644 
Sun Sep 22 00:33:02 2013
db_recovery_file_dest_size of 3852 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 Sep 22 06:00:01 2013
Setting Resource Manager plan SCHEDULER[0x3009]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sun Sep 22 06:00:02 2013
Starting background process VKRM
Sun Sep 22 06:00:02 2013
VKRM started with pid=25, OS id=9143 
Sun Sep 22 06:00:52 2013
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Sun Sep 22 06:01:33 2013
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Sun Sep 22 06:03:35 2013
Thread 1 cannot allocate new log, sequence 3
Private strand flush not complete
  Current log# 2 seq# 2 mem# 0: /oracle/app/oracle/oradata/post/redo02.log
Thread 1 advanced to log sequence 3 (LGWR switch)
  Current log# 3 seq# 3 mem# 0: /oracle/app/oracle/oradata/post/redo03.log
Sun Sep 22 13:34:22 2013
Starting ORACLE instance (normal)
Sun Sep 22 13:59:51 2013
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Sun Sep 22 13:59:55 2013
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 5
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Sun Sep 22 14:00:12 2013
SMON: disabling tx recovery
SMON: disabling cache recovery
Sun Sep 22 14:00:17 2013
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
Completed: ALTER DATABASE CLOSE NORMAL
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
Sun Sep 22 14:00:39 2013
Stopping background process VKTM: 
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun Sep 22 14:01:33 2013
Instance shutdown complete
Mon Sep 23 05:20:07 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/db/dbs/spfilepost.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 592M
  control_files            = "/oracle/app/oracle/oradata/post/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/post/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=postXDB)"
  local_listener           = "LISTENER_POST"
  audit_file_dest          = "/oracle/app/oracle/admin/post/adump"
  audit_trail              = "DB"
  db_name                  = "post"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Mon Sep 23 05:20:15 2013
PMON started with pid=2, OS id=5535 
Mon Sep 23 05:20:15 2013
VKTM started with pid=3, OS id=5537 
VKTM running at (100ms) precision 
Mon Sep 23 05:20:15 2013
GEN0 started with pid=4, OS id=5541 
Mon Sep 23 05:20:15 2013
DIAG started with pid=5, OS id=5543 
Mon Sep 23 05:20:15 2013
DBRM started with pid=6, OS id=5545 
Mon Sep 23 05:20:15 2013
PSP0 started with pid=7, OS id=5547 
Mon Sep 23 05:20:15 2013
DIA0 started with pid=8, OS id=5549 
Mon Sep 23 05:20:15 2013
MMAN started with pid=9, OS id=5551 
Mon Sep 23 05:20:16 2013
DBW0 started with pid=10, OS id=5553 
Mon Sep 23 05:20:16 2013
LGWR started with pid=11, OS id=5555 
Mon Sep 23 05:20:16 2013
CKPT started with pid=12, OS id=5557 
Mon Sep 23 05:20:16 2013
SMON started with pid=13, OS id=5559 
Mon Sep 23 05:20:16 2013
RECO started with pid=14, OS id=5561 
Mon Sep 23 05:20:16 2013
MMON started with pid=15, OS id=5563 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Sep 23 05:20:16 2013
MMNL started with pid=16, OS id=5565 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Mon Sep 23 05:20:17 2013
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 4292958867
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 23 05:21:15 2013
ALTER DATABASE OPEN
Thread 1 opened at log sequence 3
  Current log# 3 seq# 3 mem# 0: /oracle/app/oracle/oradata/post/redo03.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Mon Sep 23 05:21:25 2013
QMNC started with pid=20, OS id=5640 
Completed: ALTER DATABASE OPEN
Mon Sep 23 05:21:35 2013
db_recovery_file_dest_size of 3852 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 Sep 23 05:21:36 2013
Starting background process CJQ0
Mon Sep 23 05:21:36 2013
CJQ0 started with pid=25, OS id=5656 
Mon Sep 23 05:26:28 2013
Starting background process SMCO
Mon Sep 23 05:26:28 2013
SMCO started with pid=21, OS id=5764 
Mon Sep 23 06:07:21 2013
Thread 1 advanced to log sequence 4 (LGWR switch)
  Current log# 1 seq# 4 mem# 0: /oracle/app/oracle/oradata/post/redo01.log
Mon Sep 23 22:00:01 2013
Setting Resource Manager plan SCHEDULER[0x3003]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Mon Sep 23 22:00:02 2013
Starting background process VKRM
Mon Sep 23 22:00:02 2013
VKRM started with pid=22, OS id=25756 
Mon Sep 23 22:01:12 2013
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Mon Sep 23 22:05:10 2013
Thread 1 cannot allocate new log, sequence 5
Private strand flush not complete
  Current log# 1 seq# 4 mem# 0: /oracle/app/oracle/oradata/post/redo01.log
Thread 1 advanced to log sequence 5 (LGWR switch)
  Current log# 2 seq# 5 mem# 0: /oracle/app/oracle/oradata/post/redo02.log
Tue Sep 24 02:00:03 2013
Clearing Resource Manager plan via parameter
Tue Sep 24 05:32:26 2013
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Tue Sep 24 05:32:28 2013
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 10
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Tue Sep 24 05:32:40 2013
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Sep 24 05:32:43 2013
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
Completed: ALTER DATABASE CLOSE NORMAL
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
Tue Sep 24 05:33:03 2013
Stopping background process VKTM: 
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Sep 24 05:33:20 2013
Instance shutdown complete
Tue Sep 24 05:38:37 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/db/dbs/spfilepost.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 592M
  control_files            = "/oracle/app/oracle/oradata/post/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/post/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=postXDB)"
  local_listener           = "LISTENER_POST"
  audit_file_dest          = "/oracle/app/oracle/admin/post/adump"
  audit_trail              = "DB"
  db_name                  = "post"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Tue Sep 24 05:39:28 2013
PMON started with pid=2, OS id=2004 
Tue Sep 24 05:39:29 2013
GEN0 started with pid=4, OS id=2010 
Tue Sep 24 05:39:29 2013
VKTM started with pid=3, OS id=2006 
VKTM running at (100ms) precision 
Tue Sep 24 05:39:29 2013
DIAG started with pid=5, OS id=2012 
Tue Sep 24 05:39:29 2013
DBRM started with pid=6, OS id=2014 
Tue Sep 24 05:39:29 2013
PSP0 started with pid=7, OS id=2016 
Tue Sep 24 05:39:29 2013
DIA0 started with pid=8, OS id=2018 
Tue Sep 24 05:39:31 2013
MMAN started with pid=9, OS id=2020 
Tue Sep 24 05:39:33 2013
LGWR started with pid=11, OS id=2024 
Tue Sep 24 05:39:33 2013
SMON started with pid=13, OS id=2028 
Tue Sep 24 05:39:33 2013
RECO started with pid=14, OS id=2030 
Tue Sep 24 05:39:33 2013
CKPT started with pid=12, OS id=2026 
Tue Sep 24 05:39:33 2013
DBW0 started with pid=10, OS id=2022 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 24 05:39:34 2013
MMNL started with pid=16, OS id=2034 
Tue Sep 24 05:39:34 2013
MMON started with pid=15, OS id=2032 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Tue Sep 24 05:45:21 2013
alter database archivelog
ORA-1507 signalled during: alter database archivelog...
alter database mount
Tue Sep 24 05:45:34 2013
Successful mount of redo thread 1, with mount id 4293043703
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Tue Sep 24 05:47:39 2013
alter database open
Tue Sep 24 05:47:45 2013
Thread 1 opened at log sequence 5
  Current log# 2 seq# 5 mem# 0: /oracle/app/oracle/oradata/post/redo02.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Sep 24 05:47:45 2013
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue Sep 24 05:48:33 2013
QMNC started with pid=20, OS id=2230 
Completed: alter database open
Tue Sep 24 05:50:17 2013
Starting background process CJQ0
Tue Sep 24 05:50:19 2013
db_recovery_file_dest_size of 3852 MB is 0.24% 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 Sep 24 05:50:19 2013
CJQ0 started with pid=27, OS id=2252 
Tue Sep 24 05:53:54 2013
Starting background process SMCO
Tue Sep 24 05:53:55 2013
SMCO started with pid=23, OS id=2299 
Tue Sep 24 06:36:45 2013
Shutting down instance (normal)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Tue Sep 24 06:36:47 2013
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 3
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Tue Sep 24 06:36:52 2013
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Sep 24 06:36:52 2013
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
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Sep 24 06:36:54 2013
Stopping background process VKTM: 
Tue Sep 24 06:36:57 2013
Instance shutdown complete
Tue Sep 24 06:37:15 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/db/dbs/spfilepost.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 592M
  control_files            = "/oracle/app/oracle/oradata/post/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/post/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=postXDB)"
  local_listener           = "LISTENER_POST"
  audit_file_dest          = "/oracle/app/oracle/admin/post/adump"
  audit_trail              = "DB"
  db_name                  = "post"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Tue Sep 24 06:37:23 2013
PMON started with pid=2, OS id=3093 
Tue Sep 24 06:37:23 2013
VKTM started with pid=3, OS id=3095 
VKTM running at (100ms) precision 
Tue Sep 24 06:37:23 2013
GEN0 started with pid=4, OS id=3099 
Tue Sep 24 06:37:23 2013
DIAG started with pid=5, OS id=3101 
Tue Sep 24 06:37:23 2013
DBRM started with pid=6, OS id=3103 
Tue Sep 24 06:37:23 2013
PSP0 started with pid=7, OS id=3105 
Tue Sep 24 06:37:23 2013
DIA0 started with pid=8, OS id=3107 
Tue Sep 24 06:37:23 2013
MMAN started with pid=9, OS id=3109 
Tue Sep 24 06:37:24 2013
DBW0 started with pid=10, OS id=3111 
Tue Sep 24 06:37:24 2013
LGWR started with pid=11, OS id=3113 
Tue Sep 24 06:37:24 2013
CKPT started with pid=12, OS id=3115 
Tue Sep 24 06:37:24 2013
SMON started with pid=13, OS id=3117 
Tue Sep 24 06:37:24 2013
RECO started with pid=14, OS id=3119 
Tue Sep 24 06:37:24 2013
MMON started with pid=15, OS id=3121 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 24 06:37:24 2013
MMNL started with pid=16, OS id=3123 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Tue Sep 24 06:37:25 2013
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 4293052710
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Tue Sep 24 06:37:48 2013
alter database archivelog
Completed: alter database archivelog
alter database open
Tue Sep 24 06:37:59 2013
LGWR: STARTING ARCH PROCESSES
Tue Sep 24 06:37:59 2013
ARC0 started with pid=20, OS id=3196 
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Tue Sep 24 06:38:01 2013
ARC1 started with pid=21, OS id=3198 
Thread 1 opened at log sequence 5
  Current log# 2 seq# 5 mem# 0: /oracle/app/oracle/oradata/post/redo02.log
Successful open of redo thread 1
Tue Sep 24 06:38:02 2013
ARC2 started with pid=22, OS id=3201 
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Sep 24 06:38:02 2013
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Tue Sep 24 06:38:03 2013
ARC3 started with pid=23, OS id=3205 
Starting background process QMNC
Tue Sep 24 06:38:03 2013
QMNC started with pid=24, OS id=3209 
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Completed: alter database open
Tue Sep 24 06:38:05 2013
Starting background process CJQ0
Tue Sep 24 06:38:05 2013
CJQ0 started with pid=28, OS id=3224 
Tue Sep 24 06:38:07 2013
db_recovery_file_dest_size of 3852 MB is 0.24% 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 Sep 24 06:40:27 2013
Deleted Oracle managed file /oracle/app/oracle/flash_recovery_area/POST/backupset/2013_09_24/o1_mf_nnndf_TAG20130924T063847_9435h9yf_.bkp
Tue Sep 24 06:43:06 2013
Starting background process SMCO
Tue Sep 24 06:43:06 2013
SMCO started with pid=32, OS id=3316 
Tue Sep 24 13:02:27 2013
Deleted Oracle managed file /oracle/app/oracle/flash_recovery_area/POST/backupset/2013_09_24/o1_mf_nnndf_TAG20130924T124734_943v2qvo_.bkp
Tue Sep 24 23:15:09 2013
Setting Resource Manager plan SCHEDULER[0x3004]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Tue Sep 24 23:15:52 2013
Starting background process VKRM
Tue Sep 24 23:16:03 2013
VKRM started with pid=27, OS id=20541 
Tue Sep 24 23:19:23 2013
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Tue Sep 24 23:22:25 2013
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Tue Sep 24 23:28:14 2013
Thread 1 cannot allocate new log, sequence 6
Private strand flush not complete
  Current log# 2 seq# 5 mem# 0: /oracle/app/oracle/oradata/post/redo02.log
Thread 1 advanced to log sequence 6 (LGWR switch)
  Current log# 3 seq# 6 mem# 0: /oracle/app/oracle/oradata/post/redo03.log
Tue Sep 24 23:29:43 2013
Archived Log entry 1 added for thread 1 sequence 5 ID 0xffe00ffe dest 1:
Wed Sep 25 02:00:03 2013
Clearing Resource Manager plan via parameter
Wed Sep 25 09:25:24 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/db/dbs/spfilepost.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 592M
  control_files            = "/oracle/app/oracle/oradata/post/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/post/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=postXDB)"
  local_listener           = "LISTENER_POST"
  audit_file_dest          = "/oracle/app/oracle/admin/post/adump"
  audit_trail              = "DB"
  db_name                  = "post"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Wed Sep 25 09:25:31 2013
PMON started with pid=2, OS id=5023 
Wed Sep 25 09:25:31 2013
VKTM started with pid=3, OS id=5025 
VKTM running at (100ms) precision 
Wed Sep 25 09:25:31 2013
GEN0 started with pid=4, OS id=5029 
Wed Sep 25 09:25:31 2013
DIAG started with pid=5, OS id=5031 
Wed Sep 25 09:25:31 2013
DBRM started with pid=6, OS id=5033 
Wed Sep 25 09:25:31 2013
PSP0 started with pid=7, OS id=5035 
Wed Sep 25 09:25:31 2013
DIA0 started with pid=8, OS id=5037 
Wed Sep 25 09:25:31 2013
MMAN started with pid=9, OS id=5039 
Wed Sep 25 09:25:31 2013
DBW0 started with pid=10, OS id=5041 
Wed Sep 25 09:25:31 2013
LGWR started with pid=11, OS id=5043 
Wed Sep 25 09:25:31 2013
CKPT started with pid=12, OS id=5045 
Wed Sep 25 09:25:32 2013
SMON started with pid=13, OS id=5047 
Wed Sep 25 09:25:32 2013
RECO started with pid=14, OS id=5049 
Wed Sep 25 09:25:32 2013
MMON started with pid=15, OS id=5051 
Wed Sep 25 09:25:32 2013
MMNL started with pid=16, OS id=5053 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Wed Sep 25 09:25:32 2013
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 4293106446
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Wed Sep 25 09:25:41 2013
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
 read 1008 KB redo, 438 data blocks need recovery
Started redo application at
 Thread 1: logseq 6, block 50265
Recovery of Online Redo Log: Thread 1 Group 3 Seq 6 Reading mem 0
  Mem# 0: /oracle/app/oracle/oradata/post/redo03.log
Completed redo application of 0.82MB
Completed crash recovery at
 Thread 1: logseq 6, block 52282, scn 867434
 438 data blocks read, 438 data blocks written, 1008 redo k-bytes read
LGWR: STARTING ARCH PROCESSES
Wed Sep 25 09:25:44 2013
ARC0 started with pid=20, OS id=5113 
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Wed Sep 25 09:25:46 2013
ARC1 started with pid=21, OS id=5115 
Wed Sep 25 09:25:46 2013
ARC2 started with pid=22, OS id=5117 
Thread 1 advanced to log sequence 7 (thread open)
Thread 1 opened at log sequence 7
  Current log# 1 seq# 7 mem# 0: /oracle/app/oracle/oradata/post/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Wed Sep 25 09:25:46 2013
ARC3 started with pid=23, OS id=5119 
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Archived Log entry 2 added for thread 1 sequence 6 ID 0xffe00ffe dest 1:
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
Wed Sep 25 09:25:51 2013
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Sep 25 09:25:55 2013
Starting background process QMNC
Wed Sep 25 09:25:55 2013
QMNC started with pid=24, OS id=5121 
Completed: ALTER DATABASE OPEN
Wed Sep 25 09:26:01 2013
db_recovery_file_dest_size of 3852 MB is 1.96% 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 Sep 25 09:26:02 2013
Starting background process CJQ0
Wed Sep 25 09:26:02 2013
CJQ0 started with pid=26, OS id=5135 
Wed Sep 25 09:30:57 2013
Starting background process SMCO
Wed Sep 25 09:30:57 2013
SMCO started with pid=19, OS id=5259 
Wed Sep 25 09:41:02 2013
Deleted Oracle managed file /oracle/app/oracle/flash_recovery_area/POST/backupset/2013_09_25/o1_mf_nnndf_TAG20130925T093855_9464f13p_.bkp
Wed Sep 25 22:01:39 2013
Setting Resource Manager plan SCHEDULER[0x3005]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Wed Sep 25 22:02:14 2013
Starting background process VKRM
Wed Sep 25 22:02:27 2013
VKRM started with pid=28, OS id=20763 
Wed Sep 25 22:15:56 2013
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Wed Sep 25 22:21:51 2013
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Thu Sep 26 23:01:16 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/db/dbs/spfilepost.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 592M
  control_files            = "/oracle/app/oracle/oradata/post/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/post/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=postXDB)"
  local_listener           = "LISTENER_POST"
  audit_file_dest          = "/oracle/app/oracle/admin/post/adump"
  audit_trail              = "DB"
  db_name                  = "post"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Thu Sep 26 23:01:27 2013
PMON started with pid=2, OS id=20119 
Thu Sep 26 23:01:27 2013
VKTM started with pid=3, OS id=20121 
VKTM running at (100ms) precision 
Thu Sep 26 23:01:27 2013
GEN0 started with pid=4, OS id=20125 
Thu Sep 26 23:01:27 2013
DIAG started with pid=5, OS id=20127 
Thu Sep 26 23:01:27 2013
DBRM started with pid=6, OS id=20129 
Thu Sep 26 23:01:27 2013
PSP0 started with pid=7, OS id=20131 
Thu Sep 26 23:01:27 2013
DIA0 started with pid=8, OS id=20133 
Thu Sep 26 23:01:27 2013
MMAN started with pid=9, OS id=20135 
Thu Sep 26 23:01:28 2013
DBW0 started with pid=10, OS id=20137 
Thu Sep 26 23:01:28 2013
LGWR started with pid=11, OS id=20139 
Thu Sep 26 23:01:28 2013
CKPT started with pid=12, OS id=20141 
Thu Sep 26 23:01:29 2013
MMON started with pid=15, OS id=20147 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Sep 26 23:01:29 2013
MMNL started with pid=16, OS id=20149 
Thu Sep 26 23:01:29 2013
RECO started with pid=14, OS id=20145 
Thu Sep 26 23:01:29 2013
SMON started with pid=13, OS id=20143 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Thu Sep 26 23:01:29 2013
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 4293249738
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Thu Sep 26 23:01:47 2013
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
 read 1944 KB redo, 382 data blocks need recovery
Started redo application at
 Thread 1: logseq 7, block 71705
Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0
  Mem# 0: /oracle/app/oracle/oradata/post/redo01.log
Completed redo application of 1.48MB
Completed crash recovery at
 Thread 1: logseq 7, block 75594, scn 907479
 382 data blocks read, 382 data blocks written, 1944 redo k-bytes read
LGWR: STARTING ARCH PROCESSES
Thu Sep 26 23:01:56 2013
ARC0 started with pid=20, OS id=20211 
Thu Sep 26 23:01:57 2013
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 advanced to log sequence 8 (thread open)
Thu Sep 26 23:01:58 2013
ARC1 started with pid=21, OS id=20213 
Thread 1 opened at log sequence 8
  Current log# 2 seq# 8 mem# 0: /oracle/app/oracle/oradata/post/redo02.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Sep 26 23:01:58 2013
ARC2 started with pid=22, OS id=20215 
Thu Sep 26 23:01:58 2013
ARC3 started with pid=23, OS id=20217 
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Thu Sep 26 23:01:58 2013
SMON: enabling cache recovery
Archived Log entry 3 added for thread 1 sequence 7 ID 0xffe00ffe dest 1:
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Thu Sep 26 23:02:08 2013
Starting background process QMNC
Thu Sep 26 23:02:08 2013
QMNC started with pid=24, OS id=20232 
Completed: ALTER DATABASE OPEN
Thu Sep 26 23:02:15 2013
db_recovery_file_dest_size of 3852 MB is 2.91% 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.
Thu Sep 26 23:02:17 2013
Starting background process CJQ0
Thu Sep 26 23:02:19 2013
CJQ0 started with pid=27, OS id=20250 
Setting Resource Manager plan SCHEDULER[0x3006]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Thu Sep 26 23:02:27 2013
Starting background process VKRM
Thu Sep 26 23:02:28 2013
VKRM started with pid=30, OS id=20258 
Thu Sep 26 23:02:42 2013
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Thu Sep 26 23:07:11 2013
Starting background process SMCO
Thu Sep 26 23:07:11 2013
SMCO started with pid=29, OS id=20374 
Fri Sep 27 02:00:02 2013
Clearing Resource Manager plan via parameter
Sat Sep 28 09:30:23 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/db/dbs/spfilepost.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 592M
  control_files            = "/oracle/app/oracle/oradata/post/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/post/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=postXDB)"
  local_listener           = "LISTENER_POST"
  audit_file_dest          = "/oracle/app/oracle/admin/post/adump"
  audit_trail              = "DB"
  db_name                  = "post"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Sat Sep 28 09:30:32 2013
PMON started with pid=2, OS id=4906 
Sat Sep 28 09:30:32 2013
GEN0 started with pid=4, OS id=4912 
Sat Sep 28 09:30:32 2013
DIAG started with pid=5, OS id=4914 
Sat Sep 28 09:30:32 2013
DBRM started with pid=6, OS id=4916 
Sat Sep 28 09:30:32 2013
PSP0 started with pid=7, OS id=4918 
Sat Sep 28 09:30:32 2013
VKTM started with pid=3, OS id=4908 
VKTM running at (100ms) precision 
Sat Sep 28 09:30:32 2013
DIA0 started with pid=8, OS id=4920 
Sat Sep 28 09:30:32 2013
MMAN started with pid=9, OS id=4922 
Sat Sep 28 09:30:32 2013
DBW0 started with pid=10, OS id=4924 
Sat Sep 28 09:30:32 2013
LGWR started with pid=11, OS id=4926 
Sat Sep 28 09:30:33 2013
CKPT started with pid=12, OS id=4928 
Sat Sep 28 09:30:33 2013
SMON started with pid=13, OS id=4930 
Sat Sep 28 09:30:33 2013
RECO started with pid=14, OS id=4932 
Sat Sep 28 09:30:33 2013
MMON started with pid=15, OS id=4934 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Sep 28 09:30:33 2013
MMNL started with pid=16, OS id=4936 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Sat Sep 28 09:30:37 2013
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 4293393086
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Sat Sep 28 09:30:45 2013
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
 read 10 KB redo, 20 data blocks need recovery
Started redo application at
 Thread 1: logseq 8, block 59227
Recovery of Online Redo Log: Thread 1 Group 2 Seq 8 Reading mem 0
  Mem# 0: /oracle/app/oracle/oradata/post/redo02.log
Completed redo application of 0.00MB
Completed crash recovery at
 Thread 1: logseq 8, block 59247, scn 950873
 20 data blocks read, 20 data blocks written, 10 redo k-bytes read
LGWR: STARTING ARCH PROCESSES
Sat Sep 28 09:30:49 2013
ARC0 started with pid=20, OS id=4994 
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sat Sep 28 09:30:49 2013
ARC1 started with pid=21, OS id=4996 
Sat Sep 28 09:30:49 2013
ARC2 started with pid=22, OS id=4998 
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Sat Sep 28 09:30:49 2013
ARC3 started with pid=23, OS id=5000 
ARC2: Becoming the heartbeat ARCH
Thread 1 advanced to log sequence 9 (thread open)
Thread 1 opened at log sequence 9
  Current log# 3 seq# 9 mem# 0: /oracle/app/oracle/oradata/post/redo03.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Archived Log entry 4 added for thread 1 sequence 8 ID 0xffe00ffe dest 1:
Starting background process QMNC
Sat Sep 28 09:31:13 2013
QMNC started with pid=24, OS id=5002 
Sat Sep 28 09:31:18 2013
Completed: ALTER DATABASE OPEN
Sat Sep 28 09:31:22 2013
Starting background process CJQ0
Sat Sep 28 09:31:22 2013
CJQ0 started with pid=26, OS id=5016 
Sat Sep 28 09:31:23 2013
db_recovery_file_dest_size of 3852 MB is 3.66% 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.
Setting Resource Manager plan SCHEDULER[0x3008]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sat Sep 28 09:31:31 2013
Starting background process VKRM
Sat Sep 28 09:31:31 2013
VKRM started with pid=29, OS id=5037 
Sat Sep 28 09:31:41 2013
ALTER SYSTEM SET remote_os_authent=TRUE SCOPE=SPFILE;
Sat Sep 28 09:31:50 2013
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Sat Sep 28 09:36:14 2013
Starting background process SMCO
Sat Sep 28 09:36:14 2013
SMCO started with pid=19, OS id=5173 
Sat Sep 28 18:01:24 2013
Thread 1 advanced to log sequence 10 (LGWR switch)
  Current log# 1 seq# 10 mem# 0: /oracle/app/oracle/oradata/post/redo01.log
Sat Sep 28 18:01:25 2013
Archived Log entry 5 added for thread 1 sequence 9 ID 0xffe00ffe dest 1:
Sun Sep 29 02:00:02 2013
Clearing Resource Manager plan via parameter
Sun Sep 29 06:00:02 2013
Setting Resource Manager plan SCHEDULER[0x3009]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sun Sep 29 06:00:02 2013
Starting background process VKRM
Sun Sep 29 06:00:02 2013
VKRM started with pid=29, OS id=2008 
Sun Sep 29 06:00:08 2013
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Sun Sep 29 07:00:09 2013
Thread 1 advanced to log sequence 11 (LGWR switch)
  Current log# 2 seq# 11 mem# 0: /oracle/app/oracle/oradata/post/redo02.log
Sun Sep 29 07:00:18 2013
Archived Log entry 6 added for thread 1 sequence 10 ID 0xffe00ffe dest 1:
Sun Sep 29 16:01:29 2013
Thread 1 advanced to log sequence 12 (LGWR switch)
  Current log# 3 seq# 12 mem# 0: /oracle/app/oracle/oradata/post/redo03.log
Sun Sep 29 16:01:38 2013
Archived Log entry 7 added for thread 1 sequence 11 ID 0xffe00ffe dest 1:
Mon Sep 30 10:30:30 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/db/dbs/spfilepost.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 592M
  control_files            = "/oracle/app/oracle/oradata/post/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/post/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3852M
  undo_tablespace          = "UNDOTBS1"
  remote_os_authent        = TRUE
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=postXDB)"
  local_listener           = "LISTENER_POST"
  audit_file_dest          = "/oracle/app/oracle/admin/post/adump"
  audit_trail              = "DB"
  db_name                  = "post"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Deprecated system parameters with specified values:
  remote_os_authent        
End of deprecated system parameter listing
Mon Sep 30 10:30:43 2013
PMON started with pid=2, OS id=18070 
Mon Sep 30 10:30:43 2013
VKTM started with pid=3, OS id=18072 
VKTM running at (100ms) precision 
Mon Sep 30 10:30:43 2013
GEN0 started with pid=4, OS id=18076 
Mon Sep 30 10:30:43 2013
DIAG started with pid=5, OS id=18078 
Mon Sep 30 10:30:43 2013
DBRM started with pid=6, OS id=18080 
Mon Sep 30 10:30:43 2013
PSP0 started with pid=7, OS id=18082 
Mon Sep 30 10:30:43 2013
DIA0 started with pid=8, OS id=18084 
Mon Sep 30 10:30:43 2013
MMAN started with pid=9, OS id=18086 
Mon Sep 30 10:30:44 2013
LGWR started with pid=11, OS id=18090 
Mon Sep 30 10:30:44 2013
DBW0 started with pid=10, OS id=18088 
Mon Sep 30 10:30:44 2013
CKPT started with pid=12, OS id=18092 
Mon Sep 30 10:30:44 2013
SMON started with pid=13, OS id=18094 
Mon Sep 30 10:30:44 2013
RECO started with pid=14, OS id=18096 
Mon Sep 30 10:30:44 2013
MMON started with pid=15, OS id=18098 
Mon Sep 30 10:30:44 2013
MMNL started with pid=16, OS id=18100 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Mon Sep 30 10:30:48 2013
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 4293600217
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Sep 30 10:30:58 2013
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
 read 34 KB redo, 12 data blocks need recovery
Started redo application at
 Thread 1: logseq 12, block 45113
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
  Mem# 0: /oracle/app/oracle/oradata/post/redo03.log
Completed redo application of 0.01MB
Completed crash recovery at
 Thread 1: logseq 12, block 45182, scn 1031305
 12 data blocks read, 12 data blocks written, 34 redo k-bytes read
LGWR: STARTING ARCH PROCESSES
Mon Sep 30 10:31:01 2013
ARC0 started with pid=20, OS id=18164 
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Mon Sep 30 10:31:01 2013
ARC1 started with pid=21, OS id=18166 
Mon Sep 30 10:31:01 2013
ARC2 started with pid=22, OS id=18168 
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Mon Sep 30 10:31:02 2013
ARC3 started with pid=23, OS id=18170 
Thread 1 advanced to log sequence 13 (thread open)
Thread 1 opened at log seq

Select allOpen in new window