从视图获得asm信息。 - 数据库编程

TOP

从视图获得asm信息。(五)

2014-11-24 03:31:03 来源: 作者: 【大中小】浏览:3次

OUP1 325 80 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 80 M /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 81 P /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 81 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 82 P /dev/oracleasm/disks/ASMDISK4 NAME FILE NUMBER EXTENT NUMBER EX PATH ---------------------------------------- ----------- ------------- -- ------------------------------------------------------------ DATAGROUP1 325 82 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 83 P /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 83 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 84 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 84 M /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 85 P /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 85 M /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 86 P /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 86 M /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 87 P /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 87 M /dev/oracleasm/disks/ASMDISK4 NAME FILE NUMBER EXTENT NUMBER EX PATH ---------------------------------------- ----------- ------------- -- ------------------------------------------------------------ DATAGROUP1 325 88 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 88 M /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 89 P /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 89 M /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 90 P /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 90 M /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 91 P /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 91 M /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 92 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 92 M /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 93 P /dev/oracleasm/disks/ASMDISK2 NAME FILE NUMBER EXTENT NUMBER EX PATH ---------------------------------------- ----------- ------------- -- ------------------------------------------------------------ DATAGROUP1 325 93 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 94 P /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 94 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 95 P /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 95 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 96 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 96 M /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 97 P /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 97 M /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 98 P /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 98 M /dev/oracleasm/disks/ASMDISK1 NAME FILE NUMBER EXTENT NUMBER EX PATH ---------------------------------------- ----------- ------------- -- ------------------------------------------------------------ DATAGROUP1 325 99 P /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 99 M /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 100 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 100 M /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 2147483648 P /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 2147483648 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 2147483648 MM /dev/oracleasm/disks/ASMDISK4 205 rows selected. SQL>

可以看到在normal情况下，每个区都是存在镜像的，且默认创建一个表空间指定的文件为100Mb。

2、查看相关视图获得asm 磁盘组的信息。见如下神图（摘自网络）：

首页上一页 2 3 4 5 下一页尾页 5/5/5
【大中小】【打印】【繁体】【投稿】【收藏】【推荐】【举报】【评论】【关闭】【返回顶部】
分享到:
上一篇：OCM实验目录	下一篇：恢复数据库时需要关注的scn信息

帐　　号:

密码: (新用户注册)

验证码:

表　　情:

内　　容: