实例启动过程 11g rac
来源:互联网 发布:cnc数控编程招聘 编辑:程序博客网 时间:2024/06/18 06:11
Sat Dec 05 20:54:02 2015
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = 189 GB
Total Shared Global Region in Large Pages = 48 GB (100%)
Large Pages used by this instance: 24577 (48 GB)
Large Pages unused system wide = 56320 (110 GB)
Large Pages configured system wide = 81920 (160 GB)
Large Page size = 2048 KB
********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 16
Number of processor cores in the system is 8
Number of processor sockets in the system is 2
Private Interface 'bondib0:1' configured from GPnP for use as a private interconnect.
[name='bondib0:1', type=1, ip=169.254.108.196, mac=80-00-00-48-fe-80-00-00-00-00-00-00-00-10-00-00-00-00-00-00, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
Public Interface 'bondeth0' configured from GPnP for use as a public interface.
[name='bondeth0', type=1, ip=10.9.3.11, mac=90-e2-ba-4f-e7-b8, net=10.9.3.0/25, mask=255.255.255.128, use=public/1]
Public Interface 'bondeth0:1' configured from GPnP for use as a public interface.
[name='bondeth0:1', type=1, ip=10.9.3.17, mac=90-e2-ba-4f-e7-b8, net=10.9.3.0/25, mask=255.255.255.128, use=public/1]
Public Interface 'bondeth0:2' configured from GPnP for use as a public interface.
[name='bondeth0:2', type=1, ip=10.9.3.13, mac=90-e2-ba-4f-e7-b8, net=10.9.3.0/25, mask=255.255.255.128, use=public/1]
CELL communication is configured to use 1 interface(s):
192.168.10.1
CELL IP affinity details:
NUMA status: non-NUMA system
cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
Grp 0: *192.168.10.1
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /u01/PROD/db/tech_st/11.2.0
System name: Linux
Node name: erpdb01.szgas.com
Release: 2.6.39-400.128.21.el5uek
Version: #1 SMP Thu Apr 2 15:13:06 PDT 2015
Machine: x86_64
Using parameter settings in server-side spfile /u01/PROD/db/tech_st/11.2.0/dbs/spfilePROD1.ora
System parameters with non-default values:
processes = 4000
sessions = 8000
shared_pool_size = 2G
shared_pool_reserved_size= 736M
nls_territory = "america"
nls_sort = "binary"
nls_date_format = "DD-MON-RR"
nls_numeric_characters = ".,"
nls_comp = "binary"
nls_length_semantics = "BYTE"
resource_manager_plan = ""
_lm_global_posts = TRUE
sga_target = 48G
control_files = "+DATA_ERP/prod/controlfile/current.291.835911765"
control_files = "+RECO_ERP/prod/controlfile/current.298.835911765"
db_file_name_convert = "+DATA_ERP/prod/datafile"
db_file_name_convert = "/u01/PROD/db/apps_st/data"
db_file_name_convert = "+DATA_ERP/prod/tempfile"
db_file_name_convert = "/u01/PROD/db/apps_st/data"
db_file_name_convert = "+DATA_ERP/prod/controlfile"
db_file_name_convert = "/u01/PROD/db/apps_st/data"
db_file_name_convert = "+RECO_ERP/prod/controlfile"
db_file_name_convert = "/u01/PROD/db/apps_st/data"
log_file_name_convert = "+DATA_ERP/prod/onlinelog"
log_file_name_convert = "/u01/PROD/db/apps_st/data"
log_file_name_convert = "+RECO_ERP/prod/onlinelog"
log_file_name_convert = "/u01/PROD/db/apps_st/data"
db_block_checksum = "TRUE"
db_block_size = 8192
_immediate_commit_propagation= TRUE
compatible = "11.2.0.4.0"
log_archive_dest_1 = "LOCATION=+RECO_ERP VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD"
log_archive_dest_2 = "SERVICE=PRODS LGWR ASYNC=20480 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRODS OPTIONAL REOPEN=15 MAX_FAILURE=10 NET_TIMEOUT=30"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "ENABLE"
log_archive_min_succeed_dest= 1
fal_server = "PRODS"
log_archive_config = "dg_config=(PROD,PRODS)"
log_archive_format = "prod_%s_%t_%r.arc"
log_buffer = 10485760
log_checkpoint_interval = 100000
log_checkpoint_timeout = 1200
db_files = 512
cluster_database = TRUE
db_create_file_dest = "+DATA_ERP"
db_recovery_file_dest = "+RECO_ERP"
db_recovery_file_dest_size= 100G
standby_file_management = "AUTO"
thread = 1
log_checkpoints_to_alert = TRUE
dml_locks = 10000
undo_management = "AUTO"
undo_tablespace = "APPS_UNDOTS1"
instance_number = 1
db_block_checking = "FALSE"
_disable_fast_validate = TRUE
ldap_directory_access = "PASSWORD"
sec_case_sensitive_logon = FALSE
O7_DICTIONARY_ACCESSIBILITY= FALSE
audit_sys_operations = TRUE
service_names = "PROD"
local_listener = "erp01-vip:1521"
remote_listener = "erp-scan:1521"
session_cached_cursors = 500
utl_file_dir = "/usr/tmp"
utl_file_dir = "/usr/tmp"
utl_file_dir = "/u01/PROD/db/tech_st/11.2.0/appsutil/outbound/PROD_erpdb01"
utl_file_dir = "/u01/PROD/db/tech_st/11.2.0/appsutil/outbound/PROD_erpdb01"
utl_file_dir = "/usr/tmp"
plsql_code_type = "INTERPRETED"
plsql_optimize_level = 2
job_queue_processes = 10
_system_trig_enabled = TRUE
cursor_sharing = "EXACT"
parallel_min_servers = 0
parallel_max_servers = 8
session_max_open_files = 20
audit_trail = "DB"
audit_trail = "EXTENDED"
db_name = "PROD"
db_unique_name = "PROD"
open_cursors = 2000
os_authent_prefix = ""
_sort_elimination_cost_ratio= 5
sql92_security = TRUE
_b_tree_bitmap_plans = FALSE
_fast_full_scan_enabled = FALSE
_like_with_bind_as_equality= TRUE
pga_aggregate_target = 12G
workarea_size_policy = "AUTO"
_optimizer_autostats_job = FALSE
optimizer_secure_view_merging= FALSE
aq_tm_processes = 1
olap_page_pool_size = 4M
diagnostic_dest = "/u01/PROD/db/tech_st/11.2.0/admin/PROD_erpdb"
_trace_files_public = TRUE
max_dump_file_size = "UNLIMITED"
KSXP: setting socket save mode to 0
Cluster communication is configured to use the following interface(s) for this instance
169.254.108.196
cluster interconnect IPC version:Oracle RDS/IP (generic)
IPC Vendor 1 proto 3
Version 4.1
Sat Dec 05 20:54:10 2015
PMON started with pid=2, OS id=24661
Sat Dec 05 20:54:10 2015
PSP0 started with pid=3, OS id=24663
Sat Dec 05 20:54:11 2015
VKTM started with pid=4, OS id=24680 at elevated priority
Sat Dec 05 20:54:11 2015
GEN0 started with pid=5, OS id=24684
Sat Dec 05 20:54:11 2015
DIAG started with pid=6, OS id=24686
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sat Dec 05 20:54:11 2015
DBRM started with pid=7, OS id=24688
Sat Dec 05 20:54:11 2015
PING started with pid=8, OS id=24690
Sat Dec 05 20:54:11 2015
ACMS started with pid=9, OS id=24692
Sat Dec 05 20:54:11 2015
DSKM started with pid=10, OS id=24694
Sat Dec 05 20:54:11 2015
DIA0 started with pid=11, OS id=24696
Sat Dec 05 20:54:11 2015
LMON started with pid=12, OS id=24698
Sat Dec 05 20:54:11 2015
LMD0 started with pid=13, OS id=24700
Sat Dec 05 20:54:11 2015
LMS0 started with pid=14, OS id=24702 at elevated priority
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [15360 - 20480]
Sat Dec 05 20:54:11 2015
LMS1 started with pid=15, OS id=24707 at elevated priority
Sat Dec 05 20:54:11 2015
RMS0 started with pid=16, OS id=24711
Sat Dec 05 20:54:11 2015
LMHB started with pid=17, OS id=24713
Sat Dec 05 20:54:11 2015
MMAN started with pid=18, OS id=24715
Sat Dec 05 20:54:11 2015
DBW0 started with pid=19, OS id=24717
Sat Dec 05 20:54:11 2015
DBW1 started with pid=20, OS id=24719
Sat Dec 05 20:54:11 2015
LGWR started with pid=21, OS id=24721
Sat Dec 05 20:54:11 2015
CKPT started with pid=22, OS id=24723
Sat Dec 05 20:54:11 2015
SMON started with pid=23, OS id=24725
Sat Dec 05 20:54:11 2015
RECO started with pid=24, OS id=24727
Sat Dec 05 20:54:11 2015
RBAL started with pid=25, OS id=24729
Sat Dec 05 20:54:11 2015
ASMB started with pid=26, OS id=24731
Sat Dec 05 20:54:11 2015
MMON started with pid=27, OS id=24733
Sat Dec 05 20:54:11 2015
MMNL started with pid=28, OS id=24735
NOTE: initiating MARK startup
Starting background process MARK
Sat Dec 05 20:54:11 2015
MARK started with pid=29, OS id=24739
NOTE: MARK has subscribed
lmon registered with NM - instance number 1 (internal mem no 0)
Reconfiguration started (old inc 0, new inc 8)
List of instances:
1 2 (myinst: 1)
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
* domain 0 valid according to instance 2
* domain 0 valid = 1 according to instance 2
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete
Sat Dec 05 20:54:15 2015
LCK0 started with pid=31, OS id=24774
Sat Dec 05 20:54:15 2015
Starting background process RSMN
Sat Dec 05 20:54:15 2015
RSMN started with pid=32, OS id=24782
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Reusing ORACLE_BASE from an earlier startup = /u01/PROD/db
Sat Dec 05 20:54:16 2015
ALTER DATABASE MOUNT
NOTE: Loaded library: OSS
NOTE: Loaded library: System
SUCCESS: diskgroup DATA_ERP was mounted
NOTE: dependency between database PROD and diskgroup resource ora.DATA_ERP.dg is established
SUCCESS: diskgroup RECO_ERP was mounted
NOTE: dependency between database PROD and diskgroup resource ora.RECO_ERP.dg is established
Process LGWR (pid 24721) is running at high priority QoS for Exadata I/O
Successful mount of redo thread 1, with mount id 298689267
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Sat Dec 05 20:54:21 2015
ALTER DATABASE OPEN
Picked broadcast on commit scheme to generate SCNs
ARCH: STARTING ARCH PROCESSES
Sat Dec 05 20:54:21 2015
ARC0 started with pid=34, OS id=24853
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sat Dec 05 20:54:21 2015
ARC1 started with pid=36, OS id=24855
Sat Dec 05 20:54:21 2015
ARC2 started with pid=37, OS id=24857
Sat Dec 05 20:54:21 2015
ARC3 started with pid=38, OS id=24859
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sat Dec 05 20:54:22 2015
Thread 1 advanced to log sequence 4313 (thread open)
Thread 1 opened at log sequence 4313
Current log# 5 seq# 4313 mem# 0: +DATA_ERP/prod/onlinelog/group_5.300.835913161
Current log# 5 seq# 4313 mem# 1: +RECO_ERP/prod/onlinelog/group_5.295.835913161
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Dec 05 20:54:22 2015
SMON: enabling cache recovery
Sat Dec 05 20:54:22 2015
NSA2 started with pid=40, OS id=24863
Archived Log entry 14700 added for thread 1 sequence 4312 ID 0xec4bf72 dest 1:
[24848] Successfully onlined Undo Tablespace 368.
Undo initialization finished serial:0 start:4294503010 end:4294504330 diff:1320 (13 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is AL32UTF8
Sat Dec 05 20:54:23 2015
Incremental checkpoint up to RBA [0x10d9.2.0], current log tail at RBA [0x10d9.7e.0]
No Resource Manager plan active
Sat Dec 05 20:54:23 2015
minact-scn: Inst 1 is a slave inc#:8 mmon proc-id:24733 status:0x2
minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000
Starting background process GTX0
Sat Dec 05 20:54:24 2015
GTX0 started with pid=42, OS id=24888
Starting background process RCBG
Sat Dec 05 20:54:24 2015
RCBG started with pid=43, OS id=24890
replication_dependency_tracking turned off (no async multimaster replication found)
ARC3: Standby redo logfile selected for thread 1 sequence 4312 for destination LOG_ARCHIVE_DEST_2
Starting background process QMNC
Sat Dec 05 20:54:24 2015
QMNC started with pid=44, OS id=24894
Starting background process EMNC
Completed: ALTER DATABASE OPEN
Sat Dec 05 20:54:25 2015
EMNC started with pid=49, OS id=24920
Beginning log switch checkpoint up to RBA [0x10da.2.10], SCN: 5980377074547
Thread 1 advanced to log sequence 4314 (LGWR switch)
Current log# 1 seq# 4314 mem# 0: +DATA_ERP/prod/onlinelog/group_1.296.835913153
Current log# 1 seq# 4314 mem# 1: +RECO_ERP/prod/onlinelog/group_1.273.835913153
Archived Log entry 14702 added for thread 1 sequence 4313 ID 0xec4bf72 dest 1:
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
ARC3: Standby redo logfile selected for thread 1 sequence 4313 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 4314 for destination LOG_ARCHIVE_DEST_2
Sat Dec 05 20:59:13 2015
XDB installed.
XDB initialized.
Sat Dec 05 20:59:32 2015
Completed checkpoint up to RBA [0x10da.2.10], SCN: 5980377074547
Sat Dec 05 21:00:01 2015
Starting background process SMCO
Sat Dec 05 21:00:01 2015
SMCO started with pid=82, OS id=30324
Sat Dec 05 21:14:27 2015
Incremental checkpoint up to RBA [0x10da.8de0.0], current log tail at RBA [0x10da.b8f2.0]
Sat Dec 05 21:34:16 2015
Starting background process CJQ0
Sat Dec 05 21:34:16 2015
CJQ0 started with pid=99, OS id=62985
Sat Dec 05 21:34:30 2015
Incremental checkpoint up to RBA [0x10da.4f262.0], current log tail at RBA [0x10da.678d3.0]
Sat Dec 05 21:54:34 2015
Incremental checkpoint up to RBA [0x10da.6e1e7.0], current log tail at RBA [0x10da.70892.0]
Sat Dec 05 22:00:00 2015
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sat Dec 05 22:00:00 2015
Starting background process VKRM
Sat Dec 05 22:00:00 2015
VKRM started with pid=88, OS id=85406
Sat Dec 05 22:14:37 2015
Incremental checkpoint up to RBA [0x10da.7bf77.0], current log tail at RBA [0x10da.7e240.0]
Sat Dec 05 22:34:41 2015
Incremental checkpoint up to RBA [0x10da.c2b59.0], current log tail at RBA [0x10da.db1d1.0]
Sat Dec 05 22:54:44 2015
Incremental checkpoint up to RBA [0x10da.e19a1.0], current log tail at RBA [0x10da.e3b20.0]
Sat Dec 05 23:14:47 2015
Incremental checkpoint up to RBA [0x10da.eb391.0], current log tail at RBA [0x10da.ed43a.0]
Sat Dec 05 23:34:51 2015
Incremental checkpoint up to RBA [0x10da.131417.0], current log tail at RBA [0x10da.149aa1.0]
Sat Dec 05 23:54:55 2015
Incremental checkpoint up to RBA [0x10da.1501f5.0], current log tail at RBA [0x10da.152507.0]
Sun Dec 06 00:14:58 2015
Incremental checkpoint up to RBA [0x10da.174556.0], current log tail at RBA [0x10da.176669.0]
Sun Dec 06 00:32:29 2015
Beginning log switch checkpoint up to RBA [0x10db.2.10], SCN: 5980379295678
Thread 1 advanced to log sequence 4315 (LGWR switch)
Current log# 2 seq# 4315 mem# 0: +DATA_ERP/prod/onlinelog/group_2.297.835913155
Current log# 2 seq# 4315 mem# 1: +RECO_ERP/prod/onlinelog/group_2.290.835913155
Sun Dec 06 00:32:30 2015
LNS: Standby redo logfile selected for thread 1 sequence 4315 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 00:32:35 2015
Archived Log entry 14706 added for thread 1 sequence 4314 ID 0xec4bf72 dest 1:
Sun Dec 06 00:35:02 2015
Incremental checkpoint up to RBA [0x10da.1ba3b2.0], current log tail at RBA [0x10db.1454b.0]
Sun Dec 06 00:37:35 2015
Completed checkpoint up to RBA [0x10db.2.10], SCN: 5980379295678
Sun Dec 06 00:55:10 2015
Incremental checkpoint up to RBA [0x10db.1b1ee.0], current log tail at RBA [0x10db.1d43d.0]
Sun Dec 06 01:02:32 2015
ALTER SYSTEM ARCHIVE LOG
Sun Dec 06 01:02:32 2015
Beginning log switch checkpoint up to RBA [0x10dc.2.10], SCN: 5980379464852
Thread 1 advanced to log sequence 4316 (LGWR switch)
Current log# 5 seq# 4316 mem# 0: +DATA_ERP/prod/onlinelog/group_5.300.835913161
Current log# 5 seq# 4316 mem# 1: +RECO_ERP/prod/onlinelog/group_5.295.835913161
Sun Dec 06 01:02:32 2015
LNS: Standby redo logfile selected for thread 1 sequence 4316 for destination LOG_ARCHIVE_DEST_2
Archived Log entry 14708 added for thread 1 sequence 4315 ID 0xec4bf72 dest 1:
ALTER SYSTEM ARCHIVE LOG
Beginning log switch checkpoint up to RBA [0x10dd.2.10], SCN: 5980379465017
Thread 1 advanced to log sequence 4317 (LGWR switch)
Current log# 1 seq# 4317 mem# 0: +DATA_ERP/prod/onlinelog/group_1.296.835913153
Current log# 1 seq# 4317 mem# 1: +RECO_ERP/prod/onlinelog/group_1.273.835913153
LNS: Standby redo logfile selected for thread 1 sequence 4317 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 01:02:36 2015
Archived Log entry 14712 added for thread 1 sequence 4316 ID 0xec4bf72 dest 1:
Sun Dec 06 01:07:32 2015
Completed checkpoint up to RBA [0x10dd.2.10], SCN: 5980379465017
Completed checkpoint up to RBA [0x10dc.2.10], SCN: 5980379464852
Sun Dec 06 01:15:14 2015
Incremental checkpoint up to RBA [0x10dd.3377.0], current log tail at RBA [0x10dd.533a.0]
Sun Dec 06 01:35:18 2015
Incremental checkpoint up to RBA [0x10dd.4dc57.0], current log tail at RBA [0x10dd.66304.0]
Sun Dec 06 01:55:21 2015
Incremental checkpoint up to RBA [0x10dd.6cb27.0], current log tail at RBA [0x10dd.6eee9.0]
Sun Dec 06 02:15:25 2015
Incremental checkpoint up to RBA [0x10dd.8b7af.0], current log tail at RBA [0x10dd.a3df5.0]
Sun Dec 06 02:35:28 2015
Incremental checkpoint up to RBA [0x10dd.e79fc.0], current log tail at RBA [0x10dd.100088.0]
Sun Dec 06 02:55:32 2015
Incremental checkpoint up to RBA [0x10dd.106916.0], current log tail at RBA [0x10dd.108d9e.0]
Sun Dec 06 03:15:35 2015
Incremental checkpoint up to RBA [0x10dd.110919.0], current log tail at RBA [0x10dd.112b04.0]
Sun Dec 06 03:35:39 2015
Incremental checkpoint up to RBA [0x10dd.154cf7.0], current log tail at RBA [0x10dd.16d366.0]
Sun Dec 06 03:55:42 2015
Incremental checkpoint up to RBA [0x10dd.173d88.0], current log tail at RBA [0x10dd.176018.0]
Sun Dec 06 04:15:45 2015
Incremental checkpoint up to RBA [0x10dd.17d88b.0], current log tail at RBA [0x10dd.17f861.0]
Sun Dec 06 04:31:21 2015
Beginning log switch checkpoint up to RBA [0x10de.2.10], SCN: 5980380955820
Thread 1 advanced to log sequence 4318 (LGWR switch)
Current log# 2 seq# 4318 mem# 0: +DATA_ERP/prod/onlinelog/group_2.297.835913155
Current log# 2 seq# 4318 mem# 1: +RECO_ERP/prod/onlinelog/group_2.290.835913155
Sun Dec 06 04:31:21 2015
LNS: Standby redo logfile selected for thread 1 sequence 4318 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 04:31:28 2015
Archived Log entry 14714 added for thread 1 sequence 4317 ID 0xec4bf72 dest 1:
Sun Dec 06 04:31:49 2015
Completed checkpoint up to RBA [0x10de.2.10], SCN: 5980380955820
Sun Dec 06 04:35:50 2015
Incremental checkpoint up to RBA [0x10de.37a4a.0], current log tail at RBA [0x10de.500e4.0]
Sun Dec 06 04:55:53 2015
Incremental checkpoint up to RBA [0x10de.56833.0], current log tail at RBA [0x10de.58a24.0]
Sun Dec 06 05:15:56 2015
Incremental checkpoint up to RBA [0x10de.60731.0], current log tail at RBA [0x10de.62683.0]
Sun Dec 06 05:36:00 2015
Incremental checkpoint up to RBA [0x10de.a6264.0], current log tail at RBA [0x10de.be8bf.0]
Sun Dec 06 05:56:03 2015
Incremental checkpoint up to RBA [0x10de.c4d2e.0], current log tail at RBA [0x10de.c706f.0]
Sun Dec 06 06:16:07 2015
Incremental checkpoint up to RBA [0x10de.133f68.0], current log tail at RBA [0x10de.136777.0]
Sun Dec 06 06:36:11 2015
Incremental checkpoint up to RBA [0x10de.17a453.0], current log tail at RBA [0x10de.192b02.0]
Sun Dec 06 06:56:14 2015
Incremental checkpoint up to RBA [0x10de.199226.0], current log tail at RBA [0x10de.19b622.0]
Sun Dec 06 07:16:17 2015
Incremental checkpoint up to RBA [0x10de.1a3496.0], current log tail at RBA [0x10de.1a5486.0]
Sun Dec 06 07:31:17 2015
Beginning log switch checkpoint up to RBA [0x10df.2.10], SCN: 5980382730343
Thread 1 advanced to log sequence 4319 (LGWR switch)
Current log# 5 seq# 4319 mem# 0: +DATA_ERP/prod/onlinelog/group_5.300.835913161
Current log# 5 seq# 4319 mem# 1: +RECO_ERP/prod/onlinelog/group_5.295.835913161
Sun Dec 06 07:31:17 2015
LNS: Standby redo logfile selected for thread 1 sequence 4319 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 07:31:24 2015
Archived Log entry 14717 added for thread 1 sequence 4318 ID 0xec4bf72 dest 1:
Sun Dec 06 07:31:57 2015
Completed checkpoint up to RBA [0x10df.2.10], SCN: 5980382730343
Sun Dec 06 07:36:20 2015
Incremental checkpoint up to RBA [0x10df.2ae29.0], current log tail at RBA [0x10df.4339d.0]
Sun Dec 06 07:56:24 2015
Incremental checkpoint up to RBA [0x10df.49bca.0], current log tail at RBA [0x10df.4bf1f.0]
Sun Dec 06 08:16:27 2015
Incremental checkpoint up to RBA [0x10df.53bcd.0], current log tail at RBA [0x10df.56760.0]
Sun Dec 06 08:36:32 2015
Incremental checkpoint up to RBA [0x10df.9b891.0], current log tail at RBA [0x10df.b3f10.0]
Sun Dec 06 08:56:35 2015
Incremental checkpoint up to RBA [0x10df.bafe7.0], current log tail at RBA [0x10df.bd3ff.0]
Sun Dec 06 09:16:38 2015
Incremental checkpoint up to RBA [0x10df.c532a.0], current log tail at RBA [0x10df.c7319.0]
Sun Dec 06 09:36:42 2015
Incremental checkpoint up to RBA [0x10df.10b5ab.0], current log tail at RBA [0x10df.123c63.0]
Sun Dec 06 09:56:45 2015
Incremental checkpoint up to RBA [0x10df.12bc41.0], current log tail at RBA [0x10df.12e34f.0]
Sun Dec 06 10:16:48 2015
Incremental checkpoint up to RBA [0x10df.13610e.0], current log tail at RBA [0x10df.138528.0]
Sun Dec 06 10:36:52 2015
Incremental checkpoint up to RBA [0x10df.17d116.0], current log tail at RBA [0x10df.19573b.0]
Sun Dec 06 10:43:11 2015
Beginning log switch checkpoint up to RBA [0x10e0.2.10], SCN: 5980384204730
Thread 1 advanced to log sequence 4320 (LGWR switch)
Current log# 1 seq# 4320 mem# 0: +DATA_ERP/prod/onlinelog/group_1.296.835913153
Current log# 1 seq# 4320 mem# 1: +RECO_ERP/prod/onlinelog/group_1.273.835913153
Sun Dec 06 10:43:11 2015
LNS: Standby redo logfile selected for thread 1 sequence 4320 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 10:43:16 2015
Archived Log entry 14719 added for thread 1 sequence 4319 ID 0xec4bf72 dest 1:
Sun Dec 06 10:48:15 2015
Completed checkpoint up to RBA [0x10e0.2.10], SCN: 5980384204730
Sun Dec 06 10:56:56 2015
Incremental checkpoint up to RBA [0x10e0.a245.0], current log tail at RBA [0x10e0.c6b0.0]
Sun Dec 06 11:16:59 2015
Incremental checkpoint up to RBA [0x10e0.14e80.0], current log tail at RBA [0x10e0.16ffd.0]
Sun Dec 06 11:37:04 2015
Incremental checkpoint up to RBA [0x10e0.a9e1c.0], current log tail at RBA [0x10e0.c24bf.0]
Sun Dec 06 11:57:08 2015
Incremental checkpoint up to RBA [0x10e0.ca88c.0], current log tail at RBA [0x10e0.cd911.0]
Sun Dec 06 12:17:12 2015
Incremental checkpoint up to RBA [0x10e0.ed9bd.0], current log tail at RBA [0x10e0.efd1e.0]
Sun Dec 06 12:37:16 2015
Incremental checkpoint up to RBA [0x10e0.131ccf.0], current log tail at RBA [0x10e0.14a340.0]
Sun Dec 06 12:57:19 2015
Incremental checkpoint up to RBA [0x10e0.153d97.0], current log tail at RBA [0x10e0.1571eb.0]
Sun Dec 06 13:17:22 2015
Incremental checkpoint up to RBA [0x10e0.1605d6.0], current log tail at RBA [0x10e0.162902.0]
Sun Dec 06 13:36:07 2015
Beginning log switch checkpoint up to RBA [0x10e1.2.10], SCN: 5980385569705
Thread 1 advanced to log sequence 4321 (LGWR switch)
Current log# 2 seq# 4321 mem# 0: +DATA_ERP/prod/onlinelog/group_2.297.835913155
Current log# 2 seq# 4321 mem# 1: +RECO_ERP/prod/onlinelog/group_2.290.835913155
Sun Dec 06 13:36:07 2015
LNS: Standby redo logfile selected for thread 1 sequence 4321 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 13:36:12 2015
Archived Log entry 14721 added for thread 1 sequence 4320 ID 0xec4bf72 dest 1:
Sun Dec 06 13:37:26 2015
Incremental checkpoint up to RBA [0x10e0.1a5d66.0], current log tail at RBA [0x10e1.835.0]
Sun Dec 06 13:41:09 2015
Completed checkpoint up to RBA [0x10e1.2.10], SCN: 5980385569705
Sun Dec 06 13:57:30 2015
Incremental checkpoint up to RBA [0x10e1.7942.0], current log tail at RBA [0x10e1.cef4.0]
Sun Dec 06 14:17:34 2015
Incremental checkpoint up to RBA [0x10e1.152ac.0], current log tail at RBA [0x10e1.17967.0]
Sun Dec 06 14:37:38 2015
Incremental checkpoint up to RBA [0x10e1.7188c.0], current log tail at RBA [0x10e1.74108.0]
Sun Dec 06 14:57:41 2015
Incremental checkpoint up to RBA [0x10e1.7abea.0], current log tail at RBA [0x10e1.7d031.0]
Sun Dec 06 15:17:44 2015
Incremental checkpoint up to RBA [0x10e1.85347.0], current log tail at RBA [0x10e1.8774f.0]
Sun Dec 06 15:37:49 2015
Incremental checkpoint up to RBA [0x10e1.e2435.0], current log tail at RBA [0x10e1.e51f8.0]
Sun Dec 06 15:57:52 2015
Incremental checkpoint up to RBA [0x10e1.ec463.0], current log tail at RBA [0x10e1.eec90.0]
Sun Dec 06 16:17:56 2015
Incremental checkpoint up to RBA [0x10e1.f782e.0], current log tail at RBA [0x10e1.f9d9d.0]
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = 189 GB
Total Shared Global Region in Large Pages = 48 GB (100%)
Large Pages used by this instance: 24577 (48 GB)
Large Pages unused system wide = 56320 (110 GB)
Large Pages configured system wide = 81920 (160 GB)
Large Page size = 2048 KB
********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 16
Number of processor cores in the system is 8
Number of processor sockets in the system is 2
Private Interface 'bondib0:1' configured from GPnP for use as a private interconnect.
[name='bondib0:1', type=1, ip=169.254.108.196, mac=80-00-00-48-fe-80-00-00-00-00-00-00-00-10-00-00-00-00-00-00, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
Public Interface 'bondeth0' configured from GPnP for use as a public interface.
[name='bondeth0', type=1, ip=10.9.3.11, mac=90-e2-ba-4f-e7-b8, net=10.9.3.0/25, mask=255.255.255.128, use=public/1]
Public Interface 'bondeth0:1' configured from GPnP for use as a public interface.
[name='bondeth0:1', type=1, ip=10.9.3.17, mac=90-e2-ba-4f-e7-b8, net=10.9.3.0/25, mask=255.255.255.128, use=public/1]
Public Interface 'bondeth0:2' configured from GPnP for use as a public interface.
[name='bondeth0:2', type=1, ip=10.9.3.13, mac=90-e2-ba-4f-e7-b8, net=10.9.3.0/25, mask=255.255.255.128, use=public/1]
CELL communication is configured to use 1 interface(s):
192.168.10.1
CELL IP affinity details:
NUMA status: non-NUMA system
cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
Grp 0: *192.168.10.1
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /u01/PROD/db/tech_st/11.2.0
System name: Linux
Node name: erpdb01.szgas.com
Release: 2.6.39-400.128.21.el5uek
Version: #1 SMP Thu Apr 2 15:13:06 PDT 2015
Machine: x86_64
Using parameter settings in server-side spfile /u01/PROD/db/tech_st/11.2.0/dbs/spfilePROD1.ora
System parameters with non-default values:
processes = 4000
sessions = 8000
shared_pool_size = 2G
shared_pool_reserved_size= 736M
nls_territory = "america"
nls_sort = "binary"
nls_date_format = "DD-MON-RR"
nls_numeric_characters = ".,"
nls_comp = "binary"
nls_length_semantics = "BYTE"
resource_manager_plan = ""
_lm_global_posts = TRUE
sga_target = 48G
control_files = "+DATA_ERP/prod/controlfile/current.291.835911765"
control_files = "+RECO_ERP/prod/controlfile/current.298.835911765"
db_file_name_convert = "+DATA_ERP/prod/datafile"
db_file_name_convert = "/u01/PROD/db/apps_st/data"
db_file_name_convert = "+DATA_ERP/prod/tempfile"
db_file_name_convert = "/u01/PROD/db/apps_st/data"
db_file_name_convert = "+DATA_ERP/prod/controlfile"
db_file_name_convert = "/u01/PROD/db/apps_st/data"
db_file_name_convert = "+RECO_ERP/prod/controlfile"
db_file_name_convert = "/u01/PROD/db/apps_st/data"
log_file_name_convert = "+DATA_ERP/prod/onlinelog"
log_file_name_convert = "/u01/PROD/db/apps_st/data"
log_file_name_convert = "+RECO_ERP/prod/onlinelog"
log_file_name_convert = "/u01/PROD/db/apps_st/data"
db_block_checksum = "TRUE"
db_block_size = 8192
_immediate_commit_propagation= TRUE
compatible = "11.2.0.4.0"
log_archive_dest_1 = "LOCATION=+RECO_ERP VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD"
log_archive_dest_2 = "SERVICE=PRODS LGWR ASYNC=20480 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRODS OPTIONAL REOPEN=15 MAX_FAILURE=10 NET_TIMEOUT=30"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "ENABLE"
log_archive_min_succeed_dest= 1
fal_server = "PRODS"
log_archive_config = "dg_config=(PROD,PRODS)"
log_archive_format = "prod_%s_%t_%r.arc"
log_buffer = 10485760
log_checkpoint_interval = 100000
log_checkpoint_timeout = 1200
db_files = 512
cluster_database = TRUE
db_create_file_dest = "+DATA_ERP"
db_recovery_file_dest = "+RECO_ERP"
db_recovery_file_dest_size= 100G
standby_file_management = "AUTO"
thread = 1
log_checkpoints_to_alert = TRUE
dml_locks = 10000
undo_management = "AUTO"
undo_tablespace = "APPS_UNDOTS1"
instance_number = 1
db_block_checking = "FALSE"
_disable_fast_validate = TRUE
ldap_directory_access = "PASSWORD"
sec_case_sensitive_logon = FALSE
O7_DICTIONARY_ACCESSIBILITY= FALSE
audit_sys_operations = TRUE
service_names = "PROD"
local_listener = "erp01-vip:1521"
remote_listener = "erp-scan:1521"
session_cached_cursors = 500
utl_file_dir = "/usr/tmp"
utl_file_dir = "/usr/tmp"
utl_file_dir = "/u01/PROD/db/tech_st/11.2.0/appsutil/outbound/PROD_erpdb01"
utl_file_dir = "/u01/PROD/db/tech_st/11.2.0/appsutil/outbound/PROD_erpdb01"
utl_file_dir = "/usr/tmp"
plsql_code_type = "INTERPRETED"
plsql_optimize_level = 2
job_queue_processes = 10
_system_trig_enabled = TRUE
cursor_sharing = "EXACT"
parallel_min_servers = 0
parallel_max_servers = 8
session_max_open_files = 20
audit_trail = "DB"
audit_trail = "EXTENDED"
db_name = "PROD"
db_unique_name = "PROD"
open_cursors = 2000
os_authent_prefix = ""
_sort_elimination_cost_ratio= 5
sql92_security = TRUE
_b_tree_bitmap_plans = FALSE
_fast_full_scan_enabled = FALSE
_like_with_bind_as_equality= TRUE
pga_aggregate_target = 12G
workarea_size_policy = "AUTO"
_optimizer_autostats_job = FALSE
optimizer_secure_view_merging= FALSE
aq_tm_processes = 1
olap_page_pool_size = 4M
diagnostic_dest = "/u01/PROD/db/tech_st/11.2.0/admin/PROD_erpdb"
_trace_files_public = TRUE
max_dump_file_size = "UNLIMITED"
KSXP: setting socket save mode to 0
Cluster communication is configured to use the following interface(s) for this instance
169.254.108.196
cluster interconnect IPC version:Oracle RDS/IP (generic)
IPC Vendor 1 proto 3
Version 4.1
Sat Dec 05 20:54:10 2015
PMON started with pid=2, OS id=24661
Sat Dec 05 20:54:10 2015
PSP0 started with pid=3, OS id=24663
Sat Dec 05 20:54:11 2015
VKTM started with pid=4, OS id=24680 at elevated priority
Sat Dec 05 20:54:11 2015
GEN0 started with pid=5, OS id=24684
Sat Dec 05 20:54:11 2015
DIAG started with pid=6, OS id=24686
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sat Dec 05 20:54:11 2015
DBRM started with pid=7, OS id=24688
Sat Dec 05 20:54:11 2015
PING started with pid=8, OS id=24690
Sat Dec 05 20:54:11 2015
ACMS started with pid=9, OS id=24692
Sat Dec 05 20:54:11 2015
DSKM started with pid=10, OS id=24694
Sat Dec 05 20:54:11 2015
DIA0 started with pid=11, OS id=24696
Sat Dec 05 20:54:11 2015
LMON started with pid=12, OS id=24698
Sat Dec 05 20:54:11 2015
LMD0 started with pid=13, OS id=24700
Sat Dec 05 20:54:11 2015
LMS0 started with pid=14, OS id=24702 at elevated priority
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [15360 - 20480]
Sat Dec 05 20:54:11 2015
LMS1 started with pid=15, OS id=24707 at elevated priority
Sat Dec 05 20:54:11 2015
RMS0 started with pid=16, OS id=24711
Sat Dec 05 20:54:11 2015
LMHB started with pid=17, OS id=24713
Sat Dec 05 20:54:11 2015
MMAN started with pid=18, OS id=24715
Sat Dec 05 20:54:11 2015
DBW0 started with pid=19, OS id=24717
Sat Dec 05 20:54:11 2015
DBW1 started with pid=20, OS id=24719
Sat Dec 05 20:54:11 2015
LGWR started with pid=21, OS id=24721
Sat Dec 05 20:54:11 2015
CKPT started with pid=22, OS id=24723
Sat Dec 05 20:54:11 2015
SMON started with pid=23, OS id=24725
Sat Dec 05 20:54:11 2015
RECO started with pid=24, OS id=24727
Sat Dec 05 20:54:11 2015
RBAL started with pid=25, OS id=24729
Sat Dec 05 20:54:11 2015
ASMB started with pid=26, OS id=24731
Sat Dec 05 20:54:11 2015
MMON started with pid=27, OS id=24733
Sat Dec 05 20:54:11 2015
MMNL started with pid=28, OS id=24735
NOTE: initiating MARK startup
Starting background process MARK
Sat Dec 05 20:54:11 2015
MARK started with pid=29, OS id=24739
NOTE: MARK has subscribed
lmon registered with NM - instance number 1 (internal mem no 0)
Reconfiguration started (old inc 0, new inc 8)
List of instances:
1 2 (myinst: 1)
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
* domain 0 valid according to instance 2
* domain 0 valid = 1 according to instance 2
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete
Sat Dec 05 20:54:15 2015
LCK0 started with pid=31, OS id=24774
Sat Dec 05 20:54:15 2015
Starting background process RSMN
Sat Dec 05 20:54:15 2015
RSMN started with pid=32, OS id=24782
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Reusing ORACLE_BASE from an earlier startup = /u01/PROD/db
Sat Dec 05 20:54:16 2015
ALTER DATABASE MOUNT
NOTE: Loaded library: OSS
NOTE: Loaded library: System
SUCCESS: diskgroup DATA_ERP was mounted
NOTE: dependency between database PROD and diskgroup resource ora.DATA_ERP.dg is established
SUCCESS: diskgroup RECO_ERP was mounted
NOTE: dependency between database PROD and diskgroup resource ora.RECO_ERP.dg is established
Process LGWR (pid 24721) is running at high priority QoS for Exadata I/O
Successful mount of redo thread 1, with mount id 298689267
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Sat Dec 05 20:54:21 2015
ALTER DATABASE OPEN
Picked broadcast on commit scheme to generate SCNs
ARCH: STARTING ARCH PROCESSES
Sat Dec 05 20:54:21 2015
ARC0 started with pid=34, OS id=24853
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sat Dec 05 20:54:21 2015
ARC1 started with pid=36, OS id=24855
Sat Dec 05 20:54:21 2015
ARC2 started with pid=37, OS id=24857
Sat Dec 05 20:54:21 2015
ARC3 started with pid=38, OS id=24859
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sat Dec 05 20:54:22 2015
Thread 1 advanced to log sequence 4313 (thread open)
Thread 1 opened at log sequence 4313
Current log# 5 seq# 4313 mem# 0: +DATA_ERP/prod/onlinelog/group_5.300.835913161
Current log# 5 seq# 4313 mem# 1: +RECO_ERP/prod/onlinelog/group_5.295.835913161
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Dec 05 20:54:22 2015
SMON: enabling cache recovery
Sat Dec 05 20:54:22 2015
NSA2 started with pid=40, OS id=24863
Archived Log entry 14700 added for thread 1 sequence 4312 ID 0xec4bf72 dest 1:
[24848] Successfully onlined Undo Tablespace 368.
Undo initialization finished serial:0 start:4294503010 end:4294504330 diff:1320 (13 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is AL32UTF8
Sat Dec 05 20:54:23 2015
Incremental checkpoint up to RBA [0x10d9.2.0], current log tail at RBA [0x10d9.7e.0]
No Resource Manager plan active
Sat Dec 05 20:54:23 2015
minact-scn: Inst 1 is a slave inc#:8 mmon proc-id:24733 status:0x2
minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000
Starting background process GTX0
Sat Dec 05 20:54:24 2015
GTX0 started with pid=42, OS id=24888
Starting background process RCBG
Sat Dec 05 20:54:24 2015
RCBG started with pid=43, OS id=24890
replication_dependency_tracking turned off (no async multimaster replication found)
ARC3: Standby redo logfile selected for thread 1 sequence 4312 for destination LOG_ARCHIVE_DEST_2
Starting background process QMNC
Sat Dec 05 20:54:24 2015
QMNC started with pid=44, OS id=24894
Starting background process EMNC
Completed: ALTER DATABASE OPEN
Sat Dec 05 20:54:25 2015
EMNC started with pid=49, OS id=24920
Beginning log switch checkpoint up to RBA [0x10da.2.10], SCN: 5980377074547
Thread 1 advanced to log sequence 4314 (LGWR switch)
Current log# 1 seq# 4314 mem# 0: +DATA_ERP/prod/onlinelog/group_1.296.835913153
Current log# 1 seq# 4314 mem# 1: +RECO_ERP/prod/onlinelog/group_1.273.835913153
Archived Log entry 14702 added for thread 1 sequence 4313 ID 0xec4bf72 dest 1:
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
ARC3: Standby redo logfile selected for thread 1 sequence 4313 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 4314 for destination LOG_ARCHIVE_DEST_2
Sat Dec 05 20:59:13 2015
XDB installed.
XDB initialized.
Sat Dec 05 20:59:32 2015
Completed checkpoint up to RBA [0x10da.2.10], SCN: 5980377074547
Sat Dec 05 21:00:01 2015
Starting background process SMCO
Sat Dec 05 21:00:01 2015
SMCO started with pid=82, OS id=30324
Sat Dec 05 21:14:27 2015
Incremental checkpoint up to RBA [0x10da.8de0.0], current log tail at RBA [0x10da.b8f2.0]
Sat Dec 05 21:34:16 2015
Starting background process CJQ0
Sat Dec 05 21:34:16 2015
CJQ0 started with pid=99, OS id=62985
Sat Dec 05 21:34:30 2015
Incremental checkpoint up to RBA [0x10da.4f262.0], current log tail at RBA [0x10da.678d3.0]
Sat Dec 05 21:54:34 2015
Incremental checkpoint up to RBA [0x10da.6e1e7.0], current log tail at RBA [0x10da.70892.0]
Sat Dec 05 22:00:00 2015
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sat Dec 05 22:00:00 2015
Starting background process VKRM
Sat Dec 05 22:00:00 2015
VKRM started with pid=88, OS id=85406
Sat Dec 05 22:14:37 2015
Incremental checkpoint up to RBA [0x10da.7bf77.0], current log tail at RBA [0x10da.7e240.0]
Sat Dec 05 22:34:41 2015
Incremental checkpoint up to RBA [0x10da.c2b59.0], current log tail at RBA [0x10da.db1d1.0]
Sat Dec 05 22:54:44 2015
Incremental checkpoint up to RBA [0x10da.e19a1.0], current log tail at RBA [0x10da.e3b20.0]
Sat Dec 05 23:14:47 2015
Incremental checkpoint up to RBA [0x10da.eb391.0], current log tail at RBA [0x10da.ed43a.0]
Sat Dec 05 23:34:51 2015
Incremental checkpoint up to RBA [0x10da.131417.0], current log tail at RBA [0x10da.149aa1.0]
Sat Dec 05 23:54:55 2015
Incremental checkpoint up to RBA [0x10da.1501f5.0], current log tail at RBA [0x10da.152507.0]
Sun Dec 06 00:14:58 2015
Incremental checkpoint up to RBA [0x10da.174556.0], current log tail at RBA [0x10da.176669.0]
Sun Dec 06 00:32:29 2015
Beginning log switch checkpoint up to RBA [0x10db.2.10], SCN: 5980379295678
Thread 1 advanced to log sequence 4315 (LGWR switch)
Current log# 2 seq# 4315 mem# 0: +DATA_ERP/prod/onlinelog/group_2.297.835913155
Current log# 2 seq# 4315 mem# 1: +RECO_ERP/prod/onlinelog/group_2.290.835913155
Sun Dec 06 00:32:30 2015
LNS: Standby redo logfile selected for thread 1 sequence 4315 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 00:32:35 2015
Archived Log entry 14706 added for thread 1 sequence 4314 ID 0xec4bf72 dest 1:
Sun Dec 06 00:35:02 2015
Incremental checkpoint up to RBA [0x10da.1ba3b2.0], current log tail at RBA [0x10db.1454b.0]
Sun Dec 06 00:37:35 2015
Completed checkpoint up to RBA [0x10db.2.10], SCN: 5980379295678
Sun Dec 06 00:55:10 2015
Incremental checkpoint up to RBA [0x10db.1b1ee.0], current log tail at RBA [0x10db.1d43d.0]
Sun Dec 06 01:02:32 2015
ALTER SYSTEM ARCHIVE LOG
Sun Dec 06 01:02:32 2015
Beginning log switch checkpoint up to RBA [0x10dc.2.10], SCN: 5980379464852
Thread 1 advanced to log sequence 4316 (LGWR switch)
Current log# 5 seq# 4316 mem# 0: +DATA_ERP/prod/onlinelog/group_5.300.835913161
Current log# 5 seq# 4316 mem# 1: +RECO_ERP/prod/onlinelog/group_5.295.835913161
Sun Dec 06 01:02:32 2015
LNS: Standby redo logfile selected for thread 1 sequence 4316 for destination LOG_ARCHIVE_DEST_2
Archived Log entry 14708 added for thread 1 sequence 4315 ID 0xec4bf72 dest 1:
ALTER SYSTEM ARCHIVE LOG
Beginning log switch checkpoint up to RBA [0x10dd.2.10], SCN: 5980379465017
Thread 1 advanced to log sequence 4317 (LGWR switch)
Current log# 1 seq# 4317 mem# 0: +DATA_ERP/prod/onlinelog/group_1.296.835913153
Current log# 1 seq# 4317 mem# 1: +RECO_ERP/prod/onlinelog/group_1.273.835913153
LNS: Standby redo logfile selected for thread 1 sequence 4317 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 01:02:36 2015
Archived Log entry 14712 added for thread 1 sequence 4316 ID 0xec4bf72 dest 1:
Sun Dec 06 01:07:32 2015
Completed checkpoint up to RBA [0x10dd.2.10], SCN: 5980379465017
Completed checkpoint up to RBA [0x10dc.2.10], SCN: 5980379464852
Sun Dec 06 01:15:14 2015
Incremental checkpoint up to RBA [0x10dd.3377.0], current log tail at RBA [0x10dd.533a.0]
Sun Dec 06 01:35:18 2015
Incremental checkpoint up to RBA [0x10dd.4dc57.0], current log tail at RBA [0x10dd.66304.0]
Sun Dec 06 01:55:21 2015
Incremental checkpoint up to RBA [0x10dd.6cb27.0], current log tail at RBA [0x10dd.6eee9.0]
Sun Dec 06 02:15:25 2015
Incremental checkpoint up to RBA [0x10dd.8b7af.0], current log tail at RBA [0x10dd.a3df5.0]
Sun Dec 06 02:35:28 2015
Incremental checkpoint up to RBA [0x10dd.e79fc.0], current log tail at RBA [0x10dd.100088.0]
Sun Dec 06 02:55:32 2015
Incremental checkpoint up to RBA [0x10dd.106916.0], current log tail at RBA [0x10dd.108d9e.0]
Sun Dec 06 03:15:35 2015
Incremental checkpoint up to RBA [0x10dd.110919.0], current log tail at RBA [0x10dd.112b04.0]
Sun Dec 06 03:35:39 2015
Incremental checkpoint up to RBA [0x10dd.154cf7.0], current log tail at RBA [0x10dd.16d366.0]
Sun Dec 06 03:55:42 2015
Incremental checkpoint up to RBA [0x10dd.173d88.0], current log tail at RBA [0x10dd.176018.0]
Sun Dec 06 04:15:45 2015
Incremental checkpoint up to RBA [0x10dd.17d88b.0], current log tail at RBA [0x10dd.17f861.0]
Sun Dec 06 04:31:21 2015
Beginning log switch checkpoint up to RBA [0x10de.2.10], SCN: 5980380955820
Thread 1 advanced to log sequence 4318 (LGWR switch)
Current log# 2 seq# 4318 mem# 0: +DATA_ERP/prod/onlinelog/group_2.297.835913155
Current log# 2 seq# 4318 mem# 1: +RECO_ERP/prod/onlinelog/group_2.290.835913155
Sun Dec 06 04:31:21 2015
LNS: Standby redo logfile selected for thread 1 sequence 4318 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 04:31:28 2015
Archived Log entry 14714 added for thread 1 sequence 4317 ID 0xec4bf72 dest 1:
Sun Dec 06 04:31:49 2015
Completed checkpoint up to RBA [0x10de.2.10], SCN: 5980380955820
Sun Dec 06 04:35:50 2015
Incremental checkpoint up to RBA [0x10de.37a4a.0], current log tail at RBA [0x10de.500e4.0]
Sun Dec 06 04:55:53 2015
Incremental checkpoint up to RBA [0x10de.56833.0], current log tail at RBA [0x10de.58a24.0]
Sun Dec 06 05:15:56 2015
Incremental checkpoint up to RBA [0x10de.60731.0], current log tail at RBA [0x10de.62683.0]
Sun Dec 06 05:36:00 2015
Incremental checkpoint up to RBA [0x10de.a6264.0], current log tail at RBA [0x10de.be8bf.0]
Sun Dec 06 05:56:03 2015
Incremental checkpoint up to RBA [0x10de.c4d2e.0], current log tail at RBA [0x10de.c706f.0]
Sun Dec 06 06:16:07 2015
Incremental checkpoint up to RBA [0x10de.133f68.0], current log tail at RBA [0x10de.136777.0]
Sun Dec 06 06:36:11 2015
Incremental checkpoint up to RBA [0x10de.17a453.0], current log tail at RBA [0x10de.192b02.0]
Sun Dec 06 06:56:14 2015
Incremental checkpoint up to RBA [0x10de.199226.0], current log tail at RBA [0x10de.19b622.0]
Sun Dec 06 07:16:17 2015
Incremental checkpoint up to RBA [0x10de.1a3496.0], current log tail at RBA [0x10de.1a5486.0]
Sun Dec 06 07:31:17 2015
Beginning log switch checkpoint up to RBA [0x10df.2.10], SCN: 5980382730343
Thread 1 advanced to log sequence 4319 (LGWR switch)
Current log# 5 seq# 4319 mem# 0: +DATA_ERP/prod/onlinelog/group_5.300.835913161
Current log# 5 seq# 4319 mem# 1: +RECO_ERP/prod/onlinelog/group_5.295.835913161
Sun Dec 06 07:31:17 2015
LNS: Standby redo logfile selected for thread 1 sequence 4319 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 07:31:24 2015
Archived Log entry 14717 added for thread 1 sequence 4318 ID 0xec4bf72 dest 1:
Sun Dec 06 07:31:57 2015
Completed checkpoint up to RBA [0x10df.2.10], SCN: 5980382730343
Sun Dec 06 07:36:20 2015
Incremental checkpoint up to RBA [0x10df.2ae29.0], current log tail at RBA [0x10df.4339d.0]
Sun Dec 06 07:56:24 2015
Incremental checkpoint up to RBA [0x10df.49bca.0], current log tail at RBA [0x10df.4bf1f.0]
Sun Dec 06 08:16:27 2015
Incremental checkpoint up to RBA [0x10df.53bcd.0], current log tail at RBA [0x10df.56760.0]
Sun Dec 06 08:36:32 2015
Incremental checkpoint up to RBA [0x10df.9b891.0], current log tail at RBA [0x10df.b3f10.0]
Sun Dec 06 08:56:35 2015
Incremental checkpoint up to RBA [0x10df.bafe7.0], current log tail at RBA [0x10df.bd3ff.0]
Sun Dec 06 09:16:38 2015
Incremental checkpoint up to RBA [0x10df.c532a.0], current log tail at RBA [0x10df.c7319.0]
Sun Dec 06 09:36:42 2015
Incremental checkpoint up to RBA [0x10df.10b5ab.0], current log tail at RBA [0x10df.123c63.0]
Sun Dec 06 09:56:45 2015
Incremental checkpoint up to RBA [0x10df.12bc41.0], current log tail at RBA [0x10df.12e34f.0]
Sun Dec 06 10:16:48 2015
Incremental checkpoint up to RBA [0x10df.13610e.0], current log tail at RBA [0x10df.138528.0]
Sun Dec 06 10:36:52 2015
Incremental checkpoint up to RBA [0x10df.17d116.0], current log tail at RBA [0x10df.19573b.0]
Sun Dec 06 10:43:11 2015
Beginning log switch checkpoint up to RBA [0x10e0.2.10], SCN: 5980384204730
Thread 1 advanced to log sequence 4320 (LGWR switch)
Current log# 1 seq# 4320 mem# 0: +DATA_ERP/prod/onlinelog/group_1.296.835913153
Current log# 1 seq# 4320 mem# 1: +RECO_ERP/prod/onlinelog/group_1.273.835913153
Sun Dec 06 10:43:11 2015
LNS: Standby redo logfile selected for thread 1 sequence 4320 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 10:43:16 2015
Archived Log entry 14719 added for thread 1 sequence 4319 ID 0xec4bf72 dest 1:
Sun Dec 06 10:48:15 2015
Completed checkpoint up to RBA [0x10e0.2.10], SCN: 5980384204730
Sun Dec 06 10:56:56 2015
Incremental checkpoint up to RBA [0x10e0.a245.0], current log tail at RBA [0x10e0.c6b0.0]
Sun Dec 06 11:16:59 2015
Incremental checkpoint up to RBA [0x10e0.14e80.0], current log tail at RBA [0x10e0.16ffd.0]
Sun Dec 06 11:37:04 2015
Incremental checkpoint up to RBA [0x10e0.a9e1c.0], current log tail at RBA [0x10e0.c24bf.0]
Sun Dec 06 11:57:08 2015
Incremental checkpoint up to RBA [0x10e0.ca88c.0], current log tail at RBA [0x10e0.cd911.0]
Sun Dec 06 12:17:12 2015
Incremental checkpoint up to RBA [0x10e0.ed9bd.0], current log tail at RBA [0x10e0.efd1e.0]
Sun Dec 06 12:37:16 2015
Incremental checkpoint up to RBA [0x10e0.131ccf.0], current log tail at RBA [0x10e0.14a340.0]
Sun Dec 06 12:57:19 2015
Incremental checkpoint up to RBA [0x10e0.153d97.0], current log tail at RBA [0x10e0.1571eb.0]
Sun Dec 06 13:17:22 2015
Incremental checkpoint up to RBA [0x10e0.1605d6.0], current log tail at RBA [0x10e0.162902.0]
Sun Dec 06 13:36:07 2015
Beginning log switch checkpoint up to RBA [0x10e1.2.10], SCN: 5980385569705
Thread 1 advanced to log sequence 4321 (LGWR switch)
Current log# 2 seq# 4321 mem# 0: +DATA_ERP/prod/onlinelog/group_2.297.835913155
Current log# 2 seq# 4321 mem# 1: +RECO_ERP/prod/onlinelog/group_2.290.835913155
Sun Dec 06 13:36:07 2015
LNS: Standby redo logfile selected for thread 1 sequence 4321 for destination LOG_ARCHIVE_DEST_2
Sun Dec 06 13:36:12 2015
Archived Log entry 14721 added for thread 1 sequence 4320 ID 0xec4bf72 dest 1:
Sun Dec 06 13:37:26 2015
Incremental checkpoint up to RBA [0x10e0.1a5d66.0], current log tail at RBA [0x10e1.835.0]
Sun Dec 06 13:41:09 2015
Completed checkpoint up to RBA [0x10e1.2.10], SCN: 5980385569705
Sun Dec 06 13:57:30 2015
Incremental checkpoint up to RBA [0x10e1.7942.0], current log tail at RBA [0x10e1.cef4.0]
Sun Dec 06 14:17:34 2015
Incremental checkpoint up to RBA [0x10e1.152ac.0], current log tail at RBA [0x10e1.17967.0]
Sun Dec 06 14:37:38 2015
Incremental checkpoint up to RBA [0x10e1.7188c.0], current log tail at RBA [0x10e1.74108.0]
Sun Dec 06 14:57:41 2015
Incremental checkpoint up to RBA [0x10e1.7abea.0], current log tail at RBA [0x10e1.7d031.0]
Sun Dec 06 15:17:44 2015
Incremental checkpoint up to RBA [0x10e1.85347.0], current log tail at RBA [0x10e1.8774f.0]
Sun Dec 06 15:37:49 2015
Incremental checkpoint up to RBA [0x10e1.e2435.0], current log tail at RBA [0x10e1.e51f8.0]
Sun Dec 06 15:57:52 2015
Incremental checkpoint up to RBA [0x10e1.ec463.0], current log tail at RBA [0x10e1.eec90.0]
Sun Dec 06 16:17:56 2015
Incremental checkpoint up to RBA [0x10e1.f782e.0], current log tail at RBA [0x10e1.f9d9d.0]
1 0
- 实例启动过程 11g rac
- 一次11g rac无法启动处理过程
- oracle 11g R2 rac/asm 实例不能启动处理方法!
- 转 racle 11g两个节点RAC搭建单实例DG过程问题以及解决方法
- 11g rac启动失败一例
- oracle 11g RAC 启动和关闭
- rac 11g 资源自动启动
- RAC启动和关闭(oracle 11g)
- 11g RAC不能启动ohasd进程
- 11g RAC 的整个启动流程
- 11G RAC 进程启动顺序
- RAC关闭、启动、重启步骤:10g、11g
- RAC 实例不能启动
- RAC 实例不能启动
- RAC 实例不能启动
- 11.2RAC 启动过程
- 11G RAC重建ASM实例的SPFILE
- oracle 11g rac 恢复到单实例
- iPhone屏幕尺寸、分辨率及适配
- 数字图像处理作业之MATLAB操作现象思考
- 一种选择界面
- T-SQL动态查询(4)——动态SQL
- [LeetCode315]Count of Smaller Numbers After Self
- 实例启动过程 11g rac
- 计算两直线交点
- centOS常用指令及快捷键
- Hadoop教程(三)HDFS文件系统Shell命令
- PCA相关数学概念理解
- MySQL数据库事务隔离级别(Transaction Isolation Level)
- 傅里叶变换的理解----计算幅值和相位
- 基于动态数组的Queue类
- 将session存放至ocs进行存取