Friday, October 11, 2019

Oracle moving datafiles

https://oracle-base.com/articles/misc/renaming-or-moving-oracle-files

use rman


/dba0A/oradata/ORAP/APPS_TS_SUMMARY37.dbf  36

copy datafile 36 TO '/dba0B/oradata/ORAP/APPS_TS_SUMMARY37.dbf'

SQL 'ALTER TABLESPACE APPS_TS_SUMMARY OFFLINE';

SWITCH DATAFILE 36 TO COPY;
RECOVER TABLESPACE APPS_TS_SUMMARY;

SQL 'ALTER TABLESPACE APPS_TS_SUMMARY ONLINE';

HOST 'rm /dba0A/oradata/ORAP/APPS_TS_SUMMARY37.dbf';

No comments:

Post a Comment