Page History

...

sql your-name_dba
Password:

sql>
alter tablespace labware read write;
exit

[oracle]$

Test the export file

Carefully read Read the limsjr_full-###-export.log in k1:/backup/export.

• Are there any errors? No is good. If presenterrors, find cause, maybe re-rrunrun.
• Review the number of samples for LIMS.SAMPLE, LIMS.TEST, LIMS.RESULT, OPS.RIS_DATA.

Log into the SHIPTEST instance. Run these commands to confirm ability to restore content from the file generated.

ssh oracle@k1oracle@k2.ship.iodp.tamu.edu

. oraenv
ORACLE_SID = [oracle] ? SHIPTEST
[oracle]$

time impdp your-nameyou_dba directory=dmpdir logfile=exp###-test-export.log dumpfile=limsjr_full-###.dmpdp tables=lims.sample, lims.test remap_schema=lims:transfer content=data_onlyremap_table=lims.sample:xxx_sample,lims.test:xxx_test exclude=trigger table_exists_action=truncatereplace

time impdp your-nameyou_dba directory=dmpdir logfile=exp###-test-export.log dumpfile=limsjr_full-###.dmpdp schemas=geodp### remap_schema=geodp###:geodp###_review 

Use SQL Developer to review the content of the SHIPTEST TRANSFER.NEWXXX_SAMPLE table, XXX_TEST tables. Repeat for the restored GEODP###_REVIEW schema. Do not cleanup. Leave it for the oncoming crew to review.

...

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

The MCS pick up the full export from  oemjr:/backup/export.

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

Take a copy of the export file

...