设为首页 加入收藏

TOP

Oracleasmkfed工具的使用之一(二)
2015-11-21 01:27:29 来源: 作者: 【 】 浏览:1
Tags:Oracleasmkfed 工具 使用 之一
lated block text [TEXT=string] ty/pe ASM metadata block type number [TYPE=number] [oracle@localhost lib]$ export ORACLE_SID=+ASM [oracle@localhost lib]$ ps -ef | grep asm oracle 5072 1 0 23:38 ? 00:00:00 asm_pmon_+ASM oracle 5074 1 0 23:38 ? 00:00:00 asm_psp0_+ASM oracle 5076 1 0 23:38 ? 00:00:00 asm_mman_+ASM oracle 5078 1 0 23:38 ? 00:00:00 asm_dbw0_+ASM oracle 5080 1 0 23:38 ? 00:00:00 asm_lgwr_+ASM oracle 5082 1 0 23:38 ? 00:00:00 asm_ckpt_+ASM oracle 5084 1 0 23:38 ? 00:00:00 asm_smon_+ASM oracle 5086 1 0 23:38 ? 00:00:00 asm_rbal_+ASM oracle 5088 1 0 23:38 ? 00:00:00 asm_gmon_+ASM oracle 5280 5168 0 23:46 pts/1 00:00:00 grep asm [oracle@localhost lib]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jan 6 23:46:27 2015 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> show parameter inst NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ active_instance_count integer cluster_database_instances integer 1 instance_groups string instance_name string +ASM instance_number integer 0 instance_type string asm open_links_per_instance integer 4 parallel_instance_group string parallel_server_instances integer 1 SQL> Set pagesize 100 SQL> Set linesize 100 SQL> Col name format a15 SQL> select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB,FREE_MB,USABLE_FILE_MB from v$asm_diskgroup; GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB USABLE_FILE_MB ------------ --------------- ----------- ------ ---------- ---------- -------------- 1 DATADG MOUNTED EXTERN 15342 15288 15288 SQL> set pagesize 200 SQL> set linesize 150 SQL> col path format a20; SQL> col group_name format a10 SQL> col name format a20 SQL> select a.group_number,b.name as group_name,a.name,a.path,a.state,a.total_mb from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number; GROUP_NUMBER GROUP_NAME NAME PATH STATE TOTAL_MB ------------ ---------- -------------------- -------------------- -------- ---------- 1 DATADG DATADG_0000 /dev/raw/raw1 NORMAL 5114 1 DATADG DATADG_0001 /dev/raw/raw2 NORMAL 5114 1 DATADG DATADG_0002 /dev/raw/raw3 NORMAL 5114 SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@localhost lib]$ kfed read /dev/raw/raw1 text=/home/oracle/asmdisk_raw1.txt [oracle@localhost lib]$ [oracle@localhost lib]$ kfed read /dev/raw/raw2 text=/home/oracle/asmdisk_raw2.txt [oracle@localhost lib]$ [oracle@localhost lib]$ kfed read /dev/raw/raw3 text=/home/oracle/asmdisk_raw3.txt [oracle@localhost lib]$ [oracle@localhost lib]$ cd /home/oracle [oracle@localhost ~]$ ls -lrt total 215832 drwxr-xr-x 2 oracle oinstall 4096 Dec 11 2012 META-INF -rwxr-xr-x 1 root root 6464 May 14 2013 oracle_user_setup.sql -rwxr-xr-x 1 root root 2977 May 14 2013 oracle_drop_db_permissions.sql -rw-r--r-- 1 oracle oinstall 144608374 May 15 2013 agent.jar drwxr-xr-x 3 oracle oinstall 4096 May 15 2013 network drwxr-xr-x 8 oracle oinstall 4096 May 15 2013 av drwxr-xr-x 7 oracle oinstall 4096 May 15 2013 bin drwxr-x--- 3 oracle oinstall 4096 May 15 2013 oradiag_oracle drwxr-xr-x
首页 上一页 1 2 3 4 下一页 尾页 2/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇oracle lsnrctl 下一篇分享一个MySQL分库分表类(php)

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: