文件系统与ASM的左右迁移

ASM迁移到文件系统

现我们接到如下需求：
将 ASM 共享盘中 OPTMTBS 表空间数据文件迁移到文件系统中。
asm 迁移到文件系统上共有三种解决方案。

SQL> select a.name, b.name from v$tablespace a, v$datafile b where a.ts# = b.ts#;

NAME                                               NAME
-------------------------------------------------- --------------------------------------------------
SYSTEM                                             +DATA/szdb/datafile/system.259.1089334417
SYSAUX                                             +DATA/szdb/datafile/sysaux.260.1089334417
UNDOTBS1                                           +DATA/szdb/datafile/undotbs1.261.1089334419
UNDOTBS2                                           +DATA/szdb/datafile/undotbs2.263.1089334425
USERS                                              +DATA/szdb/datafile/users.264.1089334425
OPTMTBS                                            +DATA/szdb/datafile/optmtbs01.dbf

rman

# 创建数据文件存放路径
[oracle@rac1 ~]$ mkdir -p /u01/app/oracle/oradata/szdb

# 将表空间离线
RMAN> sql 'alter tablespace OPTMTBS offline';

# 拷贝数据文件到文件系统中
RMAN> copy datafile '+DATA/szdb/datafile/optmtbs.269.1091028875' to '/u01/app/oracle/oradata/szdb/optmtbs.269.1091028875';
Starting backup at 2021-12-11 16:08:50
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=56 instance=szdb1 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=+DATA/szdb/datafile/optmtbs.269.1091028875
output file name=/u01/app/oracle/oradata/szdb/optmtbs.269.1091028875 tag=TAG20211211T160850 RECID=3 STAMP=1091030935
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 2021-12-11 16:08:57

# 转换数据文件
RMAN> switch datafile '+DATA/szdb/datafile/optmtbs.269.1091028875' to copy;
datafile 6 switched to datafile copy "/u01/app/oracle/oradata/szdb/optmtbs.269.1091028875"

# 恢复数据文件
RMAN> recover datafile "/u01/app/oracle/oradata/szdb/optmtbs.269.1091028875";
Starting recover at 2021-</