在线迁移数据文件（12c+）

参考文档
How to move ASM database files from one diskgroup to another ? (Doc ID 330103.1)
12C New Feature : Move a Datafile Online (Doc ID 1566797.1)

在线迁移数据文件（12c+）
如果指定了KEEP子句，那么在移动操作之后将保留旧文件。如果源文件是OMF的文件，即使加了keep也会删除旧数据文件。

alter session set container=BZPROD;
set lines 200 pages 50000
select 'alter database move datafile '||file_id||' to ''+BZPRODDATA'';' from dba_data_files where file_name like '%bzprodc%' order by file_id;

alter session set container=BZPROD;
set lines 200 pages 50000
col file_name for a95
col TABLESPACE_NAME for a25
select file_id,file_name,tablespace_name,autoextensible,BYTES/1024/1024 SIZE_GB,MAXBYTES/1024/1024 MAX_GB,status from dba_data_files order by 1;
select file_id,file_name,tablespace_name,autoextensible,BYTES/1024/1024 SIZE_GB,MAXBYTES/1024/1024 MAX_GB,status from dba_temp_files order by 1;

alter session set container=BZPROD;
set lines 200 pages 9999 
select name from v$datafile 
union 
select member from v$logfile 
union 
select name from v$controlfile 
union 
select name from v$tempfile; 

pdb datafile 在ASM间搬迁 Oracle 各版本 移动datafile tempfile

---纯move datafile--在线做， 别的都需要停一下机---
select 'alter database move datafile '||file_id ||' to ''+ '';' from cdb_data_files a where a.file_name not like '+ %';
select 'alter tablespace temp drop tempfile '||file_id|| ';' from dba_temp_files;

select * from cdb_data_files a where a.file_name not like '+ %';
select * from cdb_temp_files a where a.file_name not like '+ %';

select * from v$containers;