...
- Stop the OpenSpecimen service.
- Connect to Oracle using sqlplus / as sysdba.
- Create a user with a new name using create user [new_os] identified by [new password].
- Grant proper privileges to the newly created user [new_os] to connect to this new database.
- Open command prompt/terminal
- Restore the backup using impdp <username>/<password> DIRECTORY=<DUMP_DIR> DUMPFILE=<older_back_file_name.sql> REMAP_SCHEMA=<from_user>:<to_user> logfile=<logfile.log> transform=oid:n
- Restore the os-data folder to the same date as of the database backup.
- Update the new database name in tomcat/conf/context.xml.
- Start the OpenSpecimen service.
- Once everything is fine, please update the backup script to point to the newly created database.