Originally posted by sanga Can we Hot Swap a drive when the Database is UP and running?
Database is in Archivelog mode
If so how can we hot swap a drive which is mirrored what steps we need to follow
On a protected device, sure. If your device is RAID 1, 0+1, or 5, you can replace disks on the fly with no problem. The steps vary according to your OS and volume manager software, but in general they are:
1. pull out old disk
2. put in new disk
3. tell your volume manager to resync the disk.
If you have hot spares defined, things will be a little different because you essentially have to do the whole process twice.
One of our unix Guy Hot swapped a drive and we started experiencing problems like corruption in the database.
Iam sure the disks are mirrored, but one of the database had datafiles on the same volumne and was down and was not affected, but all the datafiles, control files got corrupted and we had to perform PIT database recovery on all databases on that volume, except for the one in which was down.
Do we need to take any precaution in future when we hot swap a drive at the database end so that is does not occur again