01-30-2011 09:15 PM
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.
01-30-2011 09:31 PM
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.
01-31-2011 02:25 AM
please send output of following command
bpimagelist -client slfdb1 -d 12/15/2010 -e 01/15/2011 -U