ksvcreate: Process(m000) creation failed Fri Mar 03 05:35:31 2017

来源:互联网 发布:hotel california知乎 编辑:程序博客网 时间:2024/06/05 21:11


LGWR: Standby redo logfile selected for thread 1 sequence 9740 for destination LOG_ARCHIVE_DEST_2
Thu Mar 02 22:00:20 2017
Thread 1 advanced to log sequence 9740 (LGWR switch)
  Current log# 1 seq# 9740 mem# 0: F:\ORADATA\ORCL\REDO01.LOG
Thu Mar 02 22:58:20 2017
LGWR: Standby redo logfile selected for thread 1 sequence 9741 for destination LOG_ARCHIVE_DEST_2
Thu Mar 02 22:58:21 2017
Thread 1 advanced to log sequence 9741 (LGWR switch)
  Current log# 2 seq# 9741 mem# 0: F:\ORADATA\ORCL\REDO02.LOG
Fri Mar 03 01:52:00 2017
Shutting down instance: further logons disabled
Fri Mar 03 01:52:00 2017
Stopping background process CJQ0
Fri Mar 03 01:52:00 2017
Stopping background process QMNC
Fri Mar 03 01:52:01 2017
Background process QMNC not dead after 150 seconds
Fri Mar 03 01:52:01 2017
Stopping background process MMNL
Fri Mar 03 01:52:02 2017
Background process MMNL not dead after 10 seconds
Fri Mar 03 01:52:02 2017
Stopping background process MMON
Fri Mar 03 01:52:03 2017
Background process MMON not dead after 30 seconds
Fri Mar 03 01:52:04 2017
Shutting down instance (immediate)
License high water mark = 788
Fri Mar 03 01:52:04 2017
Stopping Job queue slave processes, flags = 7
Fri Mar 03 01:52:04 2017
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Mar 03 01:52:35 2017
alter database close normal
Fri Mar 03 01:52:35 2017
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Mar 03 01:52:38 2017
Thread 1 advanced to log sequence 9742 (thread close)
LGWR: Waiting for ORLs to be archived...
LGWR: ORLs successfully archived
Shutting down archive processes
Archiving is disabled
Fri Mar 03 01:52:46 2017
ARCH shutting down
ARC1: Archival stopped
Fri Mar 03 01:52:51 2017
ARC0: Becoming the heartbeat ARCH
ARC0: Archiving disabled
ARCH shutting down
ARC0: Archival stopped
Fri Mar 03 01:52:52 2017
Thread 1 closed at log sequence 9741
Successful close of redo thread 1
Fri Mar 03 01:52:54 2017
Completed: alter database close normal
Fri Mar 03 01:52:54 2017
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
Dump file d:\oracle\product\10.2.0\admin\orcl\bdump\alert_orcl.log
Fri Mar 03 01:53:11 2017
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU                 : 16 - type 8664, 16 Physical Cores
Process Affinity    : 0x0000000000000000
Memory (Avail/Total): Ph:15017M/16383M, Ph+PgF:31154M/32765M
Fri Mar 03 01:53:11 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =110
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
  processes                = 900
  sessions                 = 1000
  shared_pool_size         = 1073741824
  large_pool_size          = 33554432
  java_pool_size           = 33554432
  nls_language             = SIMPLIFIED CHINESE
  nls_territory            = CHINA
  control_files            = F:\ORADATA\ORCL\CONTROL01.CTL, F:\ORADATA\ORCL\CONTROL02.CTL, F:\ORADATA\ORCL\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 3221225472
  db_recycle_cache_size    = 0
  db_writer_processes      = 4
  compatible               = 10.2.0.3.0
  log_archive_config       = dg_config=(orcl,mh)
  log_archive_dest_1       = LOCATION=d:\archlog
  log_archive_dest_2       = service=mh LGWR SYNC affirm valid_for=(online_logfiles,primary_role) db_unique_name=mh
  log_archive_dest_state_1 = ENABLE
  log_archive_dest_state_2 = ENABLE
  log_archive_format       = ARC%S_%R.%T
  fal_client               = PRIMARY
  fal_server               = MH
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = D:\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 214748364800
  standby_file_management  = AUTO
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=orclXDB)
  job_queue_processes      = 10
  audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
  db_name                  = orcl
  db_unique_name           = ORCL
  open_cursors             = 900
  pga_aggregate_target     = 2147483648
