If i give my pokemon to hold revival herb, will it recover after fainting
No, it works like a Max Revive does. But you can buy them from certain shops, whereas Max Revives you can only find in the world or get through the Pickup ability.
No it only works like revives but be careful you might lose your friendship