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