PMON started with pid=2, OS id=6384
PSP0 started with pid=6, OS id=6652
MMAN started with pid=10, OS id=6440
DBW0 started with pid=14, OS id=3376
DBW1 started with pid=18, OS id=5132
DBW2 started with pid=22, OS id=3908
DBW3 started with pid=26, OS id=6196
LGWR started with pid=30, OS id=4388
CKPT started with pid=34, OS id=4060
SMON started with pid=38, OS id=5080
RECO started with pid=42, OS id=4204
CJQ0 started with pid=46, OS id=4164
MMON started with pid=50, OS id=1972
Fri Mar 03 01:53:14 2017
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=54, OS id=5300
Fri Mar 03 01:53:14 2017
starting up 1 shared server(s) ...
Fri Mar 03 01:53:14 2017
alter database mount exclusive
Fri Mar 03 01:53:18 2017
Setting recovery target incarnation to 2
Fri Mar 03 01:53:18 2017
Successful mount of redo thread 1, with mount id 1465357066
Fri Mar 03 01:53:18 2017
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Mar 03 01:53:18 2017
alter database open
Fri Mar 03 01:53:18 2017
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=70, OS id=7080
Fri Mar 03 01:53:18 2017
ARC0: Archival started
ARC1: Archival started
ARC1 started with pid=74, OS id=1232
Fri Mar 03 01:53:18 2017
LGWR: STARTING ARCH PROCESSES COMPLETE
Fri Mar 03 01:53:18 2017
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
Fri Mar 03 01:53:18 2017
Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNSb started with pid=78, OS id=4748
Fri Mar 03 01:53:21 2017
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
LGWR: Standby redo logfile selected for thread 1 sequence 9743 for destination LOG_ARCHIVE_DEST_2
Fri Mar 03 01:53:22 2017
Thread 1 advanced to log sequence 9743 (thread open)
Thread 1 opened at log sequence 9743
  Current log# 1 seq# 9743 mem# 0: F:\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Fri Mar 03 01:53:22 2017
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Mar 03 01:53:22 2017
ARC0: STARTING ARCH PROCESSES
Fri Mar 03 01:53:22 2017
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Mar 03 01:53:22 2017
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=82, OS id=4272
Fri Mar 03 01:53:22 2017
ARC1: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
Fri Mar 03 01:53:22 2017
SMON: enabling cache recovery
Fri Mar 03 01:53:22 2017
ARC1: Standby redo logfile selected for thread 1 sequence 9742 for destination LOG_ARCHIVE_DEST_2
Fri Mar 03 01:53:22 2017
Successfully onlined Undo Tablespace 1.
Fri Mar 03 01:53:22 2017
SMON: enabling tx recovery
Fri Mar 03 01:53:22 2017
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 4, CPUs = 4
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=86, OS id=1320
Fri Mar 03 01:53:24 2017
Completed: alter database open
Fri Mar 03 01:53:24 2017
db_recovery_file_dest_size of 204800 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.
Fri Mar 03 01:54:18 2017
Shutting down archive processes
Fri Mar 03 01:54:23 2017
ARCH shutting down
ARC2: Archival stopped
Shutting down instance: further logons disabled
Fri Mar 03 01:56:14 2017
Stopping background process CJQ0
Fri Mar 03 01:56:15 2017
Stopping background process QMNC
Fri Mar 03 01:56:15 2017
Stopping background process MMNL
Fri Mar 03 01:56:17 2017
Background process MMNL not dead after 10 seconds
Fri Mar 03 01:56:17 2017
Stopping background process MMON
Fri Mar 03 01:56:18 2017
Background process MMON not dead after 30 seconds
Fri Mar 03 01:56:18 2017
Shutting down instance (immediate)
License high water mark = 5
Fri Mar 03 01:56:18 2017
Stopping Job queue slave processes, flags = 7
Fri Mar 03 01:56:18 2017
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Mar 03 01:56:20 2017
alter database close normal
Fri Mar 03 01:56:20 2017
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Mar 03 01:56:21 2017
Thread 1 advanced to log sequence 9744 (thread close)
LGWR: Waiting for ORLs to be archived...
LGWR: ORLs successfully archived
Shutting down archive processes
Archiving is disabled
Fri Mar 03 01:56:24 2017
ARC0: Archiving disabled
Fri Mar 03 01:56:29 2017
ARCH shutting down
ARC1: Archival stopped
Fri Mar 03 01:56:34 2017
ARCH shutting down
ARC0: Archival stopped
Fri Mar 03 01:56:35 2017
Thread 1 closed at log sequence 9743
Successful close of redo thread 1
Fri Mar 03 01:56:35 2017
Completed: alter database close normal
Fri Mar 03 01:56:35 2017
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
Dump file d:\oracle\product\10.2.0\admin\orcl\bdump\alert_orcl.log
Fri Mar 03 01:56:57 2017
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU                 : 16 - type 8664, 16 Physical Cores
Process Affinity    : 0x0000000000000000
Memory (Avail/Total): Ph:15029M/16383M, Ph+PgF:31170M/32765M
Fri Mar 03 01:56:57 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =110
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
  processes                = 900
  sessions                 = 1000
  shared_pool_size         = 1073741824
  large_pool_size          = 33554432
  java_pool_size           = 33554432
  nls_language             = SIMPLIFIED CHINESE
  nls_territory            = CHINA
  control_files            = F:\ORADATA\ORCL\CONTROL01.CTL, F:\ORADATA\ORCL\CONTROL02.CTL, F:\ORADATA\ORCL\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 3221225472
  db_recycle_cache_size    = 0
  db_writer_processes      = 4
  compatible               = 10.2.0.3.0
  log_archive_config       = dg_config=(orcl,mh)
  log_archive_dest_1       = LOCATION=d:\archlog
  log_archive_dest_2       = service=mh LGWR SYNC affirm valid_for=(online_logfiles,primary_role) db_unique_name=mh
  log_archive_dest_state_1 = ENABLE
  log_archive_dest_state_2 = ENABLE
  log_archive_format       = ARC%S_%R.%T
  fal_client               = PRIMARY
  fal_server               = MH
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = D:\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 214748364800
  standby_file_management  = AUTO
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=orclXDB)
  job_queue_processes      = 10
  audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
  db_name                  = orcl
  db_unique_name           = ORCL
  open_cursors             = 900
  pga_aggregate_target     = 2147483648
