Versions Compared

Key

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

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

...

NOTE: While performing the EOX for expedition 384, it was discovered that the path represented by "data_pump_dir" did not exist.  You can discover what the data_pump_dir is supposed to be using this query (logged in as your DBA account):

select * from dba_directories;

The results have a lot of stuff that's not useful, but the DATA_PUMP_DIR should be there.  Currently it is /backup/LIMSJR/dpdump.  Note that "backup" is singular (it used to be plural) and there is apparently some desire to change this, so keep that in mind.  If you find that the folder does not exist, the command in this step will fail and you may need to get an MCS or a DBA on shore to help create it.

...

create directory data_pump_dir as '/backup/LIMSJR/dpdumpexport';
grant read, write on directory data_pump_dir to transfer, system;

...

. oraenv
ORACLE_SID = [LIMSJR] ? LIMSJR
# Note that the folder you're cd-ing to here should be the "data_pump_dir" referenced in the next command.  This comes from the dba_directories table (see note above).
cd /backup/LIMSJR/dpdump
time expdp YOUR_DBA_ACCOUNT directory=data_pump_dir dmpdir full=y logfile=limsjr_full-YOUR_EXP_NUMBER-export.log dumpfile=limsjr_full-YOUR_EXP_NUMBER-YOUR_INITIALS.dmpdp

...

Need to test DMPDP.
Need to post log results.

11. Notify everyone. Database snapshot process is complete.

...

k1.ship.iodp.tamu.edu:/backup/LIMSJR/dpdump
    limsjr*.bz2
    limsjr*.log


The MCS will copy the files over to oem.ship.iodp.tamu.edu:/media/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.

12. Send the transfer content home. 

NOTE:   

Please transfer only the limjr_transfer file online. The full file can come on tape.

Rakesh

This is now routine. The Database Group expects this to occur. This method makes the data available a week earlier than can be achieved transporting tapes.

...

  • Hand the files over to the MCS, requesting that they be transferred to \\NORTH\FTP\FromShip\EOX\  << Preferred.

...