ORA-03113 和ora-01041 的警告日誌

楊奇龍發表於2010-05-11
ORA-376 encountered when generating server alert SMG-4120
db_recovery_file_dest_size of 2048 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.
Tue May 11 20:47:42 2010
Completed: alter database open
Tue May 11 20:48:26 2010
alter database datafile 2 online
Completed: alter database datafile 2 online
alter database datafile 4 online
Completed: alter database datafile 4 online
Tue May 11 20:48:42 2010
Starting background process CJQ0
Tue May 11 20:48:42 2010
CJQ0 started with pid=36, OS id=2060
Tue May 11 21:05:31 2010
Stopping background process SMCO
Stopping background process FBDA
Shutting down instance: further logons disabled
Tue May 11 21:05:32 2010
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
Shutting down instance (immediate)
License high water mark = 9
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue May 11 21:05:43 2010
alter database close
Tue May 11 21:05:43 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue May 11 21:05:43 2010
Shutting down archive processes
Archiving is disabled
Tue May 11 21:05:43 2010
ARCH shutting down
Tue May 11 21:05:43 2010
ARCH shutting down
ARC1: Archival stopped
Tue May 11 21:05:43 2010
ARCH shutting down
ARC3: Archival stopped
Tue May 11 21:05:43 2010
ARCH shutting down
ARC0: Archival stopped
Tue May 11 21:05:43 2010
ARCH shutting down
ARC2: Archival stopped
ARC4: Archival stopped
Thread 1 closed at log sequence 79
Successful close of redo thread 1
Completed: alter database close
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
Tue May 11 21:05:49 2010
Stopping background process VKTM:
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue May 11 21:05:51 2010
Instance shutdown complete
Tue May 11 21:08:45 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile F:\APP\YANG\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORACL.ORA
System parameters with non-default values:
  processes                = 150
  shared_pool_size         = 116M
  memory_target            = 820M
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL01.CTL"
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL02.CTL"
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL03.CTL"
  db_block_size            = 8192
  compatible               = "11.1.0.0.0"
  log_archive_start        = TRUE
  log_archive_dest_1       = "location=f:\app\yang\archive1
"
  log_archive_dest_2       = "location=f:\app\yang\archive2"
  log_archive_dest_state_1 = "ENABLE"
  log_archive_max_processes= 5
  log_archive_min_succeed_dest= 2
  log_archive_format       = "%s_%t_%r.log"
  db_recovery_file_dest    = "F:\app\yang\flash_recovery_area"
  db_recovery_file_dest_size= 2G
  undo_tablespace          = "UNDOTBS1"
  undo_retention           = 900
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=oraclXDB)"
  utl_file_dir             = "f:\app\yang\logminer"
  audit_file_dest          = "F:\APP\YANG\ADMIN\ORACL\ADUMP"
  audit_trail              = "DB"
  db_name                  = "oracl"
  open_cursors             = 300
  diagnostic_dest          = "F:\APP\YANG"
Deprecated system parameters with specified values:
  log_archive_start       
