通过backup as copy在线迁移表空间数据文件

jiawang

报错现象：


查看数据文件88号
select file#，status,name from v$datafile;


发现88号数据文件创建到了本地磁盘且中间还有空格符号，导致的业务报错

解决办法：
1、备份该数据文件

RMAN>  backup as copy datafile 88 format '+dgdata';

Starting backup at 11-MAY-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00088 name=/u01/app/oracle/product/11.2.0/db_1/dbs/ TS_EXCHANGE  
output file name=+DGDATA/orcl/datafile/zlnecuser1.5106.1072284985 tag=TAG20210511T165624 RECID=134 STAMP=1072285084
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45
Finished backup at 11-MAY-21

Starting Control File and SPFILE Autobackup at 11-MAY-21
piece handle=+DGDATA/orcl/autobackup/2021_05_11/s_1072285090.4095.1072285095 comment=NONE
Finished Control File and SPFILE Autobackup at 11-MAY-21

2、将该数据文件离线
alter database datafile 88 offline；

当前88号文件就会变成recover状态。


3、rman执行
RMAN> switch datafile 88 to copy;

datafile 88 switched to datafile copy "+DGDATA/orcl/datafile/zlnecuser1.5106.1072284985"

RMAN> RECOVER datafile 88;

Starting recover at 11-MAY-21
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 11-MAY-21

4、对数据文件88执行在线操作
alter database datafile 88 online；