Database Administration (MOSC)

MOSC Banner

Oracle DataFile move(online) in Windows

edited Aug 15, 2013 2:15PM in Database Administration (MOSC) 8 commentsAnswered


 Dear Experts, 

   Due to some space constraints, we have to move some database Files from one Drive to another in our database (11.2.0.2 on Windows 2008). 

   I tested the procedure of 

    SQL>> Alter tablespace <tbspce> offline;
    RMAN >> COPY DATAFILE X TO <<FILE_NAME>>;
    RMAN>> switch datafile x to copy;

 Then I tried to delete the dataFile in the old drive but I am not able to delete it, I am getting an error  "THE ACTION CAN'T BE COMPLETED BECAUSE THE FILE IS OPEN IN ORACLESDERVICE "

  Do I have any other options to do this activity in Windows when the DB is open as our customer is not open to downtime due to some business constraints. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center