...
| Code Block |
|---|
-- LIMSHQ as your DBA account, from within SQL dp export -directory dmpdir -dumpfile to###-geodcat.dmpdp -logfile to###-geodcat.log -schemas geodcat -- pick up the output file from s1:/backup/export/ -- To restore on ship dp export -directory dmpdir -dumpfile geodcat-yyyymmdd.dmpdp -logfile geodcat-yyyymmdd.log -schemas geodcat -- Backup up the current state drop user geodcat cascade constraints;; -- Delete the current schema dp import -directory dmpdir -dumpfile to###-geodcat.dmpdp -logfile to###-geodcat-import.log -schemas geodcat -- Restore from copy transported |
...
- Be sure to catalog the new schema password in the shipboard safe.
- Spotcheck newly created or imported schemas to confirm operability and access to existing data: Do templates load? Can new samples be added to DataCapture working sets?
2/13/2024: Removed constraints from the end of the drop user geodcat command. Was causing the script to fail. Left it on for the project schema because I did not have to run that command.
14. Honor moratorium.
Assist other technical staff with expedition preparation.
...