By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

question about online backups

P: n/a
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....is 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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Once you restore an image (independant of Mon.,Tue.,...), any image,
thretore process brings the SQLOGCTL.lFH file.
It contains info as to what logging environment was at backup time.
One piece of info is the first log file number (for ex. SQL006018.LOG)
needed to start the roll forward.
Once it has that, the roll forward process will call each log in sequence
irrespective of the timestamp.
Probably logs 6038 and 6039 had to be "touched" by DB2 after it had closed
6037 and therefore the discrepancy in sequence.

If you have the image mountd in its path, go there and use the db2ckbkp
command to extract the info about the first log file needed.
If you could be in V8.2, your recovery history file would tell you this
also.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Christos Kalantzis" <ch*******@intertrade.com> a écrit dans le message de
news: 1GEne.32734$9A2.29262@edtnps89...
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....is 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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.