Difference between revisions of "hidden:Database Online Backup"

From Lsdf
Line 6: Line 6:
 
On the active core server runs every hour a cron job which takes an online DB2 backup:
 
On the active core server runs every hour a cron job which takes an online DB2 backup:
 
0 */1 * * * if [ `hostname` == "hpsscr" ] ; then /hpss_src/scripts/db2_fullbackup.ksh -p /db2_backup1 -s /db2_backup2 -t online -b none >> /db2_backup1/db2_fullbackup.out 2>&1 ; fi
 
0 */1 * * * if [ `hostname` == "hpsscr" ] ; then /hpss_src/scripts/db2_fullbackup.ksh -p /db2_backup1 -s /db2_backup2 -t online -b none >> /db2_backup1/db2_fullbackup.out 2>&1 ; fi
For a DB2 restore see
+
For a DB2 restore see:
 
[[hidden:Database Restore exercised on Test Core|Database Restore exercised on Test Core]]
 
[[hidden:Database Restore exercised on Test Core|Database Restore exercised on Test Core]]

Revision as of 12:45, 13 July 2016

A database online backup can be made during normal HPSS operation
Online backup on test core
  /hpss_src/scripts/db2_fullbackup.ksh -p /db2_backup -t online -b none >>/db2_backup/db2_backup_fullbackup.out
Online DB2 backup on productive core
   /hpss_src/scripts/db2_fullbackup.ksh -p /db2_backup1 -t online -b none >>/db2_backup1/db2_fullbackup.out 2>&1
On the active core server runs every hour a cron job which takes an online DB2 backup:
0 */1 * * * if [ `hostname` == "hpsscr" ] ; then /hpss_src/scripts/db2_fullbackup.ksh -p /db2_backup1 -s /db2_backup2 -t online -b none >> /db2_backup1/db2_fullbackup.out 2>&1 ; fi
For a DB2 restore see:
Database Restore exercised on Test Core