How to fix missing RAID1 drive

Question

im having two tables customer and customerType. i want to get the count of VVIP customers from customerType table having booking dates from 1/24/2016 to 1/27/2016. My query:

select count(distinct f.CUSTOMER_ID) as agg from customerType f JOIN 
customer t ON f.CUSTOMERID=t.CUSTOMERID where 
f.type='VVIP' and t.BookingDate BETWEEN 
TO_DATE('10/01/2016','MM/DD/YYYY') AND TO_DATE('10/02/2016','MM/DD/YYYY');

Solution 1

After reading the manual I discovered I had to download the "AMD RAIDXpert" utility from here. Using it I was able to "rebuild" the array by adding the out of sync disk back into the logical device.

Thanks for the tips @moskito-x, I did learn some stuff by following the steps you suggested.

Edit: Updated RaidX download link: http://support.amd.com/en-us/download/chipset?os=Windows%207%20-%2064

Solution 2

Set the automatic rebuild option

Rebuilding can occur

any time one or more members of the RAID 1 mirror set become out of sync, that is, the data on a drive doesn’t match other members of the set. When this occurs, the rebuild process will begin, assuming you selected the automatic rebuild option during the RAID 1 mirror set creation process.

In the RAID management system.

From there you can examine the RAID array, identify which of the two disks is faulty and which is still good. If there is ANY confusion here, do NOT proceed.

But there usually is a process to restore the RAID1 array by simply copying EVERYTHING from the good disk that still works to the other.

Look at the BIOS

Your BIOS port mode must be set to use RAID (not IDE Emulation, or AHCI, etc.). Set it to the same as your first harddisk.

Comments

[RobV]

Ran into a similar problem though caused by something else, verified that the drive marked as offline was actually valid by removing it and plugging it into a different machine via a External SATA dock. Then plugged it back into my machine, downloaded AMD RAIDXpert and was able to rebuild the array fine :D

[Oto Shavadze]

What is BookingDate column type ?

[harish]

BookingDate column type is Date

[Oto Shavadze]

if you need dates from 1/24/2016 to 1/27/2016, then why your query have : BETWEEN TO_DATE('10/01/2016','MM/DD/YYYY') AND TO_DATE('10/02/2016','MM/DD/YYYY')

[harish]

sorry to say that is just sample data..

[Sodved]

I don't think either of the disks is faulty, one wasn't connected when the system/OS turned on. RAID has been working for years, but I made ths mistake and now that disk cannot rejoin the raid. Guess I'll have to manually add it in using a more sophisticated tool than the one that comes after the BIOS screen.

[Sagar Gangwal]

What it's returning?

[harish]

No rows selected

[Sagar Gangwal]

What is the column type of BookingDate ?