PMON started with pid=2, OS id=5184
PSP0 started with pid=6, OS id=5388
MMAN started with pid=10, OS id=3484
DBW0 started with pid=14, OS id=6964
DBW1 started with pid=18, OS id=5140
DBW2 started with pid=22, OS id=3792
DBW3 started with pid=26, OS id=6244
LGWR started with pid=30, OS id=6996
CKPT started with pid=34, OS id=4932
SMON started with pid=38, OS id=2736
RECO started with pid=42, OS id=4300
CJQ0 started with pid=46, OS id=4624
MMON started with pid=50, OS id=5792
Fri Mar 03 01:56:59 2017
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=54, OS id=2452
Fri Mar 03 01:56:59 2017
starting up 1 shared server(s) ...
Fri Mar 03 01:57:00 2017
alter database mount exclusive
Fri Mar 03 01:57:05 2017
Setting recovery target incarnation to 2
Fri Mar 03 01:57:05 2017


Successful mount of redo thread 1, with mount id 1465379821
Fri Mar 03 01:57:05 2017
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Mar 03 01:57:05 2017
alter database open
Fri Mar 03 01:57:05 2017
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=70, OS id=6844
Fri Mar 03 01:57:05 2017
ARC0: Archival started
ARC1: Archival started
Fri Mar 03 01:57:05 2017
LGWR: STARTING ARCH PROCESSES COMPLETE
Fri Mar 03 01:57:05 2017
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
Fri Mar 03 01:57:05 2017
Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNSb started with pid=78, OS id=5316
ARC1 started with pid=74, OS id=3832
Fri Mar 03 01:57:08 2017
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
LGWR: Standby redo logfile selected for thread 1 sequence 9745 for destination LOG_ARCHIVE_DEST_2
Fri Mar 03 01:57:09 2017
Thread 1 advanced to log sequence 9745 (thread open)
Thread 1 opened at log sequence 9745
  Current log# 3 seq# 9745 mem# 0: F:\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Fri Mar 03 01:57:09 2017
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Mar 03 01:57:09 2017
ARC1: STARTING ARCH PROCESSES
Fri Mar 03 01:57:09 2017
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Mar 03 01:57:09 2017
ARC2: Archival started
ARC1: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the heartbeat ARCH
ARC2 started with pid=82, OS id=4740
Fri Mar 03 01:57:09 2017
ARC0: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
Fri Mar 03 01:57:09 2017
SMON: enabling cache recovery
Fri Mar 03 01:57:10 2017
Successfully onlined Undo Tablespace 1.
Fri Mar 03 01:57:10 2017
SMON: enabling tx recovery
Fri Mar 03 01:57:10 2017
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 4, CPUs = 4
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Mar 03 01:57:10 2017
ARC0: Standby redo logfile selected for thread 1 sequence 9744 for destination LOG_ARCHIVE_DEST_2
Fri Mar 03 01:57:10 2017
Starting background process QMNC
QMNC started with pid=86, OS id=3580
Fri Mar 03 01:57:11 2017
Completed: alter database open
Fri Mar 03 01:57:11 2017
db_recovery_file_dest_size of 204800 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.
Fri Mar 03 01:58:06 2017
Shutting down archive processes
Fri Mar 03 01:58:11 2017
ARCH shutting down
ARC2: Archival stopped
Dump file d:\oracle\product\10.2.0\admin\orcl\bdump\alert_orcl.log
Fri Mar 03 02:01:31 2017
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU                 : 16 - type 8664, 16 Physical Cores
Process Affinity    : 0x0000000000000000
Memory (Avail/Total): Ph:15336M/16383M, Ph+PgF:31709M/32765M
Fri Mar 03 02:01:31 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =110
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
  processes                = 900
  sessions                 = 1000
  shared_pool_size         = 1073741824
  large_pool_size          = 33554432
  java_pool_size           = 33554432
  nls_language             = SIMPLIFIED CHINESE
  nls_territory            = CHINA
  control_files            = F:\ORADATA\ORCL\CONTROL01.CTL, F:\ORADATA\ORCL\CONTROL02.CTL, F:\ORADATA\ORCL\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 3221225472
  db_recycle_cache_size    = 0
  db_writer_processes      = 4
  compatible               = 10.2.0.3.0
  log_archive_config       = dg_config=(orcl,mh)
  log_archive_dest_1       = LOCATION=d:\archlog
  log_archive_dest_2       = service=mh LGWR SYNC affirm valid_for=(online_logfiles,primary_role) db_unique_name=mh
  log_archive_dest_state_1 = ENABLE
  log_archive_dest_state_2 = ENABLE
  log_archive_format       = ARC%S_%R.%T
  fal_client               = PRIMARY
  fal_server               = MH
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = D:\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 214748364800
  standby_file_management  = AUTO
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=orclXDB)
  job_queue_processes      = 10
  audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
  db_name                  = orcl
  db_unique_name           = ORCL
  open_cursors             = 900
  pga_aggregate_target     = 2147483648
