Database Administration (MOSC)

MOSC Banner

Change bloksize on a production 1.5Tb database in less than 45 mn

edited Nov 12, 2008 2:58AM in Database Administration (MOSC) 7 commentsAnswered
Hi,  
We have a production database on HP Unix with a 4 Kb block size. The database size is about 1.5 Tb with big tables. We need to switch to a 8 Kb block size (data and system) and we only have a 45 minutes time window to do it.

We were thinking that it would be a good idea, using a logical standby database with Data Guard. We will be playing a database redefinition on the standby and then make a switchover which should be almost immediate.

But it seems that Data Guard is overprotective and does not allow us to do that.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center