Versions Compared

Old Version 4

changes.mady.by.user Unknown User (fackler)

Saved on

compared with

New Version 5

changes.mady.by.user Unknown User (fackler)

Saved on

Key

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

...

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.

...


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.

...

olympus:/asman/catalogs
olympus:/asman/liveimages

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.

...