Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...