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