provision survives for a unlimited amount of time ?
Yes, that's what it means, unless other portions of the contract support a reasonable interpretation that the validity thereof is time-limited.
Is there a legal limit to this ?
Under U.S. contract law, there is no limit for a business context. I highly doubt that other countries applying similar principles of contract law (for instance, some or perhaps many European countries) would enact a time limit for business contracts.
Isn't it abusive ? If yes, can this be legally enforced ?
Being abusive and/or enforceable largely depends on what exactly is agreed upon. The more unreasonable the clause as applied to that particular [legal and factual] context, the unlikelier it is for the clause to withstand judicial review.
Generally speaking, the fact that a person knowingly and willfully consented to a clause in a contract makes it very hard to strike or reverse that clause in court. Therefore, it is extremely important not to sign a contract that contains clauses which since its inception (that is, inception of the contract) you deem abusive.