Ashish wrote:Looks like archive log is needed for recovery
Looks like archive log is needed for recovery
when you fire recover database until cancel command ; give filename as path of the redo log file.
If you get an message as recovery completed. Then try to open database with resetlog option.
When I do recovery this 2 were commentedWhy did you disable Oracle's ability to lookup and identify archivelogs ?
#log_archive_dest='mytext I forgot where and replace now'
#log_archive_format = "PRDARCHARC%s_%R.%T"