I face this problem too.
You can go to the console and take the name of the missing sequence then go to pgAdmin and create it then restart odoo. It will work for you
Having different modules in the server where you restored the database can bring up that kind or errors.
You need to copy the addons modules from thee production server to the test server, start the test server, and try to use the restored database.
If it still doesn't work try updating all modules, starting the test server with the option -u all.