...
In the unlikely event you have to restore from a logical backup, because you can’t use the continuous protection rollback, and all the dumps managed by Heroku are somehow unavailable:
Download the database file you want
heroku pg:psql --app scihist-digicoll-production < ~/Desktop/digcol_backup.sql
...