If you want to override your current database with a backup of it, you need to:

0. create a backup of your database via the manager URL: http://localhost:8069/database/manager or whatever domain and port number you use for Odoo.

1. delete the current database using the manager

2. restore the database using the backup, and giving it the same name

Note: Odoo won't allow databases with the same name even if a different SQL ROLE owns it as this is a rule in PostgreSQL. Two databases can not have the same name.

In such cases you can use recovery software, for example Disk Drill at [https://www.cleverfiles.com/mac-mini-hard-drive-recovery.html]. I always use it when I need to recover any deleted files. Hope it will help you too.

Use This database is copy.then you can restore the backup DB as a copy of original one.then you can use that to your testing things and if it is success, you can do same thing for your original DB and delete the backup DB. that's the best way to solve your problems.