---------------------


sqlplus /as sysdba

alter tablespace INDEX16 offline;

!mv /data1/TTS/oracle/app/oracle/oradata/TTS/index16*.dbf /data2/TTS/oracle/app/oracle/oradata/TTS/

alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16a.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16a.dbf';

alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16b.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16b.dbf';

alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16c.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16c.dbf';

alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16d.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16d.dbf';

alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16e.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16e.dbf';

alter tablespace INDEX16 rename datafile '/data1/TTS/oracle/app/oracle/oradata/TTS/index16f.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16f.dbf';

alter tablespace INDEX16 online;

Moving Datafiles while the Instance is Mounted

sqlplus "/ as sysdba"

shutdown immediate

!mv /data1/TTS/oracle/app/oracle/oradata/TTS/index16* /data2/TTS/oracle/app/oracle/oradata/TTS/

startup mount

alter database rename file '/data1/TTS/oracle/app/oracle/oradata/TTS/index16a.dbf' to '/data2/TTS/oracle/app/oracle/oradata/TTS/index16a.dbf';

.... (and for the other datafiles)

Do not disconnect after this step. Stay logged in and proceed to open the database!

alter database open;

One Response so far.

  1. ERP says:


    Hi,

    your article so informative and i have cleared all of my doubts.
    your way of explanation is awesome thank you for sharing useful information.

    regards,
    Oracle Fusion HCM Training

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -