This content has been marked as final. Show 5 replies
have you stopped your database before taking backup?
what error you are getting while running create controlfile command....
for xe i think we don't have option to install only software....
yes it was shut properly .. and it wasnt able to find the redo log file..that was the message..i recived
seems it is checking for redo log file..but it is not present..since redo log was never backed up
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
Thanks and done.