Recreating UNDO tablespace on primary
edited Feb 10, 2010 7:53AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 2 commentsAnswered
Hi All,
We have a 4 node RAC primary database with a 2 node RAC physical standby, all running 10.2.0.2.
The undo tablespaces have grown on the primary, but only very little of it is being used currently.
We would like to reclaim the disk space that is being wasted.
So we are thinking of dropping the current UNDO tablespaces and creating new ones with a smaller size and reassigning it to the instances.
I think the following should work, but we don't have any test environment with a standby database to test the process.
1) Create 4 new undo tablespaces on primary with desired size (should get propagated to standby as well?)
We have a 4 node RAC primary database with a 2 node RAC physical standby, all running 10.2.0.2.
The undo tablespaces have grown on the primary, but only very little of it is being used currently.
We would like to reclaim the disk space that is being wasted.
So we are thinking of dropping the current UNDO tablespaces and creating new ones with a smaller size and reassigning it to the instances.
I think the following should work, but we don't have any test environment with a standby database to test the process.
1) Create 4 new undo tablespaces on primary with desired size (should get propagated to standby as well?)
0