I'm trying to clone my production db ona Sun box, NOT using RMAN.
No problems with creating controlfile and dbf copies etc.
I edit the controlfile create script and try to bring up the 'new' database and have a load of errors trying to recover the logfiles, even though startup without recovery.
Would I be right in thinking that the UNDO tablespace is meesing me up, so if I were to :
- create a rollback segment in the production database prior to shutdown and dbf copy
- edit controfile script to show UNDO_MANAGEMENT=MANUAL and ROLLBACK_SEGMENTS='rbs1'
- copy files
- bring up 'new' db with RESETLOGS
it may work?