本文主要是介绍【ORACLE RAC】维护：asm维护， srvctl、crsctl,orcconfig等指令的使用。，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
2 asm ************************************************************************ ****原文：blog.csdn.net/clark_xu 徐长亮的专栏 ************************************************************************ 管理
2.1查看数据文件所在位置
select name from v$datafile
union
select member from v$logfile
union
select name from v$controlfile
union
select name from v$tempfile;
2.2在库实例中查看asm diskgroup
视图：V$asm_diskgroup, v$asm_disk,
Select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB,FREE_MBUNBALANCED from v$asm_diskgroup ;
查看更详细的信息
select STATE,REDUNDANCY,TOTAL_MB,FREE_MB,NAME,FAILGROUP from v$asm_disk;
TATE REDUNDA TOTAL_MB FREE_MB NAME
-------- ----------------- ---------- ------------------------------
FAILGROUP
------------------------------
NORMAL UNKNOWN 2048 0 DGDATA_0000
NORMAL UNKNOWN 2048 0 DGDATA_0001
NORMAL UNKNOWN 512 0 DGFRA_0000
查看asm disk
SQL>select path,group_number from v$asm_disk;
2.3 asmcmd的使用
[oracle@host1 crs]$ export ORACLE_SID=+ASM1
[oracle@host1 crs]$ asmcmd
ASMCMD> ls
DGDATA/
DGFRA/
[oracle@host1 ~]$ asmcmd lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED EXTERN N N 512 4096 1048576 4096 2777 0 2777 0 DGDATA/
MOUNTED EXTERN N N 512 4096 1048576 512 178 0 178 0 DGFRA/
[oracle@host1 ~]$ asmcmd lsct
DB_Name Status Software_Version Compatible_version Instance_Name
EDWPRD CONNECTED 10.2.0.1.0 10.2.0.1.0 EDWPRD1
EDWPRD CONNECTED 10.2.0.1.0 10.2.0.1.0 EDWPRD1
[oracle@host1 ~]$ asmcmd ls -l
State Type Rebal Unbal Name
MOUNTED EXTERN N N DGDATA/
MOUNTED EXTERN N N DGFRA/
3.监听的管理
LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifierorextended command:
start stop status
services version reload
save_config trace spawn
change_password quit exit
set* show*
LSNRCTL> status
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.10.173)(PORT=1521)))（连接监听器的名称和信息：主机名+监听端口号）
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux:Version10.2.0.5.0– Production(Listener版本信息，在一台机器多实例的情况下，很重要！因为版本对应向下兼容)
Start Date 05-DEC-2012 16:29:42
Uptime 47 days 17 hr. 58 min. 56sec
这篇关于【ORACLE RAC】维护：asm维护， srvctl、crsctl,orcconfig等指令的使用。的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
