ORA-03113 和ora-01041 的警告日誌
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"
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 刪除oracle 11g的警告日誌和監聽日誌Oracle
- oracle 11g的警告日誌Oracle
- Oracle之外部表警告日誌Oracle
- alert日誌中出現ash size的警告
- 警告日誌檔案alert_.log
- 使用Oracle的外部表查詢警告日誌Oracle
- 由一條日誌警告所做的調優分析
- alert日誌中的一條ora警告資訊的分析
- 使用Oracle的外部表查詢警告日誌檔案Oracle
- 【11g】11g 中警告日誌的位置
- 使用外部表訪問警告日誌檔案
- Oracle 警告日誌 (alert log) 中包含哪些內容 ?Oracle
- Oracle恢復一例--ORA-03113、ORA-24324,ORA-01041錯誤Oracle
- Apach的配置和日誌
- MySQL日誌警告'[Warning] Unsafe statement written to the binary log'MySql
- linux 中oracle 的ORA-03113,ORA-24324,ORA-01041錯誤,可能需要改ipLinuxOracle
- MYSQL啟用日誌和檢視日誌MySql
- oracle歸檔日誌滿了,導致無法啟動 ORA-03113Oracle
- PHP慢指令碼日誌和Mysql的慢查詢日誌PHP指令碼MySql
- 日誌檔案和歸檔日誌檔案的關係以及如何切換日誌
- lumen cli日誌和普通日誌分開儲存
- Oracle 11g RAC檢視ASM日誌、grid日誌和DB日誌OracleASM
- 對日誌檔案組和日誌檔案組成員的管理
- Oracle日誌組新增冗餘檔案和日誌組Oracle
- JAVA異常和日誌Java
- 當前聯機日誌和其他聯機日誌恢復的區別
- 測試DML 時產生歸檔日誌和閃回日誌的比
- Kubernetes 叢集日誌 和 EFK 架構日誌方案架構
- 強制日誌切換和歸檔當前的重做日誌的命令的區別
- mysql之 日誌體系(錯誤日誌、查詢日誌、二進位制日誌、事務日誌、中繼日誌)MySql中繼
- 跟我一起學docker(15)--監控日誌和日誌管理Docker
- 關於MySQL 通用查詢日誌和慢查詢日誌分析MySql
- eclipse設定檢視GC日誌和如何理解GC日誌EclipseGC
- Oracle之備份和清理監聽日誌、告警日誌指令碼Oracle指令碼
- SQL Server 2005 日誌刪除和日誌檔案限制SQLServer
- MySQL之事務和redo日誌MySql
- 複製和日誌傳送
- 誤刪重做日誌檔案組導致啟動資料庫報錯ORA-03113資料庫