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