PIXNET Logo登入

DanBrother的部落格

跳到主文

歡迎光臨DanBrother在痞客邦的小天地. 部落格文章同步於=> http://blog.xuite.net/gem083/dba

部落格全站分類:數位生活

  • 相簿
  • 部落格
  • 留言
  • 名片
  • 7月 19 週四 201214:22
  • How to Check the Integrity of Oracle Clusterware Files

The following techniques are used to validate the integrity of Oracle Cluster configuration files, namely OCR and voting disks.
1. Check the ocssd.log for voting disk issues. (run as grid user)
# grep voting $Grid_home/log/hostname/cssd/ocssd.log

2. Use the cluvfy utility to check the integrity of the OCR. (run as grid user)
# cluvfy comp ocr -n all -verbose

3. Use the ocrcheck command to check the integrity of the OCR. (run as root user)
# $Grid_home/bin/ocrcheck
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(12)

  • 個人分類:Oracle Clusterware
▲top
  • 2月 08 週三 201216:27
  • crs_stat command usage

crs_stat command usage :
Examine Clusterware Status In a Tabular Format:
# crs_stat -t
Examine Clusterware Parameter Settings:
# crs_stat -p
Examine Clusterware Permissions and Ownership:
# crs_stat -ls
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(16)

  • 個人分類:Oracle Clusterware
▲top
  • 12月 12 週一 201115:30
  • Oracle Clusterware Components

Oracle Clusterware includes two important components:
1. Voting disk:  A file that manages information about node membership
2  OCR (Oracle Cluster Registry): A file that manages cluster and Oracle RAC database configuration information.
These files can be stored on ASM (Automatic Storage Management) or a cluster filesystem.
[Reference]
http://docs.oracle.com/cd/B28359_01/rac.111/b28252/adminoc.htm
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(8)

  • 個人分類:Oracle Clusterware
▲top
  • 12月 12 週一 201115:19
  • Viewing Available OCR Backups

Oracle Clusterware automatically creates OCR backups every 4 hours.
At any one time, Oracle Clusterware always retains the latest 3 backup copies of the OCR that are 4 hours old, 1 day old, and 1 week old.
Command for viewing Available OCR Backups:
ocrconfig -showbackup

[Reference] http://docs.oracle.com/cd/B28359_01/rac.111/b28252/adminoc.htm#BEJHGHFD

(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(5)

  • 個人分類:Oracle Clusterware
▲top
  • 8月 26 週五 201114:35
  • crsctl command usage

Stop CRS:
crsctl stop crs (normal)
crsctl stop crs -f (force)

Start CRS:
crsctl start crs

Checking Resource Status for CRS: (replaces crs_stat -t -v in Oracle11gR2)
crsctl status resource -t or
crsctl stat res -t or
crsctl stat res -t -init (only local node status)
** Different resources can be filtered by the following commands:
crsctl stat res -t -w "TYPE = ora.database.type" (Database)
crsctl stat res -t -w "TYPE = ora.asm.type" (ASM)

crsctl stat res -t -w "TYPE = ora.scan_listener.type" (Scan Listener)
crsctl stat res -t -w "TYPE = ora.scan_vip.type" (Scan VIP)
crsctl stat res -t -w "TYPE = ora.cvu.type" (Cluster Verification Utility)

ps. equal sign (=) should have space in between


(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(136)

  • 個人分類:Oracle Clusterware
▲top
1

廣告

個人資訊

DanBrother
暱稱:
DanBrother
分類:
數位生活
好友:
累積中
地區:

熱門文章

  • (58,073)祝福禱告文-為工作祝福
  • (49,259)Excel 2007 中文字顯示亂碼之修復步驟
  • (2,928)ORA-24247: 存取控制清單 (ACL) 拒絕網路存取
  • (625)OSQL公用程式的使用方法
  • (136)crsctl command usage
  • (84)Oracle 11.2.0.3 Grid Infrastructure ora.diskmon shows OFFLINE
  • (83)ORA-15306: ASM Password File Update Failed On At Last One Node
  • (15)DB_FILE_MULTIBLOCK_READ_COUNT
  • (6)SQL Server 2005 Reporting Services Permission Settings for Viewing Reports
  • (5)RPM & SRPM

文章分類

  • Android (1)
  • Java (1)
  • MongoDB (1)
  • MariaDB (7)
  • Python (10)
  • HTML (1)
  • ORDS (1)
  • Apache Tomcat (1)
  • Oracle Streams (1)
  • Javascript (1)
  • Oracle Data Guard (2)
  • Oracle VirtualBox (3)
  • Grid Infrastructure (4)
  • Oracle SQL Tuning (6)
  • OEM11g / 12c (28)
  • IT Links (1)
  • 心靈饗宴 (161)
  • Oracle Clusterware (5)
  • ORACLE RAC (21)
  • Oracle ASM (18)
  • Oracle Export/Import (10)
  • MySQL (22)
  • Windows Series (18)
  • Oracle HTTP Server (8)
  • Linux (49)
  • Microsoft Office (6)
  • SQL SERVER (19)
  • Install Apache & PHP (2)
  • Oracle in General (111)
  • RMAN (15)
  • SQL / PL/SQL (30)
  • 未分類文章 (1)

最新文章

  • MySQL Array Simulation in Stored Procedure
  • Extracts, orders, and then prints grants for MySQL user accounts (pt-show-grants)
  • MySQL Stored Procedure - Nested Loop Example
  • Metabase H2 DB Migration to MySQL 5.7
  • Steps for Upgrading Percona-Toolkit to the Latest Version
  • MySQL Slave - Skip Replication for A Particular Table
  • MySQL - Export & Import Table Data Based on the SQL Query
  • MySQL Table Fragmentation Detection and De-fragmentation Implementation
  • Multiple Log File Viewer (Linux Bash)
  • Solving MySQL slave lag Issues

最新留言

  • [21/08/16] jwang0189 於文章「祝福禱告文-為工作祝福...」留言:
    非常實用的文章,謝謝提供,已點廣告表示支持 https://...
  • [20/04/23] 廣利 於文章「祝福禱告文-為工作祝福...」留言:
    129:8 過路的也不說,願耶和華所賜的福,歸於你們;我們在...
  • [17/10/30] 66國語言翻譯公司 於文章「Download Google Chro...」留言:
    不了走會點中見你隻有果新家而去十走相隻把見作樣 95國...
  • [17/05/06] 50國語言翻譯公司 於文章「Python >>> a, b = b...」留言:
    之的不會然文道果三那大這年來來年物月用理學, 115國...
  • [16/10/13] KK 於文章「How to Change Defaul...」留言:
    感謝您分享的工作禱詞! 真的太感謝了!! 願 平安...
  • [15/08/23] 洪秀柱 於文章「如何在UltraEdit中正常顯示韓文?...」留言:
    此破解法可用於 UEstudio UltraEdit V2...

動態訂閱

文章精選

文章搜尋

誰來我家

參觀人氣

  • 本日人氣:
  • 累積人氣:

留言板