Unanswered: Online redo log issue after ASM to UFS clone
I'm cloning a DB out of ASM and into UFS. I end up with a mounted DB .. and all the datafiles and tempfile and archive logs are on UFS. However when I try to restore the DB and then open it (using resetlogs option) it bombs out:
alter database open resetlogs
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 7814
Session ID: 85 Serial number: 9
When I check the alert log and trace files it's clear that the DB still has it's online redo logs set to an ASM location .. hence the problem.
The db_create_online_log_dest_1,2,3 init.ora parameters have been modified previously so I don't know why the new redo is being written to an ASM disk location.