...
5. Conduct EOX database backup
Make the database read only
Run from PuTTY, Windows Terminal, Powershell, Hyperterminal.
You can run this step from SQL Developer too, but you'll need the command-line at the ODA for the data pump export command.
Code Block |
---|
ssh oracle@k1.ship.iodp.tamu.edu
. oraenv
ORACLE_SID = [oracle] ? LIMSJR
sql your-name_dba
sql>
alter tablespace labware read only;
exit
[oracle]$ |
Export the database content
Code Block |
---|
cd /backup/export
ls -l
time expdp your-name_dba directory=dmpdir full=y logfile=limsjr_full-###-export.log dumpfile=limsjr_full-###.dmpdp |
Make the database read-write again
Code Block |
---|
sql your-name_dba
Password:
sql>
alter tablespace labware read write;
exit
[oracle]$ |
Test the export file
Carefully read the limsjr_full-###-export.log
in k1:/backup/export
.
- Are there any errors? No is good. If present, find cause, maybe re-rrun.
- Review the number of samples for LIMS.SAMPLE, LIMS.TEST, LIMS.RESULT, OPS.RIS_DATA.
L
Notify everyone that its done
Post the export log file on Slack jrso-developer. Note the size of the export file. We will not zip it, nor send it over the wire.
Email it to
- MCS - jr_mcs@ship.iodp.tamu.edu
- IT_OPS - it_ops@iodp.tamu.edu
- Data Librarian - database@iodp.tamu.edu
- programmers - programmers@iodp.tamu.edu
- DBAs - sunil@rajaconsultancy.com, murli@rajaconsultancy.com
Note the size of the file and its location--if we're putting it in the right place, there's no need for the MCS to move it.
Take a copy of the export file
Login into the Oracle account at the ODA using WinSCP. Bring down a copy of the export file and its log to
- your laptop--or other transfer device; and
- stage a copy in \\novarupta\vol3\dml\oracle-data\
for future local reference (or until we have to clean/preen for space.
6. Provide courier services
...
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
...
At the SQL>
prompt, run the last command.
Stop. Leave this window open for use below.
...