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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!