 Can I relocate .dbf and .ora files in 9i? [message #115628] |
Wed, 13 April 2005 05:00  |
shaileshrparmar
Messages: 1
Registered: March 2005
|
Junior Member |
|
|
Hi to all,
my .DBF files and .ORA files are stored at H: in Server and the Oracle is also Installed on this H: drive,as the data is getting accummulated everyday it is about to get full.
So How can I locate them at other location without disturbing exisitng so that all data can made available to end users.
Please guide me for this solution
Shailesh
|
|
|
|
| Re: Can I relocate .dbf and .ora files in 9i? [message #122163 is a reply to message #115628] |
Fri, 03 June 2005 08:41  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi,
my best solution will be to relocate them inside Oracle with
1. If the database is up, shut it down.
2. Copy the datafile to the new name/location at operating
system level.
3. Mount the database.
SVRMGRL> STARTUP MOUNT
This command will read the control file but will not mount
the datafiles.
4. Rename the file inside Oracle.
SVRMGR> ALTER DATABASE RENAME FILE
'/FULL_PATH_OF_OLD_LOCATION/AND_DATAFILE_NAME.DBF' TO '/FULL_PATH_OF_NEW_LOCATION/AND_DATAFILE_NAME.DBF';
Do this for all the datafiles that were renamed or moved
at the operating system level.
5. Open the database.
SVRMGR> ALTER DATABASE OPEN;
6. Query v$dbfile to confirm that the changes made were ok.
SVRMGR> SELECT * FROM V$DBFILE;
7. Remove the datafile(s) from the old location at the
operating system level.
Its also possible "online" but I tzhought this will be the best solution to make it "offline"
For more informations see Note:115424.1 on Oracles Metalink
Uwe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
