No, just replace the sensor and erase the code. It's best to stick with genuine Nissan or OE sensors, like Denso, Hitachi or NTK; I've run into several aftermarket sensors that were bad right out of the box, so, maybe you got a bad part?
The original Nissan sensors were the plastic type, but they later updated them to the metal type like you now have. Genuine Nissan, NTK, Denso and Hitachi are all good brands to go with as they all make OE sensors for Nissan.
Nissan Forums is the go to place to talk about your favorite Nissan model, including the Rogue, Maxima, Altima and even sports cars like the 370Z and 200SX.