Quote Originally Posted by gojack
after upgrade of standby ( software only ) to 9i, on production site, we are
planning to drop rollback segments and rollback tablespace and implement the an undo tablespace and let oracle manage the undo.

question: when rollback segments are offlined and dropped on production, how to make that happen on the standby.

will the archive log contain the instructions and when applied remove rollbacks from data dictionary ( and update controlfile ) ?

will i have to remove the rollback logs manally on standby ?

I know data guard is a better solution for standby, but we aren't there yet.
How big is your DB?
How much downtime can you afford?

If the DB is small enough and you can afford some amount of downtime, best way is after you finish the UNDO thing on the primary instance. Take a cold backup and go for Physical Standby configuration using standby controlfile in oracle 9i.

Put it in managed recovery and don't worry about manual shipping of Archive logs.