![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
文章平均质量分 77
airmy
这个作者很懒,什么都没留下…
展开
-
理解ASM File Alias
ASM别名可以看作是OMF的扩展,先了解文件系统的OMF[oracle@Oracle ~]$ export ORACLE_SID=test[oracle@Oracle ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 29 21:12:48 2012Copyright (c) 19原创 2012-03-29 22:24:27 · 800 阅读 · 0 评论 -
ASM初探-1
本次实验的目的是将单实例Oracle数据用文件系统存储迁移到ASM上,sdc1、sdd1、sde1、sdf1使用这四块盘创建ASM DiskGroup.安装oracleasm的rpm包[root@Oracle ~]# lsanaconda-ks.cfg oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpmDesktop原创 2012-03-29 20:55:50 · 768 阅读 · 1 评论 -
理解dbms_file_transfer
新建一张测试数据表SQL> create table a (id number,name char(2000));Table created.SQL> insert into a values (1,'abc');1 row created.SQL> insert into a values (2,'def');1 row created.SQL> insert int原创 2012-03-30 11:14:08 · 1407 阅读 · 0 评论 -
利用隐藏参数_asm_allow_only_raw_disks创建ASM环境
[root@Oracle ~]# fdisk -lDisk /dev/sda: 8589 MB, 8589934592 bytes255 heads, 63 sectors/track, 1044 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start En原创 2012-03-30 13:46:35 · 614 阅读 · 0 评论 -
drop diskgroup报ora-15001
SQL> alter diskgroup dg1 mount;alter diskgroup DG1 mount*ERROR at line 1:ORA-15032: not all alterations performedORA-15130: diskgroup "DG1" is being dismountedORA-15066: offlining disk ""原创 2012-03-30 13:26:55 · 3917 阅读 · 0 评论