End of deprecated system parameter listing
Tue May 11 21:08:45 2010
PMON started with pid=2, OS id=2072
Tue May 11 21:08:45 2010
VKTM started with pid=3, OS id=2800 at elevated priority
VKTM running at (20)ms precision
Tue May 11 21:08:45 2010
DIAG started with pid=4, OS id=3848
Tue May 11 21:08:45 2010
DBRM started with pid=5, OS id=3568
Tue May 11 21:08:45 2010
PSP0 started with pid=6, OS id=924
Tue May 11 21:08:45 2010
DSKM started with pid=7, OS id=3964
Tue May 11 21:08:45 2010
DIA0 started with pid=8, OS id=2252
Tue May 11 21:08:45 2010
MMAN started with pid=7, OS id=3896
Tue May 11 21:08:45 2010
DBW0 started with pid=9, OS id=2080
Tue May 11 21:08:46 2010
LGWR started with pid=10, OS id=172
Tue May 11 21:08:46 2010
CKPT started with pid=11, OS id=3232
Tue May 11 21:08:46 2010
SMON started with pid=12, OS id=3152
Tue May 11 21:08:46 2010
RECO started with pid=13, OS id=252
Tue May 11 21:08:46 2010
MMON started with pid=14, OS id=3996
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue May 11 21:08:46 2010
MMNL started with pid=15, OS id=832
starting up 1 shared server(s) ...
ORACLE_BASE from environment = F:\app\yang
Tue May 11 21:08:46 2010
alter database mount
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 1764263393
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Tue May 11 21:08:54 2010
alter database open
LGWR: STARTING ARCH PROCESSES
Tue May 11 21:08:54 2010
ARC0 started with pid=20, OS id=3564
Tue May 11 21:08:54 2010
ARC1 started with pid=21, OS id=2140
Tue May 11 21:08:54 2010
ARC2 started with pid=22, OS id=3884
Tue May 11 21:08:54 2010
ARC3 started with pid=23, OS id=3860
ARC0: Archival started
Tue May 11 21:08:54 2010
ARC4 started with pid=24, OS id=4092
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 79
  Current log# 1 seq# 79 mem# 0: F:\APP\YANG\ORADATA\ORACL\REDO01.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC4: Becoming the heartbeat ARCH
Tue May 11 21:08:56 2010
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 ZHS16GBK
Opening with internal Resource Manager plan
Starting background process FBDA
Starting background process SMCO
Tue May 11 21:08:58 2010
FBDA started with pid=25, OS id=804
Tue May 11 21:08:58 2010
SMCO started with pid=26, OS id=3908
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue May 11 21:08:59 2010
QMNC started with pid=27, OS id=1380
Tue May 11 21:09:09 2010
db_recovery_file_dest_size of 2048 MB is 1.19% 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 May 11 21:09:20 2010
Completed: alter database open
Stopping background process SMCO
Stopping background process FBDA
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
Shutting down instance (immediate)
License high water mark = 2
Waiting for dispatcher 'D000' to shutdown
Tue May 11 21:09:30 2010
All dispatchers and shared servers shutdown
alter database close
Tue May 11 21:09:31 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue May 11 21:09:31 2010
Shutting down archive processes
Archiving is disabled
Tue May 11 21:09:31 2010
ARCH shutting down
ARC4: Archival stopped
Tue May 11 21:09:31 2010
ARCH shutting down
ARC3: Archival stopped
Tue May 11 21:09:31 2010
ARCH shutting down
ARC1: Archival stopped
Tue May 11 21:09:31 2010
ARCH shutting down
ARC2: Archival stopped
Tue May 11 21:09:31 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC0: Archiving disabled
ARCH shutting down
ARC0: Archival stopped
Thread 1 closed at log sequence 79
Successful close of redo thread 1
Completed: alter database close
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
Tue May 11 21:09:36 2010
Stopping background process VKTM:
Tue May 11 21:09:38 2010
Instance shutdown complete
Tue May 11 21:13:19 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile F:\APP\YANG\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORACL.ORA
System parameters with non-default values:
  processes                = 150
  shared_pool_size         = 116M
  memory_target            = 820M
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL01.CTL"
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL02.CTL"
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL03.CTL"
  db_block_size            = 8192
  compatible               = "11.1.0.0.0"
  log_archive_start        = TRUE
  log_archive_dest_1       = "location=f:\app\yang\archive1
"
  log_archive_dest_2       = "location=f:\app\yang\archive2"
  log_archive_dest_state_1 = "ENABLE"
  log_archive_max_processes= 5
  log_archive_min_succeed_dest= 2
  log_archive_format       = "%s_%t_%r.log"
  db_recovery_file_dest    = "F:\app\yang\flash_recovery_area"
  db_recovery_file_dest_size= 2G
  undo_tablespace          = "UNDOTBS1"
  undo_retention           = 900
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=oraclXDB)"
  utl_file_dir             = "f:\app\yang\logminer"
  audit_file_dest          = "F:\APP\YANG\ADMIN\ORACL\ADUMP"
  audit_trail              = "DB"
  db_name                  = "oracl"
  open_cursors             = 300
  diagnostic_dest          = "F:\APP\YANG"
Deprecated system parameters with specified values:
  log_archive_start       
End of deprecated system parameter listing
Tue May 11 21:13:20 2010
PMON started with pid=2, OS id=3268
Tue May 11 21:13:20 2010
VKTM started with pid=3, OS id=2840 at elevated priority
VKTM running at (20)ms precision
Tue May 11 21:13:20 2010
DIAG started with pid=4, OS id=3904
Tue May 11 21:13:20 2010
DBRM started with pid=5, OS id=3844
Tue May 11 21:13:20 2010
PSP0 started with pid=6, OS id=3184
Tue May 11 21:13:20 2010
DSKM started with pid=7, OS id=3860
Tue May 11 21:13:20 2010
DIA0 started with pid=8, OS id=4036
Tue May 11 21:13:20 2010
MMAN started with pid=7, OS id=3112
Tue May 11 21:13:20 2010
DBW0 started with pid=9, OS id=3996
Tue May 11 21:13:20 2010
LGWR started with pid=10, OS id=3480
Tue May 11 21:13:20 2010
CKPT started with pid=11, OS id=684
Tue May 11 21:13:20 2010
SMON started with pid=12, OS id=3508
Tue May 11 21:13:20 2010
RECO started with pid=13, OS id=3596
Tue May 11 21:13:20 2010
MMON started with pid=14, OS id=2440
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue May 11 21:13:20 2010
MMNL started with pid=15, OS id=3692
starting up 1 shared server(s) ...
ORACLE_BASE from environment = F:\app\yang
Tue May 11 21:13:21 2010
alter database mount
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 1764242163
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Tue May 11 21:28:24 2010
db_recovery_file_dest_size of 2048 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.
Tue May 11 22:11:26 2010
alter database open
Tue May 11 22:11:26 2010
LGWR: STARTING ARCH PROCESSES
Tue May 11 22:11:26 2010
ARC0 started with pid=19, OS id=4936
Tue May 11 22:11:26 2010
ARC1 started with pid=20, OS id=2892
Tue May 11 22:11:26 2010
ARC2 started with pid=22, OS id=5572
Tue May 11 22:11:26 2010
ARC3 started with pid=21, OS id=5000
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC3: Becoming the 'no FAL' ARCH
ARC3: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Tue May 11 22:11:26 2010
ARC4 started with pid=23, OS id=3828
Thread 1 opened at log sequence 79
  Current log# 1 seq# 79 mem# 0: F:\APP\YANG\ORADATA\ORACL\REDO01.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue May 11 22:11:28 2010
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 ZHS16GBK
Opening with internal Resource Manager plan
Starting background process FBDA
Starting background process SMCO
Tue May 11 22:11:29 2010
FBDA started with pid=24, OS id=4188
Tue May 11 22:11:29 2010
SMCO started with pid=25, OS id=4200
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue May 11 22:11:30 2010
QMNC started with pid=26, OS id=4620
Tue May 11 22:11:55 2010
Completed: alter database open
Tue May 11 22:13:47 2010
Starting background process CJQ0
Tue May 11 22:13:47 2010
CJQ0 started with pid=39, OS id=3796
Setting Resource Manager plan SCHEDULER[0x2C0A]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Tue May 11 22:14:02 2010
Tue May 11 22:14:02 2010
Logminer Bld: Lockdown Complete.  DB_TXN_SCN is   UnwindToSCN (LockdownSCN) is 2421816
Tue May 11 22:14:06 2010
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-662469/,如需轉載,請註明出處,否則將追究法律責任。

相關文章