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

read only standby db

P: n/a
Hi,
We have 14 GB db (PRICE)on Windows with user exit

Offlie backup done daily at 10 PM
at 7 AM follwing day we restore offline backup of PRICE as
PRICE_R and reapply log files to 6 AM

sometimes is not possible to perform offline ,
next day PRICE_R is not restored (we use it for query and
reports)

Looking for solution to have "read only" copy of PRICE
1. Is it good to use replication for 14GB db with 120 tables?
2. is possible to set PRICE_R to pending state apply additional
logs and remove pending status ?
3. HADR ?

SQL server 2000 allow log shiping and read data on standby server,
anything similar in UDB ?

Thanks
Alex

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Ian
t2***@hotmail.com wrote:
Hi,
We have 14 GB db (PRICE)on Windows with user exit

Offlie backup done daily at 10 PM
at 7 AM follwing day we restore offline backup of PRICE as
PRICE_R and reapply log files to 6 AM

sometimes is not possible to perform offline ,
next day PRICE_R is not restored (we use it for query and
reports)
You can do this procedure using online backups, too.
Looking for solution to have "read only" copy of PRICE
1. Is it good to use replication for 14GB db with 120 tables?
That depends more on the volume of updates, and how frequently you
run apply on the second box.
2. is possible to set PRICE_R to pending state apply additional
logs and remove pending status ?
No. Once you've brought the database out of rollforward pending state
there is no going back (you have to restore from a backup again).
3. HADR ?


Won't work. HADR standby database is offline until it takes over from
the primary.

Nov 12 '05 #2

P: n/a
at 10 :00 AM insert-update job completed
at 10:10 AM online backup started
at 10:40 AM online backup completed
at 10:50 AM restore from online backup started

Does log file(s) generated at the time of the online backup completed
should already be at
"OVERFLOW LOG PATH", or they could be copied over during restore ?
(restore take about 30 minutes then rollforward process starts)

Nov 12 '05 #3

P: n/a
Ian
t2***@hotmail.com wrote:
at 10 :00 AM insert-update job completed
at 10:10 AM online backup started
at 10:40 AM online backup completed
at 10:50 AM restore from online backup started

Does log file(s) generated at the time of the online backup completed
should already be at
"OVERFLOW LOG PATH", or they could be copied over during restore ?
(restore take about 30 minutes then rollforward process starts)


Prior to 8.2, you had to issue the ARCHIVE LOG command once the online
backup completed to make sure that logs that were active during the
online backup were archived (and therefore could be copied to the
standby server).

V8.2 introduced the 'INCLUDE LOGS' option to online backups which
bundles the log files that were active during the backup in with
the backup image (and is meant to simplify restoring online backups).

Nov 12 '05 #4

P: n/a
Specifying the platform and db2l2vel would help!!!
However. Your userexit or logarchmethx parms can be set to archive your logs
on the target system and you can specify in the roll forward command on the
target that the overflow log path is the archive target that received the
logs.

The logs never "move" by themselves. they get where they get because you
specify wjere in the userexit or with logarchmethx parms.
So, as you end your online backup, db2 will chop the current log which makes
it full and kicks your exit or archmeth target.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<t2***@hotmail.com> a écrit dans le message de news:
11*********************@g43g2000cwa.googlegroups.c om...
at 10 :00 AM insert-update job completed
at 10:10 AM online backup started
at 10:40 AM online backup completed
at 10:50 AM restore from online backup started

Does log file(s) generated at the time of the online backup completed
should already be at
"OVERFLOW LOG PATH", or they could be copied over during restore ?
(restore take about 30 minutes then rollforward process starts)


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.