oracle导出asm数据,Oracle使用RMAN将普通数据文件转成ASM

1. 数据库启动至mount

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

2. RMAN备份数据文件

RMAN> backup as copy database format '+data';

Starting backup at 27-MAR-18

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=6 device type=DISK

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf

3. switch datafile

RMAN> switch database to copy;

datafile 1 switched to datafile copy "+DATA/test/datafile/system.276.971869559"

datafile 2 switched to datafile copy "+DATA/test/datafile/sysaux.277.971869589"

datafile 3 switched to datafile copy "+DATA/test/datafile/undotbs1.278.971869615"

datafile 4 switched to datafile copy "+DATA/test/datafile/users.280.971869621"

4. alter database open

SQL> alter database open;

Database altered.

5. 验证

SQL> select file_name from dba_data_files;

FILE_NAME

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

+DATA/test/datafile/users.280.971869621

+DATA/test/datafile/undotbs1.278.971869615

+DATA/test/datafile/sysaux.277.971869589

+DATA/test/datafile/system.276.971869559

6. 删除原数据文件

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8520577/viewspace-2152252/，如需转载，请注明出处，否则将追究法律责任。