PSP0 started with pid=6, OS id=1904
MMAN started with pid=10, OS id=1908
DBW0 started with pid=18, OS id=1920
PMON started with pid=2, OS id=1900
DBW1 started with pid=22, OS id=1924
DBW2 started with pid=26, OS id=1928
DBW3 started with pid=30, OS id=1932
LGWR started with pid=34, OS id=1936
CKPT started with pid=38, OS id=1940
SMON started with pid=42, OS id=1944
RECO started with pid=46, OS id=1948
CJQ0 started with pid=50, OS id=1952
MMON started with pid=54, OS id=1956
Fri Mar 03 02:01:36 2017
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=58, OS id=1960
Fri Mar 03 02:01:36 2017
starting up 1 shared server(s) ...
Fri Mar 03 02:01:36 2017
alter database mount exclusive
Fri Mar 03 02:01:40 2017
Setting recovery target incarnation to 2
Fri Mar 03 02:01:40 2017
Successful mount of redo thread 1, with mount id 1465343232
Fri Mar 03 02:01:40 2017
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Mar 03 02:01:40 2017
alter database open
Fri Mar 03 02:01:40 2017
Beginning crash recovery of 1 threads
 parallel recovery started with 15 processes
Archivelog destination LOG_ARCHIVE_DEST_2 validated for no-data-loss recovery
ARCH: Standby redo logfile selected for thread 1 sequence 9745 for destination LOG_ARCHIVE_DEST_2
Fri Mar 03 02:01:41 2017
Started redo scan
Fri Mar 03 02:01:41 2017
Completed redo scan
 76 redo blocks read, 39 data blocks need recovery
