This steps will surely help guys who are having dev/test environment and also will save lot of time then restoring the whole data from the backups
Preparing the DB for Snapshot
1. Shutdown or Begin Hot backup on the DB you want to snap
Create the Snapshot on the Storage
2. Create the Snapshot on the LUNs related to <VGNAME>
Change the PVID and VGID on the DB Host
3. Unmount the file systems in the VG
4. Deactivate the Original VG
a. vgchange -a n <VGNAME>
5. Change the UUID of the PVs(Disks) in the VG (Make sure to do it on all Disks in the VG)
b. pvchange -u <DISKSinVG>
6. Change the UUID of the Original VG
c. vgchange -u <VGNAME>
7. Rename the original VG
d. vgrename <VGNAME> <VGNAME>_orig
Map the Snapshot to the DB Host
8. Make sure the PVIDs and VGIDs of the Original VG are changed before presenting the Snapshot
LUN to the Host.
9. On the Storage System, export/map the new Snapshot LUN to the DB Host .
Importing the Snapshot VG to the Host
10. Scan for the new Snapshot LUN
e. echo "- - -" > /sys/class/scsi_host/<hostX>/scan
11. Create Multipath devices for Snapshot LUN
f. multipath
12. Scan for the PVs(It shouldn't show any duplicate UUIDs)
a. pvscan
13. Import the Snapshot VG
g. vgimport <VGNAME>
14. Rename the VG on the Snapshot LUN
a. vgrename <VGNAME> <VGNAME>_Snap1
15. Generate a new PVID for Snapshot LUNs
a. pvchange -u <DISKSinSNAPVG>
16. Generate a new VGID for the Snapshot VG
a. vgchange -u <VGNAME>_Snap1
17. Generate a new VGID for Snapshot VG
18. Rename the Original VG to its actual name
b. vgrename <VGNAME>_orig <VGNAME>
19. Activate Original VG as well as Snapshot VG
a. vgchange -a y <VGNAME>
b. vgchange -a y <VGNAME>_Snap1
20. Add FSTAB Entries for the Snapshot VG
21. Mount the file systems in Original VG as well as the Snapshot VG.