oracle 收集asm例項資訊
以下這個指令碼用於方便收集asm例項資訊,以便出故障後,能夠快速解決問題:
生成的是html檔案
spool dbcollect_$ORACLE_SID.html
!date >> dbcollect_$ORACLE_SID.html
SET MARKUP HTML ON
set echo on
set pagesize 200
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual;
select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';
select * from v$asm_diskgroup;
SELECT * FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER;
SELECT * FROM V$ASM_CLIENT;
select * from V$ASM_ATTRIBUTE;
select * from v$asm_operation;
select * from gv$asm_operation;
select * from v$version;
SELECT * FROM V$ASM_CLIENT;
SELECT * FROM V$ASM_DISK_STAT ORDER BY GROUP_NUMBER,DISK_NUMBER;
SELECT * FROM V$ASM_DISKGROUP_STAT ORDER BY GROUP_NUMBER;
SELECT * FROM V$ASM_FILE ORDER BY GROUP_NUMBER,FILE_NUMBER;
SELECT * FROM V$ASM_ALIAS ORDER BY GROUP_NUMBER,FILE_NUMBER;
SELECT * FROM V$ASM_TEMPLATE ORDER BY GROUP_NUMBER,ENTRY_NUMBER;
show parameter asm
show parameter cluster
show parameter instance_type
show parameter instance_name
show parameter spfile
show sga
spool off
exit
!date >> dbcollect_$ORACLE_SID.html
SET MARKUP HTML ON
set echo on
set pagesize 200
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual;
select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';
select * from v$asm_diskgroup;
SELECT * FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER;
SELECT * FROM V$ASM_CLIENT;
select * from V$ASM_ATTRIBUTE;
select * from v$asm_operation;
select * from gv$asm_operation;
select * from v$version;
SELECT * FROM V$ASM_CLIENT;
SELECT * FROM V$ASM_DISK_STAT ORDER BY GROUP_NUMBER,DISK_NUMBER;
SELECT * FROM V$ASM_DISKGROUP_STAT ORDER BY GROUP_NUMBER;
SELECT * FROM V$ASM_FILE ORDER BY GROUP_NUMBER,FILE_NUMBER;
SELECT * FROM V$ASM_ALIAS ORDER BY GROUP_NUMBER,FILE_NUMBER;
SELECT * FROM V$ASM_TEMPLATE ORDER BY GROUP_NUMBER,ENTRY_NUMBER;
show parameter asm
show parameter cluster
show parameter instance_type
show parameter instance_name
show parameter spfile
show sga
spool off
exit
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-694523/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11.2.0.3 管理ASM例項OracleASM
- Oracle 11.2.0.3管理ASM例項OracleASM
- 【Oracle】ASM例項安裝入門OracleASM
- ASM之建立ASM例項ASM
- Oracle單例項+ASM新增控制檔案Oracle單例ASM
- 單例項刪除ASM例項單例ASM
- 管理 ASM 例項ASM
- 停止ASM例項ASM
- redhat 6.5之oracle 11.2.0.4 asm例項異常抽取asm配置資訊之amdu初識之一RedhatOracleASM
- 【Oracle ASM】關於asm例項與db例項中的磁碟狀態_詳細分析過程OracleASM
- oracle11g asm單例項重建hasOracleASM單例
- ASM單例項(Oracle 11.2.0.4)環境(一)ASM單例Oracle
- ASM單例項(Oracle 11.2.0.4)環境(二)ASM單例Oracle
- Oracle單例項+ASM啟動與關閉Oracle單例ASM
- (轉)Oracle rac環境下清除asm例項OracleASM
- 刪除ASM例項ASM
- 驗證11gR2 RAC中ASM例項通過gpnp profile獲得spfile資訊來啟動ASM例項ASM
- 全面學習和應用ORACLE ASM特性--(1)關於asm例項OracleASM
- ASM之建立ASM例項及ASM資料庫ASM資料庫
- 建立ASM例項及ASM資料庫ASM資料庫
- 給ASM例項增加diskgroupASM
- asm例項刪除方法ASM
- oracle10.2.0.1 (rhel4)rac刪除asm例項不乾淨導致重建asm例項出錯OracleASM
- Oracle收集統計資訊Oracle
- Oracle 統計資訊收集Oracle
- 收集oracle統計資訊Oracle
- ORACLE 收集統計資訊Oracle
- Oracle 11gR2 ASM例項記憶體管理OracleASM記憶體
- Window下安裝Oracle ASM單例項資料庫OracleASM單例資料庫
- Oracle 10gR2 下配置簡單ASM例項Oracle 10gASM
- oracle 10g asm 例項開關機順序Oracle 10gASM
- Oracle ASM檢視資訊OracleASM
- RAC+DG(asm單例項)ASM單例
- 單例項的duplicate(non ASM)單例ASM
- 啟動ASM 例項報錯ASM
- Oracle Restart啟動資料庫例項故障一例( Oracle ASM儲存Spfile解析)OracleREST資料庫ASM
- oracle11g使用pl/sql developer連線asm例項OracleSQLDeveloperASM
- oracle 11gR2 配置goldengate連線asm例項OracleGoASM