[oracle@oracle10g ~]$export ORACLE_SID=+ASM

    [oracle@oracle10g ~]$asmcmd

    要asm上创建表空间

    create smallfile tablespace user2 datafile '+DB1' size 100m autoextend on;

         sys@DNDN> select name from v$datafile;

    NAME

    ----------------------------------------------------------------------------------------------------

    /u01/app/oracle/oradata/dndn/system.dbf

    +DB1/dndn/datafile/user2.256.829002129

    /u01/app/oracle/oradata/dndn/sysaux.dbf

    /u01/app/oracle/oradata/dndn/users01.dbf

    /u01/app/oracle/oradata/dndn/undotbs.dbf

         ASM文件迁移

    使用rman 的方式(若不能脱机的表空间，则在mount下操作)

    1,users表空间的迁移(从文件系统到asm)

    rman>backup tablespace users;

    rman>run{

    sql 'alter tablespace users offline immediate';

    set newname for datafile 4 to '+DB1';

    restore tablespace users;

    switch datafile 4;

    recover tablespace users;

    sql 'alter tablespace users online';

    }

    下面写法和上面一样(但一个表空间可能有多个数据文件):

    rman>run{

    sql 'alter database datafile 4 offline';

    set newname for datafile 4 to '+DB1';

    restore datafile 4;

    switch datafile 4;

    recover datafile 4;

    sql 'alter database datafile 4 online';

    }

    2,users表空间的迁移(从asm到文件系统)

    rman>backup tablespace users;

    rman>run{

    sql 'alter tablespace users offline immediate';

    set newname for datafile 4 to '/u01/app/oracle/oradata/dndn/users01.dbf';

    restore tablespace users;

    switch datafile 4;

    recover tablespace users;

    sql 'alter tablespace users online';

    }




       Oracle认证