Problem:
A DNN site is running ok in production. If a copy of the database is used to run the DNN site locally (on a local url) the site will continue to redirect to the production url.
Solution:
Update the DNN portal alias to use the new local url. Update the HTTPAlias field in the PortalAlias table and restart the website (e.g. touch the web.config).