类似于sqlplus操作数据库一样,asmcmd工具可以实现对ASM的管理。简单直观的看一下asmcmd带给我的功能。1.连接到ASM实例既然要管理ASM,必要要指定ASM实例,我们需要告知asmcmd的两件事情是:①.ORACLE_HOME环境变量是什么;②.所要连接到的ASM实例时什么。然后直接使用“asmcmd”或“asmcmd -p”(-p选项可以在命令提示符中给出当前的路径信息)便可连接到对应的ASM。RACDB1@rac1 /home/oracle$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1RACDB1@rac1 /home/oracle$ export ORACLE_SID=+ASM1+ASM1@rac1 /home/oracle$ asmcmdASMCMD>ASMCMD> exit+ASM1@rac1 /home/oracle$ asmcmd -pASMCMD [+] >2.获取asmcmd工具的帮助信息ASMCMD [+] > helpasmcmd [-p] [command]The environment variables ORACLE_HOME and ORACLE_SID determine theinstance to which the program connects, and ASMCMD establishes abequeath connection to it, in the same manner as a SQLPLUS / ASSYSDBA. The user must be a member of the SYSDBA group.Specifying the -p option allows the current directory to be displayedin the command prompt, like so:ASMCMD [+DATAFILE/ORCL/CONTROLFILE] >[command] specifies one of the following commands, along with itsparameters.Type "help [command]" to get help on a specific ASMCMD command.commands:--------cddufindhelplslsctlsdgmkaliasmkdirpwdrmrmaliasasmcmd工具提供了以上简单的操作ASM文件的命令。3.将常用的命令做一个演示ASMCMD [+] > lsDATA/FRA/ASMCMD [+] > cd DATAASMCMD [+DATA] >ASMCMD [+DATA] > cd ..ASMCMD [+] > lsctDB_Name Status Software_Version Compatible_version Instance_NameRACDB CONNECTED 10.2.0.1.0 10.2.0.1.0 RACDB1RACDB CONNECTED 10.2.0.1.0 10.2.0.1.0 RACDB1ASMCMD [+] > lsdgState Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks NameMOUNTED EXTERN N N 512 4096 1048576 2047 7 0 7 0 DATA/MOUNTED EXTERN N N 512 4096 1048576 2047 1825 0 1825 0 FRA/ASMCMD [+data/racdb] > pwd+data/racdbASMCMD [+data/racdb] > ls1_10_733447664.dbf1_11_733447664.dbf1_12_733447664.dbf1_13_733447664.dbf1_14_733447664.dbf1_15_733447664.dbf1_16_733447664.dbf1_17_733447664.dbf1_18_733447664.dbf1_19_733447664.dbf1_20_733447664.dbf1_3_733447664.dbf1_4_733447664.dbf1_5_733447664.dbf1_6_733447664.dbf1_7_733447664.dbf1_8_733447664.dbf1_9_733447664.dbf2_1_733447664.dbf2_2_733447664.dbf2_3_733447664.dbf2_4_733447664.dbf2_5_733447664.dbfARCHIVELOG/CONTROLFILE/DATAFILE/ONLINELOG/PARAMETERFILE/TEMPFILE/spfileRACDB.ora4.小结asmcmd工具提供的功能虽然不是很丰富,但对于相对闭塞的ASM来说,它是一个非常有效的操作工具。Good luck.secooler10.11.06-- The End --
oracle管理asm工具,【asmcmd】使用asmcmd工具管理ASM
最新推荐文章于 2023-06-25 17:25:33 发布