Oracle
文章平均质量分 77
airmy
这个作者很懒,什么都没留下…
展开
-
理解ASM File Alias
ASM别名可以看作是OMF的扩展,先了解文件系统的OMF [oracle@Oracle ~]$ export ORACLE_SID=test [oracle@Oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 29 21:12:48 2012 Copyright (c) 19原创 2012-03-29 22:24:27 · 806 阅读 · 0 评论 -
ASM初探-1
本次实验的目的是将单实例Oracle数据用文件系统存储迁移到ASM上,sdc1、sdd1、sde1、sdf1使用这四块盘创建ASM DiskGroup. 安装oracleasm的rpm包 [root@Oracle ~]# ls anaconda-ks.cfg oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpm Desktop原创 2012-03-29 20:55:50 · 773 阅读 · 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 · 1411 阅读 · 0 评论 -
利用隐藏参数_asm_allow_only_raw_disks创建ASM环境
[root@Oracle ~]# fdisk -l Disk /dev/sda: 8589 MB, 8589934592 bytes 255 heads, 63 sectors/track, 1044 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start En原创 2012-03-30 13:46:35 · 617 阅读 · 0 评论 -
drop diskgroup报ora-15001
SQL> alter diskgroup dg1 mount; alter diskgroup DG1 mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15130: diskgroup "DG1" is being dismounted ORA-15066: offlining disk ""原创 2012-03-30 13:26:55 · 3927 阅读 · 0 评论