The outgoing programmer is responsible for all of the end-of-expedition (EOX) activities.

The goal is to ensure a good copy of the data gets back to HQ.

Please read this entire document and its companion. Expect to take 3 to 4 hours to complete this exercise. (I keep saying this only takes 15 minutes. But that really is just the individual database dump processes.) Do not hurry. If you are "fried"--work together. 

0. Readiness assessment.

Confirm with science party and technical staff before proceeding.

...

If no, obtain estimates when the data collection will be done. Schedule accordingly.   

1. Notify everyone. Database snapshot in progress.

• Notify jr_developer and the shipboard technical staff that the EOX database backup is in progress.
• The database is available for reports, but content cannot be changed while this activity is in progress.

2. Make the database read only.

Connect to the BUILD box. Execute all of the following steps from that system.


Run PuTTY.
Connect to oracle@k1.ship.iodp.tamu.edu
From the prompt run this command, supply the oracle user's credentials for k1

...

Technical note. This command prevents write access to any table content that resides in the storage facility under the "labware" table space. In our database implementation, this happens to be all tables owned by the LIMS schema. Use of Drill Report ("ops" schema) is not affected. Aspects of DescLogik software configuration are also still open to maintenance, though use of DescLogik itself is locked out by this change.

3. Full snapshot as oracle@k1.

Run another PuTTY session.
Connect to oracle@k1.ship.iodp.tamu.edu
From the prompt run these commands--change the expedition and yourname  (will require logging in as a DBA User see PWSAFE) - - - JON Put Your Password in "QUOTES"

...

Statistics. Typical durations for the last step from previous expeditions. 344S: 16 min 23 sec. 345: 13 min 54 sec. 346: 18 min 46 sec. 341S: 11 min 42 sec. 351: 12 min 9 sec; 360: 16 min 57 sec; 363: 3 min 21 sec; 367: 3 min 38 sec.

ODA for 3 expeditions of data (11.1 GiB): 4 min 17 sec.
396: 6 min 54 sec

...

4. Restore database read/write capability.

From the prompt [oracle@k1 ~]$

...

Stop. Leave this window open for use below.

...

5. Compress the exports for transport. Cleanup. 

From the prompt [oracle@k1 ~]$
run these commands

...

Exp 396: we had trouble initially because we ran out of disk space.  This was apparently due to my creating the /backup/LIMSJR/dpdump folder under the Oracle account.  This broke some kind of link-up that gives the backup folder lots of additional drive space.  Don't do that.

Need to test DMPDP.
Need to post log results.

...

6. Notify everyone. Database snapshot process is complete.

 Notify jr_developer and expedition technical staff that the process is done.

Speak with the MCS. They will pick up the data from here.

The MCS will copy the files over to oem.ship.iodp.tamu.edupick up the full export from  oemjr:/backup/export--one of several staging areas for the EOX tape run.

Inquire with the MCS. Ensure the (above) database content and the (below) ASMAN content are being taken to media for transport to HQ.

...