Veritas InfoScale™ 7.3 Solutions Guide - Linux
- Section I. Introducing Veritas InfoScale
- Section II. Solutions for Veritas InfoScale products
- Solutions for Veritas InfoScale products
- Solutions for Veritas InfoScale products
- Section III. Improving database performance
- Overview of database accelerators
- Improving database performance with Veritas Concurrent I/O
- Improving database performance with atomic write I/O
- Section IV. Using point-in-time copies
- Understanding point-in-time copy methods
- Backing up and recovering
- Preserving multiple point-in-time copies
- Online database backups
- Backing up on an off-host cluster file system
- Database recovery using Storage Checkpoints
- Backing up and recovering in a NetBackup environment
- Off-host processing
- Creating and refreshing test environments
- Creating point-in-time copies of files
- Section V. Maximizing storage utilization
- Optimizing storage tiering with SmartTier
- Optimizing storage with Flexible Storage Sharing
- Optimizing storage tiering with SmartTier
- Section VI. Migrating data
- Understanding data migration
- Offline migration from LVM to VxVM
- Offline conversion of native file system to VxFS
- Online migration of a native file system to the VxFS file system
- VxFS features not available during online migration
- Migrating storage arrays
- Migrating data between platforms
- Overview of the Cross-Platform Data Sharing (CDS) feature
- CDS disk format and disk groups
- Setting up your system to use Cross-platform Data Sharing (CDS)
- Maintaining your system
- Disk tasks
- Disk group tasks
- Displaying information
- File system considerations
- Specifying the migration target
- Using the fscdsadm command
- Maintaining the list of target operating systems
- Migrating a file system on an ongoing basis
- Converting the byte order of a file system
- Migrating from Oracle ASM to Veritas File System
- Section VII. Just in time availability solution for vSphere
- Section VIII. Veritas InfoScale 4K sector device support solution
- Section IX. Reference
About the migration
Veritas InfoScale supports real-time migration of single instance Oracle databases hosted on Oracle ASM disks to VxFS file systems mounted on VxVM disks.
The migration requires a source system on which the primary database is hosted on Oracle ASM disks and a target that serves as a standby during the migration. That target contains VxVM disks on which the Veritas File System is mounted. The target disks can be on the same host as the primary database or on a different host.
The migration is performed by the script asm2vxfs.pl. The script creates the standby database on the designated VxFS mount point and automates most of the necessary configuration tasks such as preparing the primary and standby databases for migration, configuring the listener on the standby and other configuration changes. You can migrate only one instance of the database at a time.
Applications can continue to access the database while the migration is in progress. Once the primary and standby databases are synchronized, another script switchover.pl switches the role of the primary database to standby and that of the standby database to primary. All applications connected to the primary database must be manually stopped before the transition begins. After the roles of the primary and standby databases are switched, the applications must be started manually. This is the only downtime incurred during the migration process.
The total migration time depends on the following factors:
The amount of redo information (load) being generated on the source system
The amount of system resources available for the new standby database
The size of the primary database
You can run the migration script on the command line using script options or a configuration file.
Figure: Migration with the target storage on the same host as the source illustrates the migration process with the target storage on the same host as the source.
Figure: Migration with the target storage on a host different from the source illustrates the migration process with the target storage on a different host.
Table: Configuration file options lists the configuration file options that are used with the migration script.
Table: Configuration file options
Script options (if you are using the command line interface) | Configuration file parameters (if you are using the configuration file) | Description |
---|---|---|
-o oracle_base | ORACLE_BASE | Path of the Oracle base directory |
-s primary_db | PRIMARY | Name of the source database |
-t standby_db | STANDBY | Name of the target database |
-n source_host | PRIMARYHOST | Host name of the source database |
-m mount_point | DATA_MNT | VxFS mount point |
-r recovery_file_destination | RECOVERY_MNT | Destination path of the recovery file (on top of VxFS) |
-u username | USER | User name of the source database user |
-p password | PASSWORD | Password of the source database user |
-f config_file_name | Not applicable | Not applicable |
-h | Not applicable | Provides information about the asm2vxfs.pl script and its options |
Set the parameter values in the following format:
PARAMETER=value
A sample configuration file is as follows:
ORACLE_BASE=/u01/app/oracle PRIMARY=primarydb STANDBY=standbydb PRIMARYHOST=example.com DATA_MNT=/mount RECOVERY_MNT=/mount/oracle/ USER=user1 PASSWORD=root123