Migrating Oracle databases from Oracle ASM to VxFS

You can perform the migration in one of the following ways:

Perform the following steps to migrate Oracle database instances from Oracle ASM disks to VxFS.

To migrate Oracle databases from Oracle ASM to VxFS

  1. Run the migration script asm2vxfs.pl on the target system in one of the following ways:
    • Using script options on the command line:

      # asm2vxfs.pl -o oracle_base -s source_db -t target_db \
      -n source_host  -m mount_point -r recovery_file_destination  \
      -u username -p password

      For example:

      # asm2vxfs.pl -o /u01/app/oracle -s primarydb -t standbydb \
      -n example.com  -m /mount -r /mount/oracle/  \
      -u user1 -p root123

      See Script and configuration file options.

    • Using the configuration file:

      # asm2vxfs.pl -f config_file_name

      For example:

      # asm2vxfs.pl -f /root/config_file

      See Script and configuration file options.

      See Sample configuration file.

  2. Stop all the applications connected to the source database.
  3. Run the switchover.pl script on the target system in one of the following ways. The script switches the role of the primary database to standby and that of the standby database to primary.

    Note:

    Downtime begins when the switch over operation starts.

    • Using script options on the command line:

      # switchover.pl -s source_db -t target_db -n source_host  \
      -u username -p password

      For example:

      # switchover.pl -s primarydb -t standbydb -n example.com  \
      -u user1 -p root123
    • Using the configuration file:

      # switchover.pl -f config_file_name

      For example:

      # switchover.pl -f /root/config_file
  4. After the switchover.pl script completes, you will be prompted to unlink the old primary database.
    Do you want to unlink the original primary? <y/n>

    Note:

    If you enter y, all connections to the old primary database are unlinked and reconfigured to use the new primary database.

  5. Connect the applications with the new primary database on VxFS.

    Note:

    Downtime ends here.