Database Administration (MOSC)

MOSC Banner

move datafile to new location

edited Aug 15, 2013 2:55AM in Database Administration (MOSC) 2 commentsAnswered
 hi, 
need to move dataflies to new location.

Have studied 115424.1 and is find with me.

QUESTIONS:
1.
I am taking RMAN into consideration. How do RMAN recognise the new location to backup my files? 
Does the below steps from 115.424.1 sufficient to tell RMAN the new location?

--7. Once the tablespace is offline you will need to rename the datafile(s) to the new location. 
-- This updates the entry for the datafile(s) in the controlfile. 

ALTER DATABASE RENAME FILE '/FULL_PATH_OF_OLD_LOCATION/AND_DATAFILE_NAME.DBF' TO '/FULL_PATH_OF_NEW_LOCATION/AND_DATAFILE_NAME.DBF'; 

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