-
Relocate Undo and Redo data files
can anybody tell me how can i relocate the Undo tablespace data file and the Redo's datafiles to diferent disks of a installed Oracle 9i database running on Redhat 9.0?
thanks for the help
Gustavo Villaran
-
first of all read the manual for moving a file, quite asy to find
all you need to do is take the tablespace offline or startup mount move the os copy, move it in the database and restart.
-
well, first if u dont know yet, in 9i Undo Tablespace cant be offline.
that's why i ask this...
thanks anyway
Gustavo Villaran
-
in that case startup nomount or mount can't remember which one and move the datafile that way
-
i have try that too.
and Oracle accepts the alter command, but when i startup it points to the original position again.
dont know why, im trying to search in tahiti but cant find anything yet.
Gustavo Villaran
-
1. Create a new UNDO_TABLESPACE
2. Type "ALTER SYSTEM SET UNDO_TABLESPACE=NEW TABLESPACE". If using pfile, change the parameter on init.ora. If using spfile add the clause SCOPE=BOTH
All the active transactions will remain using the actual tablespace, but the new ones will be addressed to the new undo tablespace. Once the active transactions finish, you can put your old tablespace offline and then drop it, until then it will be "PENDING OFFLINE".
About the redo logs, just create new groups and drop the old ones. Remember you must have at least 2 groups at any given time, so you'll need to "add a new one/remove an old one" and so on.
An ounce of action is worth a ton of theory.
—Friedrich Engels
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
|