Hello,
DB2 7.2 on AIX.
I take online backups EVERY night and rsync my log folder every hour
after running the DB2 ARCHIVE LOG command to make sure I dump the log
buffer to a log file.
Now the question...
Assuming I take a backup Monday, Tuesday, Wednesday, and all my logs are
rsync'ed every hour, as described above.
Can I restore my DB using my online backup of Monday and my logs (for
the rollforward) that I have been rsync'ing since then, EVEN though I
have been taking other online backups since then?
Next question.....
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 02 06:18 S0016038.LOG
-rw------- 1 db2inst1 db2iadm1 4419584 Jun 02 06:00 S0016037.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 02 05:52 S0016039.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 02 05:52 S0016036.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 02 05:31 S0016035.LOG
-rw------- 1 db2inst1 db2iadm1 3481600 Jun 02 05:00 S0016034.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 02 04:37 S0016033.LOG
-rw------- 1 db2inst1 db2iadm1 4014080 Jun 02 04:00 S0016032.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 02 03:43 S0016031.LOG
-rw------- 1 db2inst1 db2iadm1 303104 Jun 02 03:00 S0016030.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 02 02:57 S0016029.LOG
-rw------- 1 db2inst1 db2iadm1 1912832 Jun 02 02:00 S0016028.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 02 01:44 S0016027.LOG
-rw------- 1 db2inst1 db2iadm1 2486272 Jun 02 01:00 S0016026.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 02 00:47 S0016025.LOG
-rw------- 1 db2inst1 db2iadm1 1208320 Jun 02 00:00 S0016024.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 01 23:49 S0016023.LOG
-rw------- 1 db2inst1 db2iadm1 1032192 Jun 01 23:00 S0016022.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 01 22:52 S0016021.LOG
-rw------- 1 db2inst1 db2iadm1 5120000 Jun 01 22:00 S0016020.LOG
-rw------- 1 db2inst1 db2iadm1 8200192 Jun 01 21:37 S0016019.LOG
-rw------- 1 db2inst1 db2iadm1 4493312 Jun 01 21:00 S0016018.LOG
I have listed my logs in order of date. AS you can see the numbering of
the .LOG files are not necessarily sequential....i s there a reason for
that? (Look at file S0016039.LOG).
Is this bad?
Will this affect the resore (Roll Forward) of an Online backup?
Thank you very much in advance,
Christos