Yes. A DRO will remain on your credit report for six years. During this time it's likely that you'll find it more difficult to borrow money. After the six years have passed, the DRO will be removed from your credit report and your credit rating should start to improve.
It's important to look at all the potential pros and cons before you decide whether a DRO is right for you, as well as the other solutions that are available. Speak to an expert advisor to help you decide which debt solution is right for you.