Versions Compared

Old Version 13

changes.mady.by.user jr_fackler

Saved on

compared with

New Version 14

changes.mady.by.user jr_fackler

Saved on

Key

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

...

  • Open a SQL Developer session.
  • Connect to oracle@k1.ship.iodp.tamu.edu.
  • From the prompt k1$ run the commands shown.
  • Supply the appropriate credentials.

NOTE: For command-line tools--like sqlplus, rman→ if your password has spaces or symbol characters, you must quote the password, e.g.

...

> sqlplus x@yz
Password:"@ s3cr3t fr45e"

PuTTY window

...

[oracle@k1 ~]$ . oraenv
ORACLE_SID = [LIMSJR_HA] ? LIMSJR_HA
cd /backup/LIMSJR/dpdump
sqlplus your-name_dba - Used for Monitoring Space and Logs

...

Example of the above from Windows Terminal (wt.exe),Powershell, PuTTY, Hyperterminal or any other such tool.

Code Block
ssh oracle@k1.ship.iodp.tamu.edu
cd /backup/export
. oraenv
ORACLE_SID = [oracle] ? LIMSJR (or provide SHIPTEST)
sql me@limsjr# If you are conducting DBA privileged activities, use your DBA accountsql my_dba@limsjr


NOTE: For command-line tools--like sql, sqlplus, rman: if your password has spaces or symbol characters, you must quote the password, e.g.

> sqlplus x@yz
Password:"@ s3cr3t fr45e"

Run data cleaning and preening scripts

Connect to Oracle as the TRANSFER (schema owner. Recommend using sqlplus. ) or your DBA account. Doing this work in SQL Developer is often convenient.

  • Make appropriate substitutions for current expeditions.
  • If you are new to the process, read the footnotes

...

  • . Ask

...

  • .

sql>
spool box_processing-349.log
 
set timing on
set serveroutput onset timing on
set serveroutput on
 
call transfer.copy_cleanout_new_tables(); -- (1)
call transfer.box_asman_catalog_delete('EXP346'); -- (2) Last expedition
call transfer.box_lime_audit_delete(###);    -- (4)
call transfer.box_lims_expedition_delete('346');  -- (3) Last expedition
call transfer.box_lims_cleanup();
call transfer.box_lims_defrag(); -- (5)
spool off
exit

...

  -- (3) Last expedition
call transfer.box_lims_cleanup();
call transfer.box_lims_defrag(); -- (5)

Logging the effort quantifies the experience for future improvements. Please place the log file in an expedition folder under rv:\ad\support\###...\box\

  • The box_lims_expedition_delete() step is the longest. Monitoring is required.
  • If material from another expedition was analyzed on this expedition, it may be necessary to delete that content too, e.g. call box_lims_expedition_delete('344(312)');

...