|
-
Moving datafiles about & relocating the Arch destination
I've been asked to clean up one of our databases.
It archives the redo to one of the drives on the same server (Its Win NT4 and Ora8.1.5) - which I've never liked. I'm going to have it archive to a network location on a separate server.
I also have to switch/move some of the datafiles around.
So -
Datafiles: I believe its as simple as
(Make backup)
(a) close down Db and restart restricted.
(b) Make OS copy of file to new location.
(c) Rename file-in-orig-location to file-in-new-location (ALTER DATABASE rename 'C:\direc\datafile1.dbf' to 'F:\direc\datafile1.dbf')
(d) open db.
(e) Delete old version using OS command.
Redo logs :
(Make backup)
(a) Close down db.
(b) Move existing Arch redo logs to new location.
(c) Edit init.ora to write redo logs to new location
(d) Start db.
(e) Switch logfile several times to test change.
Is it as simple as I believe? Any pitfalls to watch out for?
Any misconceptions on my part?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|