Difference between revisions of "hidden:Database Online Backup"
From Lsdf
| Line 3: | Line 3: | ||
/hpss_src/scripts/db2_fullbackup.ksh -p /db2_backup -t online -b none >>/db2_backup/db2_backup_fullbackup.out |
/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''' |
'''Online DB2 backup on productive core''' |
||
| − | /hpss_src/scripts/db2_fullbackup.ksh -p / |
+ | /hpss_src/scripts/db2_fullbackup.ksh -p / -t online -b none >>/db2_backup1/db2_fullbackup.out 2>&1 |
| + | |||
| + | '''DB2 backup on active core''' |
||
| + | |||
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]] |
||
| + | |||
| + | DB2 backups are saved on /db2_backup1 and a copy is made on /db2_backup2 |
||
| + | DB2 backups are kept on disks 7 days |
||
| + | Every day a TSM backup saves the DB2 backups in TSM |
||
Revision as of 16:01, 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 / -t online -b none >>/db2_backup1/db2_fullbackup.out 2>&1
DB2 backup on active core
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
DB2 backups are saved on /db2_backup1 and a copy is made on /db2_backup2 DB2 backups are kept on disks 7 days Every day a TSM backup saves the DB2 backups in TSM
