This section describes the steps to mount the XVC snapshots of the PROD database volumes that you created previously. The steps that are provided in this section apply to both XVC databases, although we use XVC DEV as the database example.
Perform the following steps as the root user to detect the snapshot volumes, configure the multipath, and create the udev rules:
[root#] rescan-scsi-bus.sh
Note: For each device, the WWID is 3<NAA Identifier>. In this example, the WWID of C2_DATA11_DEV is 3514f0c5a4c200090 and the NAA Identifier is 514f0c5a4c200090.
multipath {
wwid 3514f0c5a4c200090
alias C2_DATA11_DEV
}
multipath {
wwid 3514f0c5a4c200091
alias C2_DATA12_DEV
}
multipath {
wwid 3514f0c5a4c200092
alias C2_DATA13_DEV
}
multipath {
wwid 3514f0c5a4c200093
alias C2_DATA14_DEV
}
multipath {
wwid 3514f0c5a4c200094
alias C2_FRA_DEV
}
multipath {
wwid 3514f0c5a4c200095
alias C2_REDO1_DEV
}
multipath {
wwid 3514f0c5a4c200096
alias C2_REDO2_DEV
}
[root#] service multipathd reload
KERNEL=="dm-*", ENV{DM_NAME}=="C2_DATA11_DEV?", OWNER:="dba", GROUP:="dbadmin", MODE="0660"
KERNEL=="dm-*", ENV{DM_NAME}=="C2_DATA12_DEV?", OWNER:="dba", GROUP:="dbadmin", MODE="0660"
KERNEL=="dm-*", ENV{DM_NAME}=="C2_DATA13_DEV?", OWNER:="dba", GROUP:="dbadmin", MODE="0660"
KERNEL=="dm-*", ENV{DM_NAME}=="C2_DATA14_DEV?", OWNER:="dba", GROUP:="dbadmin", MODE="0660"
KERNEL=="dm-*", ENV{DM_NAME}=="C2_FRA_DEV?", OWNER:="dba", GROUP:="dbadmin", MODE="0660"
KERNEL=="dm-*", ENV{DM_NAME}=="C2_REDO1_DEV?", OWNER:="dba", GROUP:="dbadmin", MODE="0660"
KERNEL=="dm-*", ENV{DM_NAME}=="C2_REDO2_DEV?", OWNER:="dba", GROUP:=”dbadmin”, MODE=”0660”
[root#] udevadm trigger 92826588
Depending on the type of DBMS and features implemented, you might have to change the disk-mapping structures, including renaming and remounting. See your vendor documentation for information about how to use snapshot volumes for new database instances.
Depending on the DBMS being deployed, the process of mounting the snapshot volumes and preparing the databases might vary. The following steps are general instructions; consult your specific product documentation for details.
Change the database file names as follows:
Reset/drop/re-create the former redo/transaction logs.
Update the system configuration settings as follows:
The XVC snapshot database is created and running. Change other database initialization parameters as needed.