This content has been marked as final. Show 5 replies
is your PROD DB up and running as of now ?
This would save you all the duplication time and will do the database open for you. Try this out , step by step here :
If you have a cold backup (database shutdown properly) without the redo logs, change this :
CREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS NOARCHIVELOG
You have to change the NORESETLOGS to RESETLOGS for Oracle to recreate the online redo logs.
CREATE CONTROLFILE REUSE DATABASE "XE" RESETLOGS NOARCHIVELOG
Hemant K Chitale