I have seen many users asking how to find “Master node” in Oracle RAC, let me clear some of their doubts.
There are two types of Masters in Oracle RAC, one is Mater node at Oracle Clusterware level and other is Master node for specific resource or block or object.
The node which gets the active state during startup is authorized to be a master node by Cluster Synchronization Service.
Run the below command to find which node is master at Clusterware level
$cat $ORA_CRS_HOME/log/`hostname`/cssd/ocssd* |grep master
or
$ for x in `ls -tr $ORA_CRS_HOME/log/`hostname`/cssd/ocssd* `; do grep -i "master node" $x ; done | tail -1
The OCR Automatic backups are taken only by master node. If the Master fails, the OCR backups will be created on the new Master. The Master node which has OCR backups goes down due to failure then we cannot be recover the OCR that’s why Oracle recommends taking backups using “ocrconfig” and also integrating OCR backups with backup strategy.
Run the below command to find which node is OCR Master and taking automatic backups.
$ocrconfig –showbackup
testrac02 2010/08/30 16:29:52 /oracle/crs/cdata/crs
testrac02 2010/08/30 16:29:52 /oracle/crs/cdata/crs
testrac02 2010/08/30 12:29:49 /oracle/crs/cdata/crs
testrac02 2010/08/30 08:29:46 /oracle/crs/cdata/crs
testrac02 2010/08/29 00:29:23 /oracle/crs/cdata/crs
The block level masters are used by Cache fusion while transferring the block. Any node can become the master node of a particular block and you can also see which node acting as master in V$GES_RESOURCE table (MASTER_NODE column)
You can manually remaster an object with oradebug command:
SQL> oradebug lkdebug -m pkey "object_id"
Regards
Satishbabu Gunukula
http://www.oracleracexpert.com
How to find Master Node in Oracle RAC(zt)
How to find Master Node in Oracle RAC
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7734298/viewspace-683605/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to find Current open Cursors in OracleOracle
- How Oracle Store Number internal(zt)Oracle
- Oracle RAC TAF [zt]Oracle
- [zt] ORACLE RAC原理Oracle
- jboss oracle rac (zt)Oracle
- How to drop Oracle RAC database manually?OracleDatabase
- [zt] Oracle RAC 後臺程式Oracle
- How to Find Out How Much Space an Index is UsingIndex
- 單機安裝Oracle RAC (zt)Oracle
- [zt] Oracle RAC Load Balance [final]Oracle
- How to find the UDID for an iPhone/iPod touchiPhone
- Master Note for RAC Oracle Clusterware and Oracle Grid Infrastructure 1096952.ASTOracleStruct
- Oracle10g RAC ASM磁碟組[zt]OracleASM
- Oracle RAC 的監控和調整 (zt)Oracle
- How To Deal With Split Brain In Oracle 19c RacAIOracle
- 關於 RAC VIP (Oracle10G RAC) 的探討(zt)Oracle
- Oracle 11g rac add nodeOracle
- 11.2.0.2管理Oracle RAC One Node DatabaseOracleDatabase
- How does SAP freelancer find a project that is not tough?Project
- How do you find that an operation mode switch occurred?
- [ZT] Oracle 10g RAC的相關概念Oracle 10g
- [zt]Oracle rac 11g線上新增ocr,votediskOracle
- zt_oracle rac private network cluster interconnectOracle
- Oracle10g RAC安裝手冊 (zt)Oracle
- No known master node問題AST
- zt_How to read ERRORSTACK outputError
- [zt] JDBC連線Oracle RAC的連線串配置JDBCOracle
- [zt] Oracle RAC的Failover設定與測試OracleAI
- [zt Oracle RAC 負載均衡 --Oracle OpenWorld2007Oracle負載
- RAC軟體架構——RAC概念(zt)架構
- How To Generate A New Master Encryption Key for the TDE_445147.1AST
- Oracle RAC 10g叢集節點刪除[zt]Oracle
- Oracle FailSafe與rac的聯絡與區別(zt)OracleAI
- Oracle10g RAC for Linux配置全過程(zt)OracleLinux
- Webspere配置Oracle RAC 資料來源的問題 (ZT)WebOracle
- How to Find Sessions Generating Lots of Redo or Archive logsSessionHive
- master bug InnoDB Error unlock row could not find a 4 mode lockASTError
- 14-Architecture-Master-Node CommunicationAST