asm 表空间 目录 别名 映射 相关内容

创建表空间

SELECT NAME FROM V$DATAFILE;

CREATE TABLESPACE mytblspace DATAFILE '+LH_TEST' SIZE 200M AUTOEXTEND ON; 

自动创建的

移动数据文件

ALTER DATABASE MOVE DATAFILE '+LH_TEST/CDB1/DATAFILE/mytblspace.256.1086363249'

TO '+ZS_TEST/CDB1/DATAFILE/mytblspace';

 文件映射 

在数据中修改

ALTER SYSTEM SET FILE_MAPPING=TRUE;

EXECUTE DBMS_STORAGE_MAP.MAP_ALL(10000);

在PDB下运行,

EXECUTE DBMS_STORAGE_MAP.MAP_OBJECT('EMPLOYEES','HR','TABLE');

SELECT io.OBJECT_NAME o_name, io.OBJECT_OWNER o_owner, io.OBJECT_TYPE o_type,

       mf.FILE_NAME, me.ELEM_NAME, io.DEPTH,

      (SUM(io.CU_SIZE * (io.NUM_CU - DECODE(io.PARITY_PERIOD, 0, 0,

                         TRUNC(io.NUM_CU / io.PARITY_PERIOD)))) / 2) o_size

   FROM MAP_OBJECT io, V$MAP_ELEMENT me, V$MAP_FILE mf

   WHERE io.OBJECT_NAME =  'EMPLOYEES'

   AND   io.OBJECT_OWNER = 'HR'

   AND   io.OBJECT_TYPE =  'TABLE'

   AND   me.ELEM_IDX = io.ELEM_IDX

   AND   mf.FILE_MAP_IDX = io.FILE_MAP_IDX

   GROUP BY io.ELEM_IDX, io.FILE_MAP_IDX, me.ELEM_NAME, mf.FILE_NAME, io.DEPTH,

         io.OBJECT_NAME, io.OBJECT_OWNER, io.OBJECT_TYPE

   ORDER BY io.DEPTH;

Oracle ASM 文件名添加别名 

CREATE TABLESPACE lhtblspace;

 

在创建一个吧，没注意看

ALTER DISKGROUP LH_TEST ADD ALIAS '+LH_TEST/CDB1/DATAFILE/lh.dbf'

     FOR '+LH_TEST/CDB1/DATAFILE/lh.256.1086367769';

两个都保留 

 

重命名 Oracle ASM 文件名的别名 

ALTER DISKGROUP LH_TEST RENAME ALIAS '+LH_TEST/CDB1/DATAFILE/lh.dbf'

     TO '+LH_TEST/CDB1/DATAFILE/lihao.dbf';

删除 Oracle ASM 文件名的别名

ALTER DISKGROUP LH_TEST DROP ALIAS '+LH_TEST/CDB1/DATAFILE/lihao.dbf';

删除文件

ALTER DISKGROUP LH_TEST

     DROP FILE '+LH_TEST/CDB1/DATAFILE/lh.256.1086367769';

创建新目录

ALTER DISKGROUP LH_TEST ADD DIRECTORY '+LH_TEST/orcl';

 

重命名目录

ALTER DISKGROUP LH_TEST RENAME DIRECTORY '+LH_TEST/orcl'

     TO '+LH_TEST/lhmulu';

 

删除目录

ALTER DISKGROUP LH_TEST DROP DIRECTORY '+LH_TEST/lhmulu' FORCE;