Data file movement steps

File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    2048     SYSTEM               ***     +ORADATA1/stby_aml/datafile/system.258.926452627
2    1500     SYSAUX               ***     +ORADATA1/stby_aml/datafile/sysaux.259.926452627
3    4096     UNDOTBS1             ***     +ORADATA1/stby_aml/datafile/undotbs1.260.926452627
4    1024     USERS                ***     +ORADATA1/stby_aml/datafile/users.261.926452627
5    1024     ZABBIX_TS            ***     +ORADATA1/stby_aml/datafile/zabbix_ts.257.931872935
6    5120     misha                ***     +ORADATA1/stby_aml/datafile/misha.262.947279105
7    2048     VIZPROD_TS           ***     +ORADATA1/stby_aml/datafile/vizprod_ts.273.949097161
8    1500     CRPPROD_TS           ***     +ORADATA1/stby_aml/datafile/crpprod_ts.272.949097163
9    2048     ENTPROD_TS           ***     +ORADATA1/stby_aml/datafile/entprod_ts.271.949097163
10   2048     SYSTEM               ***     +ORADATA1/stby_aml/datafile/system.270.950133915
11   5000     PERFSTAT             ***     +ORADATA1/stby_aml/datafile/perfstat.269.951042695
12   5120     misha                ***     +ORADATA1/stby_aml/datafile/misha.268.951429927
13   1024     AUDTBS               ***     +ORADATA1/stby_aml/datafile/audtbs.267.955549483
14   1024     RULEPROD_TS1         ***     +ORADATA1/stby_aml/datafile/ruleprod_ts1.263.966204763
15   1024     JMS_TS1              ***     +ORADATA1/stby_aml/datafile/jms_ts1.275.966204769
16   1024     SDGPROD_TS1          ***     +ORADATA1/stby_aml/datafile/sdgprod_ts1.276.966204773
17   1500     mishaBPM             ***     +ORADATA1/stby_aml/datafile/mishabpm.274.947350467
18   1024     CRPROD_TS1           ***     +ORADATA1/stby_aml/datafile/crprod_ts1.277.966204779
19   1024     CBSPROD_TS1          ***     +ORADATA1/stby_aml/datafile/cbsprod_ts1.278.966204785
20   10240    DSACBAPROD_TS        ***     +ORADATA1/stby_aml/datafile/dsacbaprod_ts.279.971561657
21   5120     misha                ***     +ORADATA1/stby_aml/datafile/misha.280.972576387




backup as copy datafile 7  format '+ORADATA2';

switch datafile 7 to copy;

backup as copy datafile 6  format '+ORADATA2';

switch datafile 6 to copy;

backup as copy datafile 12 format '+ORADATA2';

switch datafile 12 to copy;

backup as copy datafile 17  format '+ORADATA2';

switch datafile 17 to copy;

backup as copy datafile 9  format '+ORADATA2';

switch datafile 9 to copy;


backup as copy datafile 8  format '+ORADATA2';

switch datafile 8  to copy;



+ORADATA1/stby_aml/datafile/vizprod_ts.273.949097161

DELETE DATAFILECOPY '+ORADATA1/stby_aml/datafile/vizprod_ts.273.949097161';  --7
DELETE DATAFILECOPY '+ORADATA1/stby_aml/datafile/misha.262.947279105';  --6
DELETE DATAFILECOPY '+ORADATA1/stby_aml/datafile/misha.268.951429927'; -- 12
DELETE DATAFILECOPY '+ORADATA1/stby_aml/datafile/mishabpm.274.947350467';   17
DELETE DATAFILECOPY '+ORADATA1/stby_aml/datafile/entprod_ts.271.949097163'; --9