文件系统与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-</