Fri Mar 03 02:01:41 2017
Started redo application at
 Thread 1: logseq 9745, block 3
Fri Mar 03 02:01:41 2017
Recovery of Online Redo Log: Thread 1 Group 3 Seq 9745 Reading mem 0
  Mem# 0: F:\ORADATA\ORCL\REDO03.LOG
Fri Mar 03 02:01:41 2017
Completed redo application
Fri Mar 03 02:01:41 2017
Completed crash recovery at
 Thread 1: logseq 9745, block 79, scn 36040276976
 39 data blocks read, 39 data blocks written, 76 redo blocks read
Fri Mar 03 02:01:41 2017
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=130, OS id=1152
Fri Mar 03 02:01:41 2017
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=134, OS id=1164
Fri Mar 03 02:01:41 2017
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
Fri Mar 03 02:01:41 2017
Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNSb started with pid=138, OS id=1216
Fri Mar 03 02:01:45 2017
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
LGWR: Standby redo logfile selected for thread 1 sequence 9746 for destination LOG_ARCHIVE_DEST_2
Fri Mar 03 02:01:45 2017
Thread 1 advanced to log sequence 9746 (thread open)
Thread 1 opened at log sequence 9746
  Current log# 1 seq# 9746 mem# 0: F:\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Fri Mar 03 02:01:45 2017
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Mar 03 02:01:45 2017
ARC1: STARTING ARCH PROCESSES
Fri Mar 03 02:01:45 2017
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Mar 03 02:01:45 2017
ARC2: Archival started
ARC1: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the heartbeat ARCH
ARC2 started with pid=142, OS id=1220
Fri Mar 03 02:01:45 2017
SMON: enabling cache recovery
Fri Mar 03 02:01:45 2017
Successfully onlined Undo Tablespace 1.
Fri Mar 03 02:01:45 2017
SMON: enabling tx recovery
Fri Mar 03 02:01:45 2017
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 4, CPUs = 4
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=146, OS id=1332
Fri Mar 03 02:01:47 2017
Completed: alter database open
Fri Mar 03 02:01:47 2017
db_recovery_file_dest_size of 204800 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.
Fri Mar 03 02:02:35 2017
WARNING: inbound connection timed out (ORA-3136)
Fri Mar 03 02:02:41 2017
Shutting down archive processes
Fri Mar 03 02:02:46 2017
ARCH shutting down
ARC2: Archival stopped
Fri Mar 03 05:00:49 2017
Process m000 died, see its trace file
Fri Mar 03 05:00:49 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:01:50 2017
Process m000 died, see its trace file
Fri Mar 03 05:01:50 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:02:51 2017
Process m000 died, see its trace file
Fri Mar 03 05:02:51 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:03:52 2017
Process m000 died, see its trace file
Fri Mar 03 05:03:52 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:04:54 2017
Process m000 died, see its trace file
Fri Mar 03 05:04:54 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:05:55 2017
Process m000 died, see its trace file
Fri Mar 03 05:05:55 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:06:56 2017
Process m000 died, see its trace file
Fri Mar 03 05:06:56 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:07:57 2017
Process m000 died, see its trace file
Fri Mar 03 05:07:57 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:08:58 2017
Process m000 died, see its trace file
Fri Mar 03 05:08:58 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:10:00 2017
Process m000 died, see its trace file
Fri Mar 03 05:10:00 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:11:01 2017
Process m000 died, see its trace file
Fri Mar 03 05:11:01 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:12:02 2017
Process m000 died, see its trace file
Fri Mar 03 05:12:02 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:13:03 2017
Process m000 died, see its trace file
Fri Mar 03 05:13:03 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:14:05 2017
Process m000 died, see its trace file
Fri Mar 03 05:14:05 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:15:06 2017
Process m000 died, see its trace file
Fri Mar 03 05:15:06 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:16:07 2017
Process m000 died, see its trace file
Fri Mar 03 05:16:07 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:17:08 2017
Process m000 died, see its trace file
Fri Mar 03 05:17:08 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:18:10 2017
Process m000 died, see its trace file
Fri Mar 03 05:18:10 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:19:11 2017
Process m000 died, see its trace file
Fri Mar 03 05:19:11 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:20:12 2017
Process m000 died, see its trace file
Fri Mar 03 05:20:12 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:21:13 2017
Process m000 died, see its trace file
Fri Mar 03 05:21:13 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:22:15 2017
Process m000 died, see its trace file
Fri Mar 03 05:22:15 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:23:16 2017
Process m000 died, see its trace file
Fri Mar 03 05:23:16 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:24:17 2017
Process m000 died, see its trace file
Fri Mar 03 05:24:17 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:25:18 2017
Process m000 died, see its trace file
Fri Mar 03 05:25:18 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:26:19 2017
Process m000 died, see its trace file
Fri Mar 03 05:26:19 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:27:21 2017
Process m000 died, see its trace file
Fri Mar 03 05:27:21 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:28:22 2017
Process m000 died, see its trace file
Fri Mar 03 05:28:22 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:29:23 2017
Process m000 died, see its trace file
Fri Mar 03 05:29:23 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:30:24 2017
Process m000 died, see its trace file
Fri Mar 03 05:30:24 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:31:26 2017
Process m000 died, see its trace file
Fri Mar 03 05:31:26 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:32:27 2017
Process m000 died, see its trace file
Fri Mar 03 05:32:27 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:33:28 2017
Process m000 died, see its trace file
Fri Mar 03 05:33:28 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:34:29 2017
Process m000 died, see its trace file
Fri Mar 03 05:34:29 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:35:31 2017
Process m000 died, see its trace file
Fri Mar 03 05:35:31 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:36:32 2017
Process m000 died, see its trace file
Fri Mar 03 05:36:32 2017
ksvcreate: Process(m000) creation failed
Fri Mar 03 05:37:33 2017
Process m000 died, see its trace file
Fri Mar 03 05:37:33 2017
0 0
原创粉丝点击