cancel
Showing results for 
Search instead for 
Did you mean: 

Missing backup history

chaypon
Level 3
Certified

Hi

I have a question about list history backup.

I use command ### bplist -C slfdb1 -S slfbkup -t 18 -R /

/DB2/SLFDB/node0000/20110131010846/SLFDB.0.db2slf.node0000.51622.20110131010846.1
/DB2/SLFDB/node0000/20110131003834/SLFDB.0.db2slf.node0000.51621.20110131003834.1
/DB2/SLFDB/node0000/20110131001111/SLFDB.0.db2slf.node0000.51620.20110131001111.1
/DB2/SLFDB/node0000/20110130012421/SLFDB.0.db2slf.node0000.51605.20110130012421.1
/DB2/SLFDB/node0000/20110130004507/SLFDB.0.db2slf.node0000.51603.20110130004507.1
/DB2/SLFDB/node0000/20110129010855/SLFDB.0.db2slf.node0000.51592.20110129010855.1
/DB2/SLFDB/node0000/20110129003814/SLFDB.0.db2slf.node0000.51591.20110129003814.1
/DB2/SLFDB/node0000/20110128010738/SLFDB.0.db2slf.node0000.51567.20110128010738.1
/DB2/SLFDB/node0000/20110128003817/SLFDB.0.db2slf.node0000.51566.20110128003817.1
/DB2/SLFDB/node0000/20110127010836/SLFDB.0.db2slf.node0000.51545.20110127010836.1
/DB2/SLFDB/node0000/20110127003813/SLFDB.0.db2slf.node0000.51544.20110127003813.1
/DB2/SLFDB/node0000/20110126010819/SLFDB.0.db2slf.node0000.51517.20110126010819.1
/DB2/SLFDB/node0000/20110126003717/SLFDB.0.db2slf.node0000.51516.20110126003717.1
/DB2/SLFDB/node0000/20110125010829/SLFDB.0.db2slf.node0000.51496.20110125010829.1
/DB2/SLFDB/node0000/20110125003725/SLFDB.0.db2slf.node0000.51495.20110125003725.1
/DB2/SLFDB/node0000/20110116010629/SLFDB.0.db2slf.node0000.51222.20110116010629.1
/DB2/SLFDB/node0000/20110109010715/SLFDB.0.db2slf.node0000.51001.20110109010715.1
/DB2/SLFDB/node0000/20110102010757/SLFDB.0.db2slf.node0000.50290.20110102010757.1
/DB2/SLFDB/node0000/20101201052133/SLFDB.0.db2slf.node0000.48771.20101201052133.1
/DB2/SLFDB/node0000/20101101050325/SLFDB.0.db2slf.node0000.46479.20101101050325.1
/DB2/SLFDB/node0000/20101001052554/SLFDB.0.db2slf.node0000.41788.20101001052554.1
/DB2/SLFDB/node0000/20100901055954/SLFDB.0.db2slf.node0000.40006.20100901055954.1
root@slfbkup #

..................................................

root@slfbkup #
root@slfbkup # bplist -C slfdb1 -S slfbkup -t 18 -R -s 12/15/2010 -e 01/15/2011 /
/DB2/SLFDB/node0000/20110109010715/SLFDB.0.db2slf.node0000.51001.20110109010715.1
/DB2/SLFDB/node0000/20110102010757/SLFDB.0.db2slf.node0000.50290.20110102010757.1
root@slfbkup #

......................................................

Am sure backup db2 every day. why history backup data 20110101 is lost ?

I want to restore database 20110101 but I don't have timestamp .

thank you.

 

2 REPLIES 2

Marianne
Level 6
Partner    VIP    Accredited Certified

Two possibilities:

The backup was either unsuccessful or has already expired - either automatically due to Schedule Retention Level or manual expiration using bpexpdate.

Check Retention Level in the policy schedule.

It might be difficult to proof success of backup as information in NBU logs are probably lost by now - the default 'Days to keep logs' is 28 days.

Amit_Karia
Level 6

please send output of following command

bpimagelist  -client slfdb1 -d 12/15/2010 -e 01/15/2011 -U