SECOND AMENDED AND RESTATED AGREEMENT OF LIMITED PARTNERSHIP OF ENCORE ENERGY PARTNERS LP