Database Info/oracle backup scripts details

From Informatics

Jump to: navigation, search

The following environment variables should be set in order for the script to work. I have included them in the export_tablespaces.sh script. 

ORACLE_BASE=/opt/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11gR2
ORACLE_SID=HTSDB
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

hts-db.c2b2.columbia.edu

  • PI: Charles Karan
  • Contact: Ronald Realubit
  • Oracle version: 11.2.0.1.0
  • Backup program: expdp
  • Backup location: /data/htsdb_files/datapump
  • Backup script: /data/scripts/export_tablespaces.sh
  • Oracle user running script: mhonig
  • Oracle user password: elfst0ne
  • OS user executing script: oracle
  • cron details: 
32 17 * * * /bin/sh /data/scripts/export_tablespaces.sh
00 02 * * * /bin/find /data/htsdb_files/datapump/ -mtime +30 -exec rm {} \;
00 01 * * 6 /bin/sh /data/scripts/rman_level_0.sh
47 12 * * * /bin/sh /data/scripts/rman_level_1.sh
Retrieved from "http://wiki.c2b2.columbia.edu/informatics/index.php/Database_Info/oracle_backup_scripts_details"
Personal tools