实战演练
监控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 = 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 = 2
Description = Backward
Total Work = 513 bytes
Completed Work = 0 bytes
Start Time = 07/11/2010 01:13:52.892432
页:
[1]