Monday, 18 February 2019

Moving datafile in oracle database 12c OR storage migration


Storage migration or moving data files to the other location got much easier in oracle database 12c.
We can move the data files online without shutting down the database that is one of the feature of oracle database 12c and it is much benefited to DBA's and business as it does not require down time.

Example

ALTER DATABASE MOVE DATAFILE '/proddata2/undo05.dbf' TO '/u03/oradata/undo05.dbf';
ALTER DATABASE MOVE DATAFILE '/proddata4/undo02.dbf' TO '/u03/oradata/undo02.dbf';
ALTER DATABASE MOVE DATAFILE '/proddata4/undo03.dbf' TO '/u03/oradata/undo03.dbf';
ALTER DATABASE MOVE DATAFILE '/proddata4/undo04.dbf' TO '/u03/oradata/undo04.dbf';
ALTER DATABASE MOVE DATAFILE '/proddata4/undo05.dbf' TO '/u03/oradata/undo05.dbf';



ALTER DATABASE MOVE DATAFILE '/proddata4/a_archive01.dbf' TO '/u02/oradata/a_archive01.dbf';
ALTER DATABASE MOVE DATAFILE '/proddata4/a_archive02.dbf' TO '/u02/oradata/a_archive02.dbf';
ALTER DATABASE MOVE DATAFILE '/proddata4/a_archive03.dbf' TO '/u02/oradata/a_archive03.dbf';
ALTER DATABASE MOVE DATAFILE '/proddata4/a_archive04.dbf' TO '/u02/oradata/a_archive04.dbf';


No comments:

Post a Comment