- 浏览: 959070 次
- 性别:
- 来自: 杭州
文章分类
最新评论
-
孤星119:
好熟悉的数据库字段啊, 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace:
quxiaoyong 写道遇到个问题,网上一搜,全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong:
遇到个问题,网上一搜,全他妈这篇文章。你转来转去的有意思吗?
数据库连接错误ORA-28547 -
hctech:
关于version count过高的问题,不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace:
invalid 写道写的不错,我根据这个来安装,有点理解错误了 ...
AIX 配置vncserver
一节点root.sh日志输出信息
二节点root.sh日志输出信息
一节点升级至10205输出信息
crsd日志信息
二节点crsd日志信息
一节点asm mount磁盘组信息
二节点asm mount磁盘组信息
引用
root@racsvr1 crs]# sh root.sh
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
assigning default hostname racsvr1 for node 1.
assigning default hostname racsvr2 for node 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
node 2: racsvr2 racsvr2_priv racsvr2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /dev/raw/raw2
Format of 1 voting devices complete.
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
racsvr1
CSS is inactive on these nodes.
racsvr2
Local node checking complete.
Run root.sh on remaining nodes to start CRS daemons.
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
assigning default hostname racsvr1 for node 1.
assigning default hostname racsvr2 for node 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
node 2: racsvr2 racsvr2_priv racsvr2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /dev/raw/raw2
Format of 1 voting devices complete.
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
racsvr1
CSS is inactive on these nodes.
racsvr2
Local node checking complete.
Run root.sh on remaining nodes to start CRS daemons.
二节点root.sh日志输出信息
引用
[root@racsvr2 crs]# sh root.sh
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
assigning default hostname racsvr1 for node 1.
assigning default hostname racsvr2 for node 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
node 2: racsvr2 racsvr2_priv racsvr2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /dev/raw/raw2
Format of 1 voting devices complete.
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
racsvr1
racsvr2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps
/oracle/app/product/10.2.0/crs/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
assigning default hostname racsvr1 for node 1.
assigning default hostname racsvr2 for node 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
node 2: racsvr2 racsvr2_priv racsvr2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /dev/raw/raw2
Format of 1 voting devices complete.
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
racsvr1
racsvr2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps
/oracle/app/product/10.2.0/crs/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
一节点升级至10205输出信息
引用
[root@racsvr1 install]# ./root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /oracle/app/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
.
.
.
.
.
.
.
.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/oracle/app/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /oracle/app/product/10.2.0/crs/install/paramfile.crs
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /oracle/app/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
.
.
.
.
.
.
.
.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/oracle/app/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /oracle/app/product/10.2.0/crs/install/paramfile.crs
crsd日志信息
引用
2010-08-04 11:01:23.579: [ CRSD][6764224]0ENV Logging level for Module: OCRUTL 0
2010-08-04 11:01:23.581: [ CRSD][6764224]0ENV Logging level for Module: OCRMSG 0
2010-08-04 11:01:23.582: [ CRSD][6764224]0ENV Logging level for Module: OCRCLI 0
2010-08-04 11:01:23.585: [ CRSD][6764224]0ENV Logging level for Module: OCRCAC 0
2010-08-04 11:01:23.588: [ CRSD][6764224]0ENV Logging level for Module: OCRSRV 0
2010-08-04 11:01:23.590: [ CRSD][6764224]0ENV Logging level for Module: OCRMAS 0
2010-08-04 11:01:23.590: [ CRSMAIN][6764224]0Filename is /oracle/app/product/10.2.0/crs/crs/init/racsvr1.pid
[ clsdmt][2863922064]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=racsvr1DBG_CRSD))
2010-08-04 11:01:23.618: [ CRSOCR][6764224]0OCR api procr_open_key failed for key SYSTEM.crs.10.2.0.5.0. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
[ default][6764224]CRS resource ora.racsvr1.ons upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][6764224]CRS resource ora.racsvr1.vip upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][6764224]CRS resource ora.racsvr1.gsd upgraded from 10.2.0.1.0 to 10.2.0.5.0
2010-08-04 11:01:23.966: [ CRSMAIN][6764224]0Using Authorizer location: /oracle/app/product/10.2.0/crs/crs/auth/
2010-08-04 11:01:24.404: [ CRSMAIN][6764224]0Initializing RTI
2010-08-04 11:01:24.633: [ CRSOCR][6764224]0OCR api procr_open_key failed for key CRS.STAGE.node1. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
2010-08-04 11:01:24.858: [CRSTIMER][2842942352]0Timer Thread Starting.
2010-08-04 11:01:24.895: [ CRSRES][6764224]0Parameter SECURITY = 1, running in USER Mode
2010-08-04 11:01:24.895: [ CRSMAIN][6764224]0Initializing EVMMgr
2010-08-04 11:01:25.121: [ CRSMAIN][6764224]0CRSD locked during state recovery, please wait.
2010-08-04 11:01:25.329: [ CRSMAIN][6764224]0CRSD recovered, unlocked.
2010-08-04 11:01:25.331: [ CRSMAIN][6764224]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:01:25.331: [ CRSMAIN][6764224]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:01:25.344: [ CRSMAIN][6764224]0CRSD UI socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=CRSD_UI_SOCKET))
2010-08-04 11:01:25.373: [ CRSMAIN][6764224]0E2E socket on: (ADDRESS=(PROTOCOL=tcp)(HOST=racsvr1_priv)(PORT=49896))
2010-08-04 11:01:25.374: [ CRSMAIN][6764224]0Starting Threads
2010-08-04 11:01:25.374: [ CRSMAIN][6764224]0CRS Daemon Started.
2010-08-04 11:01:25.374: [ CRSMAIN][2780003216]0Starting runCommandServer for (UI = 1, E2E = 0). 0
2010-08-04 11:01:25.374: [ CRSMAIN][2769513360]0Starting runCommandServer for (UI = 1, E2E = 0). 1
2010-08-04 11:01:25.397: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.453: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.520: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.557: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.602: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.649: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.782: [ CRSRES][2738043792]0startRunnable: setting CLI values
2010-08-04 11:01:25.807: [ CRSRES][2738043792]0Attempting to start `ora.racsvr1.vip` on member `racsvr1`
2010-08-04 11:01:30.053: [ CRSRES][2738043792]0Start of `ora.racsvr1.vip` on member `racsvr1` succeeded.
2010-08-04 11:01:30.498: [ CLSVER][39017360]0Returned from grpstat with event 1
2010-08-04 11:01:30.498: [ CLSVER][39017360]0Doing grpstat on crs_version group
2010-08-04 11:01:30.570: [ CRSRES][2738043792]0startRunnable: setting CLI values
2010-08-04 11:01:30.728: [ CRSRES][2706574224]0startRunnable: setting CLI values
2010-08-04 11:01:30.739: [ CRSRES][2675104656]0startRunnable: setting CLI values
2010-08-04 11:01:30.974: [ CRSRES][2738043792]0Attempting to start `ora.racsvr1.gsd` on member `racsvr1`
2010-08-04 11:01:31.326: [ CRSRES][2706574224]0Attempting to start `ora.racsvr1.ons` on member `racsvr1`
2010-08-04 11:01:31.358: [ CRSRES][2675104656]0Attempting to start `ora.racsvr2.vip` on member `racsvr1`
2010-08-04 11:01:34.902: [ CRSRES][2738043792]0Start of `ora.racsvr1.gsd` on member `racsvr1` succeeded.
2010-08-04 11:01:36.171: [ CRSRES][2706574224]0Start of `ora.racsvr1.ons` on member `racsvr1` succeeded.
2010-08-04 11:01:38.054: [ CRSRES][2675104656]0Start of `ora.racsvr2.vip` on member `racsvr1` succeeded.
2010-08-04 11:01:23.581: [ CRSD][6764224]0ENV Logging level for Module: OCRMSG 0
2010-08-04 11:01:23.582: [ CRSD][6764224]0ENV Logging level for Module: OCRCLI 0
2010-08-04 11:01:23.585: [ CRSD][6764224]0ENV Logging level for Module: OCRCAC 0
2010-08-04 11:01:23.588: [ CRSD][6764224]0ENV Logging level for Module: OCRSRV 0
2010-08-04 11:01:23.590: [ CRSD][6764224]0ENV Logging level for Module: OCRMAS 0
2010-08-04 11:01:23.590: [ CRSMAIN][6764224]0Filename is /oracle/app/product/10.2.0/crs/crs/init/racsvr1.pid
[ clsdmt][2863922064]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=racsvr1DBG_CRSD))
2010-08-04 11:01:23.618: [ CRSOCR][6764224]0OCR api procr_open_key failed for key SYSTEM.crs.10.2.0.5.0. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
[ default][6764224]CRS resource ora.racsvr1.ons upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][6764224]CRS resource ora.racsvr1.vip upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][6764224]CRS resource ora.racsvr1.gsd upgraded from 10.2.0.1.0 to 10.2.0.5.0
2010-08-04 11:01:23.966: [ CRSMAIN][6764224]0Using Authorizer location: /oracle/app/product/10.2.0/crs/crs/auth/
2010-08-04 11:01:24.404: [ CRSMAIN][6764224]0Initializing RTI
2010-08-04 11:01:24.633: [ CRSOCR][6764224]0OCR api procr_open_key failed for key CRS.STAGE.node1. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
2010-08-04 11:01:24.858: [CRSTIMER][2842942352]0Timer Thread Starting.
2010-08-04 11:01:24.895: [ CRSRES][6764224]0Parameter SECURITY = 1, running in USER Mode
2010-08-04 11:01:24.895: [ CRSMAIN][6764224]0Initializing EVMMgr
2010-08-04 11:01:25.121: [ CRSMAIN][6764224]0CRSD locked during state recovery, please wait.
2010-08-04 11:01:25.329: [ CRSMAIN][6764224]0CRSD recovered, unlocked.
2010-08-04 11:01:25.331: [ CRSMAIN][6764224]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:01:25.331: [ CRSMAIN][6764224]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:01:25.344: [ CRSMAIN][6764224]0CRSD UI socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=CRSD_UI_SOCKET))
2010-08-04 11:01:25.373: [ CRSMAIN][6764224]0E2E socket on: (ADDRESS=(PROTOCOL=tcp)(HOST=racsvr1_priv)(PORT=49896))
2010-08-04 11:01:25.374: [ CRSMAIN][6764224]0Starting Threads
2010-08-04 11:01:25.374: [ CRSMAIN][6764224]0CRS Daemon Started.
2010-08-04 11:01:25.374: [ CRSMAIN][2780003216]0Starting runCommandServer for (UI = 1, E2E = 0). 0
2010-08-04 11:01:25.374: [ CRSMAIN][2769513360]0Starting runCommandServer for (UI = 1, E2E = 0). 1
2010-08-04 11:01:25.397: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.453: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.520: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.557: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.602: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.649: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.782: [ CRSRES][2738043792]0startRunnable: setting CLI values
2010-08-04 11:01:25.807: [ CRSRES][2738043792]0Attempting to start `ora.racsvr1.vip` on member `racsvr1`
2010-08-04 11:01:30.053: [ CRSRES][2738043792]0Start of `ora.racsvr1.vip` on member `racsvr1` succeeded.
2010-08-04 11:01:30.498: [ CLSVER][39017360]0Returned from grpstat with event 1
2010-08-04 11:01:30.498: [ CLSVER][39017360]0Doing grpstat on crs_version group
2010-08-04 11:01:30.570: [ CRSRES][2738043792]0startRunnable: setting CLI values
2010-08-04 11:01:30.728: [ CRSRES][2706574224]0startRunnable: setting CLI values
2010-08-04 11:01:30.739: [ CRSRES][2675104656]0startRunnable: setting CLI values
2010-08-04 11:01:30.974: [ CRSRES][2738043792]0Attempting to start `ora.racsvr1.gsd` on member `racsvr1`
2010-08-04 11:01:31.326: [ CRSRES][2706574224]0Attempting to start `ora.racsvr1.ons` on member `racsvr1`
2010-08-04 11:01:31.358: [ CRSRES][2675104656]0Attempting to start `ora.racsvr2.vip` on member `racsvr1`
2010-08-04 11:01:34.902: [ CRSRES][2738043792]0Start of `ora.racsvr1.gsd` on member `racsvr1` succeeded.
2010-08-04 11:01:36.171: [ CRSRES][2706574224]0Start of `ora.racsvr1.ons` on member `racsvr1` succeeded.
2010-08-04 11:01:38.054: [ CRSRES][2675104656]0Start of `ora.racsvr2.vip` on member `racsvr1` succeeded.
二节点crsd日志信息
引用
2010-08-04 11:12:06.538: [ CSSCLNT][14083776]clsssInitNative: connect failed, rc 9
2010-08-04 11:12:06.538: [ CRSRTI][14083776]0CSS is not ready. Received status 3 from CSS. Waiting for good status ..
2010-08-04 11:12:19.566: [ CLSVER][14083776]0Active Version from OCR:10.2.0.1.0
2010-08-04 11:12:19.566: [ CLSVER][14083776]0Active Version is less than Software Version
2010-08-04 11:12:19.569: [ CLSVER][14083776]0Registered in CSS group crs_version
2010-08-04 11:12:19.571: [ CRSMAIN][14083776]0Initializing OCR
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Monitoring the crs_version group for AV change notification
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Returned from grpstat with event 1
2010-08-04 11:12:19.572: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:19.763: [ OCRRAW][14083776]proprioo: for disk 0 (/dev/raw/raw1), id match (1), my id set (1669906634,1028247821) total id sets (1), 1st set (1669906634,1028247821), 2nd set (0,0) my votes (2), total votes (2)
2010-08-04 11:12:23.048: [ CRSD][14083776]0ENV Logging level for Module: allcomp 0
2010-08-04 11:12:23.223: [ CRSD][14083776]0ENV Logging level for Module: default 0
2010-08-04 11:12:23.560: [ CRSD][14083776]0ENV Logging level for Module: COMMCRS 0
2010-08-04 11:12:24.108: [ CRSD][14083776]0ENV Logging level for Module: COMMNS 0
2010-08-04 11:12:24.520: [ CRSD][14083776]0ENV Logging level for Module: CRSUI 0
2010-08-04 11:12:24.581: [ CRSD][14083776]0ENV Logging level for Module: CRSCOMM 0
2010-08-04 11:12:24.627: [ CRSD][14083776]0ENV Logging level for Module: CRSRTI 0
2010-08-04 11:12:24.755: [ CRSD][14083776]0ENV Logging level for Module: CRSMAIN 0
2010-08-04 11:12:25.606: [ OCRMAS][3044850576]th_master: Deleted ver keys from cache (non master)
2010-08-04 11:12:25.836: [ CRSD][14083776]0ENV Logging level for Module: CRSPLACE 0
2010-08-04 11:12:26.275: [ CRSD][14083776]0ENV Logging level for Module: CRSAPP 0
2010-08-04 11:12:26.674: [ CRSD][14083776]0ENV Logging level for Module: CRSRES 0
2010-08-04 11:12:27.325: [ CRSD][14083776]0ENV Logging level for Module: CRSOCR 0
2010-08-04 11:12:27.344: [ CRSD][14083776]0ENV Logging level for Module: CRSTIMER 0
2010-08-04 11:12:27.403: [ CRSD][14083776]0ENV Logging level for Module: CRSEVT 0
2010-08-04 11:12:27.418: [ CRSD][14083776]0ENV Logging level for Module: CRSD 0
2010-08-04 11:12:27.433: [ CRSD][14083776]0ENV Logging level for Module: CLUCLS 0
2010-08-04 11:12:27.448: [ CRSD][14083776]0ENV Logging level for Module: CLSVER 0
2010-08-04 11:12:27.462: [ CRSD][14083776]0ENV Logging level for Module: OCRRAW 0
2010-08-04 11:12:27.479: [ CRSD][14083776]0ENV Logging level for Module: OCROSD 0
2010-08-04 11:12:27.495: [ CRSD][14083776]0ENV Logging level for Module: CSSCLNT 0
2010-08-04 11:12:27.507: [ CRSD][14083776]0ENV Logging level for Module: OCRAPI 0
2010-08-04 11:12:27.524: [ CRSD][14083776]0ENV Logging level for Module: OCRUTL 0
2010-08-04 11:12:27.537: [ CRSD][14083776]0ENV Logging level for Module: OCRMSG 0
2010-08-04 11:12:27.560: [ CRSD][14083776]0ENV Logging level for Module: OCRCLI 0
2010-08-04 11:12:27.980: [ CRSD][14083776]0ENV Logging level for Module: OCRCAC 0
2010-08-04 11:12:28.142: [ CRSD][14083776]0ENV Logging level for Module: OCRSRV 0
2010-08-04 11:12:28.184: [ CRSD][14083776]0ENV Logging level for Module: OCRMAS 0
2010-08-04 11:12:28.184: [ CRSMAIN][14083776]0Filename is /oracle/app/product/10.2.0/crs/crs/init/racsvr2.pid
[ clsdmt][2854194064]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=racsvr2DBG_CRSD))
[ default][14083776]CRS resource ora.racsvr2.ons upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][14083776]CRS resource ora.racsvr2.vip upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][14083776]CRS resource ora.racsvr2.gsd upgraded from 10.2.0.1.0 to 10.2.0.5.0
2010-08-04 11:12:34.163: [ CLSVER][40627088]0Returned from grpstat with event 1
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Returned from grpstat with event 8
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Recieved GRPPRIV event
2010-08-04 11:12:34.169: [ CLSVER][40627088]0AV got from version group: 10.2.0.5.0
2010-08-04 11:12:34.169: [ CLSVER][40627088]0Stopped monitoring the version group
2010-08-04 11:12:34.169: [ CLSVER][40627088]0New Active Version:10.2.0.5.0
2010-08-04 11:12:34.169: [ CLSVER][40627088]0Active Version changed to 10.2.0.5.0
2010-08-04 11:12:34.492: [ CRSMAIN][14083776]0Using Authorizer location: /oracle/app/product/10.2.0/crs/crs/auth/
2010-08-04 11:12:35.064: [ CRSMAIN][14083776]0Initializing RTI
2010-08-04 11:12:35.730: [ CRSOCR][14083776]0OCR api procr_open_key failed for key CRS.STAGE.node2. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
2010-08-04 11:12:36.299: [CRSTIMER][40627088]0Timer Thread Starting.
2010-08-04 11:12:36.329: [ CRSRES][14083776]0Parameter SECURITY = 1, running in USER Mode
2010-08-04 11:12:36.329: [ CRSMAIN][14083776]0Initializing EVMMgr
2010-08-04 11:12:37.163: [ CRSMAIN][14083776]0CRSD locked during state recovery, please wait.
2010-08-04 11:12:37.418: [ CRSMAIN][14083776]0CRSD recovered, unlocked.
2010-08-04 11:12:37.422: [ CRSMAIN][14083776]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:12:37.422: [ CRSMAIN][14083776]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:12:37.527: [ CRSMAIN][14083776]0CRSD UI socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=CRSD_UI_SOCKET))
2010-08-04 11:12:37.577: [ CRSMAIN][14083776]0E2E socket on: (ADDRESS=(PROTOCOL=tcp)(HOST=racsvr2_priv)(PORT=49896))
2010-08-04 11:12:37.578: [ CRSMAIN][14083776]0Starting Threads
2010-08-04 11:12:37.578: [ CRSMAIN][14083776]0CRS Daemon Started.
2010-08-04 11:12:37.579: [ CRSMAIN][2780765072]0Starting runCommandServer for (UI = 1, E2E = 0). 0
2010-08-04 11:12:37.582: [ CRSMAIN][2770275216]0Starting runCommandServer for (UI = 1, E2E = 0). 1
2010-08-04 11:12:37.865: [ CRSRES][14083776]0 startup = 1
2010-08-04 11:12:38.035: [ CRSRES][14083776]0 startup = 1
2010-08-04 11:12:39.257: [ CRSRES][2738805648]0StopResource: setting CLI values
2010-08-04 11:12:39.382: [ CRSRES][2738805648]0Attempting to stop `ora.racsvr2.vip` on member `racsvr1`
2010-08-04 11:12:39.884: [ CRSRES][2738805648]0Stop of `ora.racsvr2.vip` on member `racsvr1` succeeded.
2010-08-04 11:12:39.917: [ CRSRES][2738805648]0startRunnable: setting CLI values
2010-08-04 11:12:39.917: [ CRSRES][2738805648]0Attempting to start `ora.racsvr2.vip` on member `racsvr2`
2010-08-04 11:12:44.537: [ CRSRES][2738805648]0Start of `ora.racsvr2.vip` on member `racsvr2` succeeded.
2010-08-04 11:12:46.126: [ CRSRES][2738805648]0startRunnable: setting CLI values
2010-08-04 11:12:46.299: [ CRSRES][2696846224]0startRunnable: setting CLI values
2010-08-04 11:12:46.319: [ CRSRES][2738805648]0Attempting to start `ora.racsvr2.gsd` on member `racsvr2`
2010-08-04 11:12:46.452: [ CRSRES][2696846224]0Attempting to start `ora.racsvr2.ons` on member `racsvr2`
2010-08-04 11:12:48.974: [ CRSRES][2738805648]0Start of `ora.racsvr2.gsd` on member `racsvr2` succeeded.
2010-08-04 11:12:50.403: [ CRSRES][2696846224]0Start of `ora.racsvr2.ons` on member `racsvr2` succeeded.
2010-08-04 11:12:06.538: [ CRSRTI][14083776]0CSS is not ready. Received status 3 from CSS. Waiting for good status ..
2010-08-04 11:12:19.566: [ CLSVER][14083776]0Active Version from OCR:10.2.0.1.0
2010-08-04 11:12:19.566: [ CLSVER][14083776]0Active Version is less than Software Version
2010-08-04 11:12:19.569: [ CLSVER][14083776]0Registered in CSS group crs_version
2010-08-04 11:12:19.571: [ CRSMAIN][14083776]0Initializing OCR
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Monitoring the crs_version group for AV change notification
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Returned from grpstat with event 1
2010-08-04 11:12:19.572: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:19.763: [ OCRRAW][14083776]proprioo: for disk 0 (/dev/raw/raw1), id match (1), my id set (1669906634,1028247821) total id sets (1), 1st set (1669906634,1028247821), 2nd set (0,0) my votes (2), total votes (2)
2010-08-04 11:12:23.048: [ CRSD][14083776]0ENV Logging level for Module: allcomp 0
2010-08-04 11:12:23.223: [ CRSD][14083776]0ENV Logging level for Module: default 0
2010-08-04 11:12:23.560: [ CRSD][14083776]0ENV Logging level for Module: COMMCRS 0
2010-08-04 11:12:24.108: [ CRSD][14083776]0ENV Logging level for Module: COMMNS 0
2010-08-04 11:12:24.520: [ CRSD][14083776]0ENV Logging level for Module: CRSUI 0
2010-08-04 11:12:24.581: [ CRSD][14083776]0ENV Logging level for Module: CRSCOMM 0
2010-08-04 11:12:24.627: [ CRSD][14083776]0ENV Logging level for Module: CRSRTI 0
2010-08-04 11:12:24.755: [ CRSD][14083776]0ENV Logging level for Module: CRSMAIN 0
2010-08-04 11:12:25.606: [ OCRMAS][3044850576]th_master: Deleted ver keys from cache (non master)
2010-08-04 11:12:25.836: [ CRSD][14083776]0ENV Logging level for Module: CRSPLACE 0
2010-08-04 11:12:26.275: [ CRSD][14083776]0ENV Logging level for Module: CRSAPP 0
2010-08-04 11:12:26.674: [ CRSD][14083776]0ENV Logging level for Module: CRSRES 0
2010-08-04 11:12:27.325: [ CRSD][14083776]0ENV Logging level for Module: CRSOCR 0
2010-08-04 11:12:27.344: [ CRSD][14083776]0ENV Logging level for Module: CRSTIMER 0
2010-08-04 11:12:27.403: [ CRSD][14083776]0ENV Logging level for Module: CRSEVT 0
2010-08-04 11:12:27.418: [ CRSD][14083776]0ENV Logging level for Module: CRSD 0
2010-08-04 11:12:27.433: [ CRSD][14083776]0ENV Logging level for Module: CLUCLS 0
2010-08-04 11:12:27.448: [ CRSD][14083776]0ENV Logging level for Module: CLSVER 0
2010-08-04 11:12:27.462: [ CRSD][14083776]0ENV Logging level for Module: OCRRAW 0
2010-08-04 11:12:27.479: [ CRSD][14083776]0ENV Logging level for Module: OCROSD 0
2010-08-04 11:12:27.495: [ CRSD][14083776]0ENV Logging level for Module: CSSCLNT 0
2010-08-04 11:12:27.507: [ CRSD][14083776]0ENV Logging level for Module: OCRAPI 0
2010-08-04 11:12:27.524: [ CRSD][14083776]0ENV Logging level for Module: OCRUTL 0
2010-08-04 11:12:27.537: [ CRSD][14083776]0ENV Logging level for Module: OCRMSG 0
2010-08-04 11:12:27.560: [ CRSD][14083776]0ENV Logging level for Module: OCRCLI 0
2010-08-04 11:12:27.980: [ CRSD][14083776]0ENV Logging level for Module: OCRCAC 0
2010-08-04 11:12:28.142: [ CRSD][14083776]0ENV Logging level for Module: OCRSRV 0
2010-08-04 11:12:28.184: [ CRSD][14083776]0ENV Logging level for Module: OCRMAS 0
2010-08-04 11:12:28.184: [ CRSMAIN][14083776]0Filename is /oracle/app/product/10.2.0/crs/crs/init/racsvr2.pid
[ clsdmt][2854194064]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=racsvr2DBG_CRSD))
[ default][14083776]CRS resource ora.racsvr2.ons upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][14083776]CRS resource ora.racsvr2.vip upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][14083776]CRS resource ora.racsvr2.gsd upgraded from 10.2.0.1.0 to 10.2.0.5.0
2010-08-04 11:12:34.163: [ CLSVER][40627088]0Returned from grpstat with event 1
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Returned from grpstat with event 8
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Recieved GRPPRIV event
2010-08-04 11:12:34.169: [ CLSVER][40627088]0AV got from version group: 10.2.0.5.0
2010-08-04 11:12:34.169: [ CLSVER][40627088]0Stopped monitoring the version group
2010-08-04 11:12:34.169: [ CLSVER][40627088]0New Active Version:10.2.0.5.0
2010-08-04 11:12:34.169: [ CLSVER][40627088]0Active Version changed to 10.2.0.5.0
2010-08-04 11:12:34.492: [ CRSMAIN][14083776]0Using Authorizer location: /oracle/app/product/10.2.0/crs/crs/auth/
2010-08-04 11:12:35.064: [ CRSMAIN][14083776]0Initializing RTI
2010-08-04 11:12:35.730: [ CRSOCR][14083776]0OCR api procr_open_key failed for key CRS.STAGE.node2. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
2010-08-04 11:12:36.299: [CRSTIMER][40627088]0Timer Thread Starting.
2010-08-04 11:12:36.329: [ CRSRES][14083776]0Parameter SECURITY = 1, running in USER Mode
2010-08-04 11:12:36.329: [ CRSMAIN][14083776]0Initializing EVMMgr
2010-08-04 11:12:37.163: [ CRSMAIN][14083776]0CRSD locked during state recovery, please wait.
2010-08-04 11:12:37.418: [ CRSMAIN][14083776]0CRSD recovered, unlocked.
2010-08-04 11:12:37.422: [ CRSMAIN][14083776]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:12:37.422: [ CRSMAIN][14083776]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:12:37.527: [ CRSMAIN][14083776]0CRSD UI socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=CRSD_UI_SOCKET))
2010-08-04 11:12:37.577: [ CRSMAIN][14083776]0E2E socket on: (ADDRESS=(PROTOCOL=tcp)(HOST=racsvr2_priv)(PORT=49896))
2010-08-04 11:12:37.578: [ CRSMAIN][14083776]0Starting Threads
2010-08-04 11:12:37.578: [ CRSMAIN][14083776]0CRS Daemon Started.
2010-08-04 11:12:37.579: [ CRSMAIN][2780765072]0Starting runCommandServer for (UI = 1, E2E = 0). 0
2010-08-04 11:12:37.582: [ CRSMAIN][2770275216]0Starting runCommandServer for (UI = 1, E2E = 0). 1
2010-08-04 11:12:37.865: [ CRSRES][14083776]0 startup = 1
2010-08-04 11:12:38.035: [ CRSRES][14083776]0 startup = 1
2010-08-04 11:12:39.257: [ CRSRES][2738805648]0StopResource: setting CLI values
2010-08-04 11:12:39.382: [ CRSRES][2738805648]0Attempting to stop `ora.racsvr2.vip` on member `racsvr1`
2010-08-04 11:12:39.884: [ CRSRES][2738805648]0Stop of `ora.racsvr2.vip` on member `racsvr1` succeeded.
2010-08-04 11:12:39.917: [ CRSRES][2738805648]0startRunnable: setting CLI values
2010-08-04 11:12:39.917: [ CRSRES][2738805648]0Attempting to start `ora.racsvr2.vip` on member `racsvr2`
2010-08-04 11:12:44.537: [ CRSRES][2738805648]0Start of `ora.racsvr2.vip` on member `racsvr2` succeeded.
2010-08-04 11:12:46.126: [ CRSRES][2738805648]0startRunnable: setting CLI values
2010-08-04 11:12:46.299: [ CRSRES][2696846224]0startRunnable: setting CLI values
2010-08-04 11:12:46.319: [ CRSRES][2738805648]0Attempting to start `ora.racsvr2.gsd` on member `racsvr2`
2010-08-04 11:12:46.452: [ CRSRES][2696846224]0Attempting to start `ora.racsvr2.ons` on member `racsvr2`
2010-08-04 11:12:48.974: [ CRSRES][2738805648]0Start of `ora.racsvr2.gsd` on member `racsvr2` succeeded.
2010-08-04 11:12:50.403: [ CRSRES][2696846224]0Start of `ora.racsvr2.ons` on member `racsvr2` succeeded.
一节点asm mount磁盘组信息
引用
Wed Aug 04 11:53:08 EDT 2010
SQL> CREATE DISKGROUP datadg External REDUNDANCY DISK '/dev/raw/raw3' SIZE 964M ,
'/dev/raw/raw4' SIZE 1153M
Wed Aug 04 11:53:08 EDT 2010
NOTE: initializing header on grp 1 disk DATADG_0000
NOTE: initializing header on grp 1 disk DATADG_0001
NOTE: PST update: grp = 1
Wed Aug 04 11:53:08 EDT 2010
NOTE: group DATADG: initial PST locations: disk 0000 (PST copy 0)
Wed Aug 04 11:53:08 EDT 2010
NOTE: cache registered group DATADG number=1 incarn=0x390d2f07
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
* allocate domain 1, invalid = TRUE
kjbdomatt send to node 1
Wed Aug 04 11:53:09 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:09 EDT 2010
NOTE: cache creating group 1/0x390D2F07 (DATADG)
NOTE: cache mounting group 1/0x390D2F07 (DATADG) succeeded
NOTE: allocating F1X0 on grp 1 disk DATADG_0000
NOTE: diskgroup must now be re-mounted prior to first use
NOTE: cache dismounting group 1/0x390D2F07 (DATADG)
Wed Aug 04 11:53:12 EDT 2010
kjbdomdet send to node 1
detach from dom 1, sending detach message to node 1
freeing rdom 1
Wed Aug 04 11:53:12 EDT 2010
NOTE: detached from domain 1
Wed Aug 04 11:53:13 EDT 2010
SUCCESS: diskgroup DATADG was created
NOTE: cache registered group DATADG number=1 incarn=0x4bad2f09
Wed Aug 04 11:53:13 EDT 2010
NOTE: Hbeat: instance first (grp 1)
Wed Aug 04 11:53:20 EDT 2010
NOTE: start heartbeating (grp 1)
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
Wed Aug 04 11:53:20 EDT 2010
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
NOTE: cache mounting (first) group 1/0x4BAD2F09 (DATADG)
* allocate domain 1, invalid = TRUE
kjbdomatt send to node 1
Wed Aug 04 11:53:20 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:21 EDT 2010
NOTE: cache recovered group 1 to fcn 0.0
Wed Aug 04 11:53:21 EDT 2010
NOTE: LGWR attempting to mount thread 1 for disk group 1
NOTE: LGWR mounted thread 1 for disk group 1
NOTE: opening chunk 1 at fcn 0.0 ABA
NOTE: seq=2 blk=0
Wed Aug 04 11:53:21 EDT 2010
NOTE: cache mounting group 1/0x4BAD2F09 (DATADG) succeeded
SUCCESS: diskgroup DATADG was mounted
Wed Aug 04 11:53:21 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY SID='+ASM1';
Wed Aug 04 11:53:21 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY SID='+ASM2';
Wed Aug 04 11:53:22 EDT 2010
NOTE: recovering COD for group 1/0x4bad2f09 (DATADG)
SUCCESS: completed COD recovery for group 1/0x4bad2f09 (DATADG)
NOTE: enlarging ACD for group 1/0x4bad2f09 (DATADG)
SUCCESS: ACD enlarged for group 1/0x4bad2f09 (DATADG)
Wed Aug 04 11:53:29 EDT 2010
NOTE: X->S down convert bast on F1B3 bastCount=2
SQL> CREATE DISKGROUP datadg External REDUNDANCY DISK '/dev/raw/raw3' SIZE 964M ,
'/dev/raw/raw4' SIZE 1153M
Wed Aug 04 11:53:08 EDT 2010
NOTE: initializing header on grp 1 disk DATADG_0000
NOTE: initializing header on grp 1 disk DATADG_0001
NOTE: PST update: grp = 1
Wed Aug 04 11:53:08 EDT 2010
NOTE: group DATADG: initial PST locations: disk 0000 (PST copy 0)
Wed Aug 04 11:53:08 EDT 2010
NOTE: cache registered group DATADG number=1 incarn=0x390d2f07
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
* allocate domain 1, invalid = TRUE
kjbdomatt send to node 1
Wed Aug 04 11:53:09 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:09 EDT 2010
NOTE: cache creating group 1/0x390D2F07 (DATADG)
NOTE: cache mounting group 1/0x390D2F07 (DATADG) succeeded
NOTE: allocating F1X0 on grp 1 disk DATADG_0000
NOTE: diskgroup must now be re-mounted prior to first use
NOTE: cache dismounting group 1/0x390D2F07 (DATADG)
Wed Aug 04 11:53:12 EDT 2010
kjbdomdet send to node 1
detach from dom 1, sending detach message to node 1
freeing rdom 1
Wed Aug 04 11:53:12 EDT 2010
NOTE: detached from domain 1
Wed Aug 04 11:53:13 EDT 2010
SUCCESS: diskgroup DATADG was created
NOTE: cache registered group DATADG number=1 incarn=0x4bad2f09
Wed Aug 04 11:53:13 EDT 2010
NOTE: Hbeat: instance first (grp 1)
Wed Aug 04 11:53:20 EDT 2010
NOTE: start heartbeating (grp 1)
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
Wed Aug 04 11:53:20 EDT 2010
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
NOTE: cache mounting (first) group 1/0x4BAD2F09 (DATADG)
* allocate domain 1, invalid = TRUE
kjbdomatt send to node 1
Wed Aug 04 11:53:20 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:21 EDT 2010
NOTE: cache recovered group 1 to fcn 0.0
Wed Aug 04 11:53:21 EDT 2010
NOTE: LGWR attempting to mount thread 1 for disk group 1
NOTE: LGWR mounted thread 1 for disk group 1
NOTE: opening chunk 1 at fcn 0.0 ABA
NOTE: seq=2 blk=0
Wed Aug 04 11:53:21 EDT 2010
NOTE: cache mounting group 1/0x4BAD2F09 (DATADG) succeeded
SUCCESS: diskgroup DATADG was mounted
Wed Aug 04 11:53:21 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY SID='+ASM1';
Wed Aug 04 11:53:21 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY SID='+ASM2';
Wed Aug 04 11:53:22 EDT 2010
NOTE: recovering COD for group 1/0x4bad2f09 (DATADG)
SUCCESS: completed COD recovery for group 1/0x4bad2f09 (DATADG)
NOTE: enlarging ACD for group 1/0x4bad2f09 (DATADG)
SUCCESS: ACD enlarged for group 1/0x4bad2f09 (DATADG)
Wed Aug 04 11:53:29 EDT 2010
NOTE: X->S down convert bast on F1B3 bastCount=2
二节点asm mount磁盘组信息
引用
Wed Aug 04 11:50:58 EDT 2010
SQL> ALTER DISKGROUP ALL MOUNT
* allocate domain 1, invalid = TRUE
freeing rdom 1
Received detach msg from node 0 for dom 1
* allocate domain 1, invalid = TRUE
Wed Aug 04 11:53:23 EDT 2010
ALTER SYSTEM SET asm_diskstring='' SCOPE=MEMORY;
Wed Aug 04 11:53:23 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY;
Wed Aug 04 11:53:23 EDT 2010
SQL> /* OracleOEM */ alter diskgroup datadg MOUNT
Wed Aug 04 11:53:23 EDT 2010
NOTE: cache registered group DATADG number=1 incarn=0x4bad1a80
Wed Aug 04 11:53:23 EDT 2010
NOTE: Hbeat: instance not first (grp 1)
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
Wed Aug 04 11:53:23 EDT 2010
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
NOTE: cache mounting (not first) group 1/0x4BAD1A80 (DATADG)
Wed Aug 04 11:53:23 EDT 2010
kjbdomatt send to node 0
Wed Aug 04 11:53:24 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:24 EDT 2010
NOTE: LGWR attempting to mount thread 2 for disk group 1
NOTE: ACD expansion required for disk group 1
NOTE: LGWR attempting to mount thread 2 for disk group 1
NOTE: LGWR mounted thread 2 for disk group 1
NOTE: opening chunk 2 at fcn 0.0 ABA
NOTE: seq=2 blk=0
Wed Aug 04 11:53:29 EDT 2010
NOTE: cache mounting group 1/0x4BAD1A80 (DATADG) succeeded
SUCCESS: diskgroup DATADG was mounted
Wed Aug 04 11:53:32 EDT 2010
NOTE: recovering COD for group 1/0x4bad1a80 (DATADG)
SUCCESS: completed COD recovery for group 1/0x4bad1a80 (DATADG)
SQL> ALTER DISKGROUP ALL MOUNT
* allocate domain 1, invalid = TRUE
freeing rdom 1
Received detach msg from node 0 for dom 1
* allocate domain 1, invalid = TRUE
Wed Aug 04 11:53:23 EDT 2010
ALTER SYSTEM SET asm_diskstring='' SCOPE=MEMORY;
Wed Aug 04 11:53:23 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY;
Wed Aug 04 11:53:23 EDT 2010
SQL> /* OracleOEM */ alter diskgroup datadg MOUNT
Wed Aug 04 11:53:23 EDT 2010
NOTE: cache registered group DATADG number=1 incarn=0x4bad1a80
Wed Aug 04 11:53:23 EDT 2010
NOTE: Hbeat: instance not first (grp 1)
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
Wed Aug 04 11:53:23 EDT 2010
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
NOTE: cache mounting (not first) group 1/0x4BAD1A80 (DATADG)
Wed Aug 04 11:53:23 EDT 2010
kjbdomatt send to node 0
Wed Aug 04 11:53:24 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:24 EDT 2010
NOTE: LGWR attempting to mount thread 2 for disk group 1
NOTE: ACD expansion required for disk group 1
NOTE: LGWR attempting to mount thread 2 for disk group 1
NOTE: LGWR mounted thread 2 for disk group 1
NOTE: opening chunk 2 at fcn 0.0 ABA
NOTE: seq=2 blk=0
Wed Aug 04 11:53:29 EDT 2010
NOTE: cache mounting group 1/0x4BAD1A80 (DATADG) succeeded
SUCCESS: diskgroup DATADG was mounted
Wed Aug 04 11:53:32 EDT 2010
NOTE: recovering COD for group 1/0x4bad1a80 (DATADG)
SUCCESS: completed COD recovery for group 1/0x4bad1a80 (DATADG)
发表评论
-
buffer cache 的内部结构
2020-03-18 14:21 512BUFFER CACHE作为数据块的 ... -
Oracle OMC介绍
2020-03-18 13:19 434Oracle管理云服务(OMC)的大数据平台,自动收集的企业 ... -
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 4142019年7月22日,受邀参加Oracle勒索病毒防范专题培训 ... -
记一次内存换IO的Oracle优化
2019-09-27 16:50 781某客户数据库从P595物理 ... -
如何定位Oracle SQL执行计划变化的原因
2019-07-03 14:49 1348性能优化最难的是能够 ... -
如何定位Oracle SQL执行计划变化的原因
2018-10-30 09:24 1185性能优化最难的是能够 ... -
数据库性能优化目标
2018-10-08 10:59 463从数据库性能优化的场 ... -
数据库无法打开的原因及解决办法
2018-10-05 20:45 1898数据库的启动是一个相当复杂的过程。比如,Oracle在启动之前 ... -
怎么样彻底删除数据库?
2018-09-18 11:10 545Oracle提供了drop database命令用来删除数据库 ... -
Oracle减少日志量的方法
2018-09-10 10:17 799LGWR进程将LOG BUFFER中的 ... -
如何快速关闭数据库
2018-09-09 13:14 1189“一朝被蛇咬,十年怕井绳”。在没被“蛇”咬之前,很多DBA喜欢 ... -
关于《如何落地智能化运维》PPT
2018-05-17 10:19 1082在DTCC 2018发表《如何落地智能化运维》演讲,主要内容如 ... -
记录在redhat5.8平台安装oracle11.2容易忽视的几个问题
2018-05-11 19:58 525问题一:ping不通问题 在虚拟机上安装好linux系统后, ... -
《Oracle DBA实战攻略》第一章
2018-05-11 10:42 885即日起,不定期更新《OracleDBA实战攻略》一书电子版,请 ... -
Oracle 12c新特性
2018-05-11 10:33 847查询所有pdb [oracle@gj4 ~]$ sqlplu ... -
关于修改memory_target的值后数据库无法启动的问题
2017-02-28 12:24 3919操作系统:RHEL6.5 数据库版本:11.2.0.4 ... -
10g rac安装error while loading shared libraries libpthread.so.0 问题
2017-02-28 12:22 62811g rac安装在二节点跑脚本一般会报此错误: 解决这个问 ... -
记一次Oracle会话共享模式故障处理过程
2017-02-27 19:16 749故障简述 XXX第八人民医院HIS数据库7月13日11点左右从 ... -
RESMGR:cpu quantum等待事件处理过程
2017-02-27 18:23 2465由于数据库上线过程中出现大量的RESMGR:cpu quant ... -
谈谈log file sync
2014-03-19 14:18 1675数据库中的log file sync等待事件指的是,当user ...
相关推荐
熟悉 Oracle 真正应用集群 (RAC) 10g 技术的最有效方法之一是访问一个实际的 Oracle RAC 10g 集群。没有什么方法比直接体验它们能够更好地理解其好处的了 — 包括容错、安全性、负载均衡和可伸缩性。 Oracle RAC 的...
2.3.2安装Linux操作系统 2.3.3挂载iSCSI磁盘 2.3.4配置udev固定iSCSI磁盘设备名称 2.3.5配置服务器的图形化环境 2.4 RAC运行环境安装前检查 2.4.1服务器检查 2.4.2存储检查 2.4.3网络检查 2.5配置数据库...
linux下oracle集群
数据库:Oracle Enterprise Edition 11.2.0.4 - 64 bit,RAC 发现备库(单实例)与主库不同步,检查发现日志中断了好长时间,由于之前主库出现过归档空间不足的情况,手动清除了归档,导致缺少日志同步不过去,...
Linux RAC环境清理的文档,平时工作的时候用的,用了很多次
以下是基于提供的参考信息整理出的Oracle RAC集群搭建的详细笔记: ### 1. 安装前的规划 - **系统规划**:确保所有节点硬件配置相同,操作系统版本一致。建议使用相同的CPU、内存和网络硬件。 - **网络规划**:配置 ...
1.6 Oracle Database 11g的其他重要内容 14 1.6.1 索引 15 1.6.2 用户 15 1.6.3 表空间配额 15 1.6.4 同义词 16 1.6.5 角色 17 1.6.6 默认用户环境 17 1.7 对象和系统权限 18 1.7.1 select 18 1.7.2 ...
阿里云上部署Oracle ADG,并且带有节点故障自动切换功能。同时,也包括数据库异常故障的处理,比如死锁、数据误删除进行恢复
CORE Patch for Bug# 28852325 for Linux-x86-64 Platforms This patch is non-RAC Rolling Installable. Released: Tue Sep 24 06:08:39 2019 This document describes how you can install the CORE DST patch for...
安装Linux需要关闭防火墙和SELinux!! Linux下配置环境变量注意字符格式!! 节点机器系统冗余方案怎么做? 归档日志存放在共享存储上还是节点本地? RAC的RMAN备份找不到另一个节点的归档日志? 两层架构的节点...
/usr/sbin/useradd -u 502 -g oinstall -G dba,asmdba oracle # passwd grid Changing password for user grid. New UNIX password: BAD PASSWORD: it is too short Retype new UNIX password: passwd: all ...
1.6 Oracle Database 11g的其他重要内容 1.6.1 索引 1.6.2 用户 1.6.3 表空间配额 1.6.4 同义词 1.6.5 角色 1.6.6 默认用户环境 1.7 对象和系统权限 1.7.1 select 1.7.2 insen 1.7.3 update 1.7.4 delete 1.7.5 系统...
课程目标可以独立自主的自己迁移rac数据库到单实例数据库适用人群oracle初级dba,需要打补丁的维护人员,IT相关人员。课程简介在本地自己的操作系统上,完全模拟生产环境,让同学们彻底学会怎样RAC双节点迁移至单实例...
它是在主节点与备用节点间通过日志同步来保证数据的同步, 可以实现数据库快速切换与灾难性恢复。...Oracle 12.2.0.1 RAC 基于生产环境安装手册,非常详细,全是干货,完全安装生产环境来部署撰写的!
Oracle 数据库 9i/10g/11g 扫描,优化提示,安全提示(免费,免注册,绿色,VC++编写,高效率) ====================================...15,RAC配置步骤总结windows, linux, solaris, aix, hp-ux各平台(还在移植...)
数据泵技术是Oracle Database 10g 中的新技术,它比原来导入/导出(imp,exp)技术快15-45倍。速度的提高源于使用了并行技术来读写导出转储文件。 expdp/impdp和exp/imp的区别 exp和imp是客户端工具程序,它们既可以在...
说明:本文为Linux下Oracle进程追踪调试指导手册, 标签:strace、进程追踪、进程调试、Oracle进程追踪调试 温馨提示:如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化 正文开始 大纲 –...
13.4 安装Oracle RAC数据库 13.4.1 安装前的系统配置需求 13.4.2 设置数据库安装资源 13.4.3 配置主机解析文件 13.4.4 检查所需软件包 13.4.5 配置系统内核参数 13.4.6 设置 Shell对Oracle用户的限制 ...
ebackup是一款专业oracle备份软件。该软件已经经过大量的功能测试、容错性测试和压力测试,性能稳定可靠。...5 支持windows和linux操作系统。 6 可以用IE查看备份结果,无需查看日志。 7 可以实现异地容灾。
两节点RAC,Oracle11.2.0.1版本,Linux操作系统 2.recover database时提示需使用backup controlfile 3.rman list backupset无输出 由于没有记录具体的操作,这里主要碰到的异常做一下描述 1.重启数据库...