Thread 1 cannot allocate new log, sequence 4097
Checkpoint not complete
Current log# 1 seq# 4096 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo01.log
Thread 1 advanced to log sequence 4097 (LGWR switch)
Current log# 2 seq# 4097 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo02.log
Tue May 08 21:32:41 2012
Starting background process CJQ0
Tue May 08 21:32:41 2012
WARNING: process CJQ0 (ospid: 14508) was unable to attach SMR.
Errors in file /u01/app/oracle/diag/rdbms/ygzhou01/ygzhou01/trace/ygzhou01_cjq0_14508.trc:
ORA-27300: OS system dependent operation:open failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sskgmsmr_7
CJQ0 started with pid=22, OS id=14508
Tue May 08 22:00:00 2012
Setting Resource Manager plan SCHEDULER[0x3108]:DEFAULT_MAINTENANCE_PLAN via scheduler wind
ow
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Tue May 08 22:00:00 2012
Starting background process VKRM
Tue May 08 22:00:00 2012
WARNING: process VKRM (ospid: 28686) was unable to attach SMR.
Errors in file /u01/app/oracle/diag/rdbms/ygzhou01/ygzhou01/trace/ygzhou01_vkrm_28686.trc:
ORA-27300: OS system dependent operation:open failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sskgmsmr_7
VKRM started with pid=21, OS id=28686
Tue May 08 22:00:06 2012
WARNING: process USER (ospid: 28706) was unable to attach SMR.
Errors in file /u01/app/oracle/diag/rdbms/ygzhou01/ygzhou01/trace/ygzhou01_j001_28706.trc:
ORA-27300: OS system dependent operation:open failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sskgmsmr_7
Tue May 08 22:00:08 2012
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Tue May 08 22:00:12 2012
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file /u01/app/oracle/diag/rdbms/ygzhou01/ygzhou01/trace/ygzhou01_j002_28708.trc:
ORA-20011: Approximate NDV failed: ORA-06564: object YGZHOU does not exist
Tue May 08 22:01:19 2012
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Tue May 08 23:00:47 2012
Thread 1 advanced to log sequence 4098 (LGWR switch)
Current log# 3 seq# 4098 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo03.log
Wed May 09 00:02:52 2012
Thread 1 advanced to log sequence 4099 (LGWR switch)
Current log# 1 seq# 4099 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo01.log
Wed May 09 02:00:00 2012
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Wed May 09 03:12:52 2012
Stopping background process CJQ0
Wed May 09 09:01:01 2012
Thread 1 advanced to log sequence 4100 (LGWR switch)
Current log# 2 seq# 4100 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo02.log
Wed May 09 09:44:23 2012