Difference between revisions of "Database offline backup on hpss test core"

From Lsdf
 
(9 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
**hpssadm> server shutdown -all
  
**hpssadm> server shutdown -all
 
**hpssadm> server list -all
  
**hpssadm> server list -all
  +
ID Status Type Subtype Subsystem Op State Server Name Host Execute Host UUID
−  
−
ID Status Type Subtype Subsystem Op State Server Name Host Execute Host UUID
+
0 Connected SSMSM Enabled SSM System Manager hpsstcr03.lsdf.kit.edu hpsstcr03 264216ec-0752-11e4-9b61-40f2e9724ad2
−
0 Connected SSMSM Enabled SSM System Manager hpsstcr03.lsdf.kit.edu hpsstcr03 264216ec-0752-11e4-9b61-40f2e9724ad2
+
1 Connected SUD Enabled Startup Daemon (hpsstcr03) hpsstcr03.lsdf.kit.edu hpsstcr03 58cea534-0767-11e4-8c5a-40f2e9724ad2
−
1 Connected SUD Enabled Startup Daemon (hpsstcr03) hpsstcr03.lsdf.kit.edu hpsstcr03 58cea534-0767-11e4-8c5a-40f2e9724ad2
 
−  
 
**hpssadm> quit
  
**hpssadm> quit
 
*1.2 Stop startup daemon
  
*1.2 Stop startup daemon
Line 18: Line 16:
   
 
*2.1. [root@hpsstcr03 scripts]# /opt/hpss/bin/rc.hpss stop
  
*2.1. [root@hpsstcr03 scripts]# /opt/hpss/bin/rc.hpss stop
−
**SQL1064N DB2STOP processing was successful.
 +
SQL1064N DB2STOP processing was successful.
   
 
3.'''Data base offline backup'''
  
3.'''Data base offline backup'''
Line 26: Line 24:
 
**. /var/hpss/hpssdb/sqllib/db2profile
  
**. /var/hpss/hpssdb/sqllib/db2profile
 
**db2start
  
**db2start
−
**SQL1063N DB2START processing was successful.
 +
SQL1063N DB2START processing was successful.
−
*3.2 Take an offline backup for all databases
+
*3.2 Take an offline backup for all databases(as hpssdb user)
 
**3.2.1 Take an offline backup for hcfg data base
  
**3.2.1 Take an offline backup for hcfg data base
 
***-bash-4.1$ db2 backup db hcfg to /db2_backup/offline/hcfg compress
  
***-bash-4.1$ db2 backup db hcfg to /db2_backup/offline/hcfg compress
−
***Backup successful. The timestamp for this backup image is : 20160620134530
 +
Backup successful. The timestamp for this backup image is : 20160620134530
 
**3.2.1 take an offline backup for hsubsys1
  
**3.2.1 take an offline backup for hsubsys1
 
***db2 backup db hsubsys1 to /db2_backup/offline/hsubsys1 compress
  
***db2 backup db hsubsys1 to /db2_backup/offline/hsubsys1 compress
−
***Backup successful. The timestamp for this backup image is : 20160620134852
 +
Backup successful. The timestamp for this backup image is : 20160620134852
 
**3.2.3 on the productive system do it for ghi datbase too
  
**3.2.3 on the productive system do it for ghi datbase too
−
**3.2.4 exit
+
**3.2.4 exit #(exit from hpssdb user shell)
−
***exit from hpssdb user shell
  
   
 
4. '''Offline backups on hpss test system:'''
  
4. '''Offline backups on hpss test system:'''

Latest revision as of 17:04, 20 June 2016

1.Stop hpss

  • 1.1 [root@hpsstcr03 scripts]# /opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab
    • hpssadm> server shutdown -all
    • hpssadm> server list -all
 ID  Status     Type   Subtype  Subsystem  Op State  Server Name                 Host                    Execute Host  UUID                                  
  0  Connected  SSMSM                      Enabled   SSM System Manager          hpsstcr03.lsdf.kit.edu  hpsstcr03     264216ec-0752-11e4-9b61-40f2e9724ad2  
  1  Connected  SUD                        Enabled   Startup Daemon (hpsstcr03)  hpsstcr03.lsdf.kit.edu  hpsstcr03     58cea534-0767-11e4-8c5a-40f2e9724ad2
    • hpssadm> quit
  • 1.2 Stop startup daemon
    • root@hpsstcr03 scripts]# /opt/hpss/bin/rc.hpss -d stop
  • 1.3 Stop system manager
    • root@hpsstcr03 scripts]# /opt/hpss/bin/rc.hpss -m stop

2.Stop the database

  • 2.1. [root@hpsstcr03 scripts]# /opt/hpss/bin/rc.hpss stop
SQL1064N  DB2STOP processing was successful.

3.Data base offline backup

  • 3.1 Start only the data base (it is necessary to stop and restart it in order to be sure all connections are closed. There is possible to use "db2 quiesce instance" instead)
    • su - hpssdb
    • . /var/hpss/hpssdb/sqllib/db2profile
    • db2start
SQL1063N  DB2START processing was successful.
  • 3.2 Take an offline backup for all databases(as hpssdb user)
    • 3.2.1 Take an offline backup for hcfg data base
      • -bash-4.1$ db2 backup db hcfg to /db2_backup/offline/hcfg compress
Backup successful. The timestamp for this backup image is : 20160620134530
    • 3.2.1 take an offline backup for hsubsys1
      • db2 backup db hsubsys1 to /db2_backup/offline/hsubsys1 compress
Backup successful. The timestamp for this backup image is : 20160620134852
    • 3.2.3 on the productive system do it for ghi datbase too
    • 3.2.4 exit #(exit from hpssdb user shell)

4. Offline backups on hpss test system:

  • 4.1 Offline backup of 7.4.3p3 before database restore on 16.06.2016
    • /db2_backup/offline/hcfg/HCFG.0.hpssdb.DBPART000.20160616105201.001
    • /db2_backup/offline/hsubsys1/HSUBSYS1.0.hpssdb.DBPART000.20160616105224.001
  • 4.2 on 16.06.2016 a 7.4.3p2 database restore has been done.
    • Here is an offline backup of 7.4.3p2 done on 20.06.2016
      • /db2_backup/offline/hcfg/HCFG.0.hpssdb.DBPART000.20160620134530.001
      • /db2_backup/offline/hsubsys1/HSUBSYS1.0.hpssdb.DBPART000.20160620134852.001
  • 4.3 hpss test system upgrade from 7.4.3p2 to 7.4.3p3 done on 20.06.2016
    • Here is an offline backup of 7.4.3p3 done on 20.06.2016
      • /db2_backup/offline/hcfg/HCFG.0.hpssdb.DBPART000.20160620142740.001
      • /db2_backup/offline/hsubsys1/HSUBSYS1.0.hpssdb.DBPART000.20160620142756.001
Retrieved from "https://wiki.scc.kit.edu/lsdf/index.php?title=Database_offline_backup_on_hpss_test_core&oldid=3795"