Undo_management=Manual

[Former Member]

Hi

We are performing system refresh from PRD system to another TST system.

Our PRD system currently running on oracle 9i ECC 5.0 and HP-UX platform..we have installed

new ECC 5.0 system with oracle 9i as TST system.

But our PRD system is having UNDO_MANAGEMENT=MANUAL and ROLLBACK_SEGMENTS=PRS_1 to PRS_15

and tablespace used is PSAPROLL.

Our newly created TST system is having UNDO_MANAGEMENT=AUTO AND UNDO_TABLESPACE=PSAPUNDO.

When we are trying to restore database and create controlfile ( Create controlfile SET database ...and so on) perform recovery ( recover datasabse using backu...until cancel)

...But when we give Alter database open resetlogs ... it terminate the Oracle instance and

reason in alertlog is unable to find PSAPUNDO tablespace.

currently We do not want to make any changes in PRD system ... do we need to switch to

manual Undomanagement on TST system first and then perform system copy..

Or simply change parameters UNDO_MANAGEMENT=MANUAL AND UNDO_TABLESPACE=PSAPROLL will

do the trick.

Please let me know at earliest currently my TST system is down and oracle instance terminated.

Edited by: ganesh rr on Oct 2, 2008 6:21 AM

Edited by: ganesh rr on Oct 2, 2008 6:30 AM

Subject modified by moderator

Read the "Rules of Engagement"

Edited by: Juan Reyes on Oct 3, 2008 10:59 AM

[former_member204746]

simply change parameters UNDO_MANAGEMENT=MANUAL AND UNDO_TABLESPACE=PSAPROLL

[Former Member]

Thanks to all,

I have done changes as per note 600141 and my target DB is up and running now.