Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Unanswered: Online redo log issue after ASM to UFS clone

    Hi Guys.

    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.

    Any ideas?

  2. #2
    Join Date
    Sep 2009
    Managed to get around it by using the 'alter database rename file' cmd on each redo log. Not sure if it's the only or best way.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts