Home » Server Options » Replication » Can I relocate .dbf and .ora files in 9i?
icon9.gif  Can I relocate .dbf and .ora files in 9i? [message #115628] Wed, 13 April 2005 05:00 Go to next message
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 Go to previous message
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
Previous Topic: Implementing (basic)Replication where server IP is constant but clients IP is Not constant
Next Topic: Advantages and disadvantages to Multi-Master versus Master-Standby
Goto Forum:
  


Current Time: Thu Mar 28 15:54:53 CDT 2024