实战演练

zhuhichn

监控

1。备份监控，可以看到当前备份情况
CMD: db2 backup database backupts online to /mnt/hgfs/F/backup/
Backup successful. The timestamp for this backup image is : 20100711010847

CMD: db2 list utilities show detail

ID                               = 26
Type                             = BACKUP
Database Name                    = BACKUPTS
Partition Number                 = 0
Description                      = online db
Start Time                       = 07/11/2010 01:08:47.274339
State                            = Executing
Invocation Type                  = User
Throttling:
   Priority                      = Unthrottled
Progress Monitoring:
   Estimated Percentage Complete = 85
      Total Work                 = 88997999 bytes
      Completed Work             = 75255383 bytes
      Start Time                 = 07/11/2010 01:08:47.274349

2。恢复监控，可以看到当前恢复情况
CMD: db2 "restore db backupts from /mnt/hgfs/F/backup taken at 20100711010847"
SQL2539W  Warning!  Restoring to an existing database that is the same as the
backup image database.  The database files will be deleted.
Do you want to continue ? (y/n) y
DB20000I  The RESTORE DATABASE command completed successfully.

CMD: db2 list utilities show detail

ID                               = 27
Type                             = RESTORE
Database Name                    = BACKUPTS
Partition Number                 = 0
Description                      = db
Start Time                       = 07/11/2010 01:12:26.150212
State                            = Executing
Invocation Type                  = User
Progress Monitoring:
      Completed Work             = 18116608 bytes
      Start Time                 = 07/11/2010 01:12:26.150214


3。RECOVER监控，可以看到自动先后进行的RESTORE和ROLLFORWARD情况
CMD: db2 "recover database backupts to 2010-07-11-00.41.41 using local time"

                                 Rollforward Status

 Input database alias                   = backupts
 Number of nodes have returned status   = 1

 Node number                            = 0
 Rollforward status                     = not pending
 Next log file to be read               =
 Log files processed                    = S0000007.LOG - S0000008.LOG
 Last committed transaction             = 2010-07-11-00.41.11.000000 Local

DB20000I  The RECOVER DATABASE command completed successfully.

CMD: db2 list utilities show detail

ID                               = 28
Type                             = RESTORE
Database Name                    = BACKUPTS
Partition Number                 = 0
Description                      = automatic incremental db
Start Time                       = 07/11/2010 01:13:46.170174
State                            = Executing
Invocation Type                  = User
Progress Monitoring:
   Phase Number                  = 1
      Total Work                 = 11038720 bytes
      Completed Work             = 11038720 bytes
      Start Time                 = 07/11/2010 01:13:46.170177

   Phase Number [Current]        = 2
      Description                = 20100711003519
      Completed Work             = 90566656 bytes
      Start Time                 = 07/11/2010 01:13:46.397959

   Phase Number                  = 3
      Description                = 20100711003827
      Completed Work             = 0 bytes
      Start Time                 = Not Started

   Phase Number                  = 4
      Description                = 20100711004008
      Completed Work             = 0 bytes
      Start Time                 = Not Started


CMD: db2 list utilities show detail

ID                               = 29
Type                             = ROLLFORWARD RECOVERY
Database Name                    = BACKUPTS
Partition Number                 = 0
Description                      = Database Rollforward Recovery
Start Time                       = 07/11/2010 01:13:52.639551
State                            = Executing
Invocation Type                  = User
Progress Monitoring:
   Estimated Percentage Complete = 100
   Phase Number                  = 1
      Description                = Forward
      Total Work                 = 4173824 bytes
      Completed Work             = 4173824 bytes
      Start Time                 = 07/11/2010 01:13:52.639554

   Phase Number [Current]        = 2
      Description                = Backward
      Total Work                 = 513 bytes
      Completed Work             = 0 bytes
      Start Time                 = 07/11/2010 01:13:52.892432