Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Reload Archive Database

7 posts in General Discussion Last posting was on 2010-04-19 18:27:35.0Z
JM Posted on 2010-04-13 17:57:59.0Z
Sender: 3530.4bc4afd9.1804289383@sybase.com
From: JM
Newsgroups: sybase.public.ase.general
Subject: Reload Archive Database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bc4b0a7.3542.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Apr 2010 10:57:59 -0700
X-Trace: forums-1-dub 1271181479 10.22.241.41 (13 Apr 2010 10:57:59 -0700)
X-Original-Trace: 13 Apr 2010 10:57:59 -0700, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29119
Article PK: 78357

I created an archive database from a dump from our ASE 15.02
production database server. Each night there is a dump from
that production database. I want to reload that archive
database with the nightly dump. How do I do that? I can't
use dump and then load again on the archive db because
that's not supported.


Carl Kayser Posted on 2010-04-13 18:24:08.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4bc4b0a7.3542.1681692777@sybase.com>
Subject: Re: Reload Archive Database
Lines: 13
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bc4b6c8@forums-1-dub>
Date: 13 Apr 2010 11:24:08 -0700
X-Trace: forums-1-dub 1271183048 10.22.241.152 (13 Apr 2010 11:24:08 -0700)
X-Original-Trace: 13 Apr 2010 11:24:08 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29120
Article PK: 78355


<JM> wrote in message news:4bc4b0a7.3542.1681692777@sybase.com...
>I created an archive database from a dump from our ASE 15.02
> production database server. Each night there is a dump from
> that production database. I want to reload that archive
> database with the nightly dump. How do I do that? I can't
> use dump and then load again on the archive db because
> that's not supported.

"Reload"? Wouldn't it be a case of "create archive database ..." each night
to the new dump? Or is the dump done in place to the same file?


JM Posted on 2010-04-13 18:32:55.0Z
Sender: 3577.4bc4b27b.1804289383@sybase.com
From: JM
Newsgroups: sybase.public.ase.general
Subject: Re: Reload Archive Database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bc4b8d7.369d.1681692777@sybase.com>
References: <4bc4b6c8@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Apr 2010 11:32:55 -0700
X-Trace: forums-1-dub 1271183575 10.22.241.41 (13 Apr 2010 11:32:55 -0700)
X-Original-Trace: 13 Apr 2010 11:32:55 -0700, 10.22.241.41
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29121
Article PK: 78356


> <JM> wrote in message
> news:4bc4b0a7.3542.1681692777@sybase.com... >I created an
> > archive database from a dump from our ASE 15.02
> production database server. Each night there is a dump
> > from that production database. I want to reload that
> > archive database with the nightly dump. How do I do
> > that? I can't use dump and then load again on the
> > archive db because that's not supported.
>
> "Reload"? Wouldn't it be a case of "create archive
> database ..." each night to the new dump? Or is the dump
> done in place to the same file?
>
>

The dump is done to the same file every night. In other
words the backup script/routine just over writes the
previous days backup.

So, I just want to "refresh" the archive database with the
new nightly backup dump. Does that make sense? I'm rather
new to Sybase. I desire to have this Archive database
current or in sync with the production database. At least
from a day old perspective.


Carl Kayser Posted on 2010-04-15 11:22:16.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4bc4b6c8@forums-1-dub> <4bc4b8d7.369d.1681692777@sybase.com>
Subject: Re: Reload Archive Database
Lines: 37
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bc6f6e8@forums-1-dub>
Date: 15 Apr 2010 04:22:16 -0700
X-Trace: forums-1-dub 1271330536 10.22.241.152 (15 Apr 2010 04:22:16 -0700)
X-Original-Trace: 15 Apr 2010 04:22:16 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29130
Article PK: 78368


<JM> wrote in message news:4bc4b8d7.369d.1681692777@sybase.com...
>> <JM> wrote in message
>> news:4bc4b0a7.3542.1681692777@sybase.com... >I created an
>> > archive database from a dump from our ASE 15.02
>> production database server. Each night there is a dump
>> > from that production database. I want to reload that
>> > archive database with the nightly dump. How do I do
>> > that? I can't use dump and then load again on the
>> > archive db because that's not supported.
>>
>> "Reload"? Wouldn't it be a case of "create archive
>> database ..." each night to the new dump? Or is the dump
>> done in place to the same file?
>>
>>
>
> The dump is done to the same file every night. In other
> words the backup script/routine just over writes the
> previous days backup.
>
> So, I just want to "refresh" the archive database with the
> new nightly backup dump. Does that make sense?

The goal makes sense.

I'm rather
> new to Sybase. I desire to have this Archive database
> current or in sync with the production database. At least
> from a day old perspective.

I don't think that it should work since the "scratch database" is not
updated with "modified pages" when the dump is overwritten. See pages
15-16, 26-27 and 32-39 at
http://www.sybase.com/files/Product_Overviews/Sybase-ISUG-101707.pdf


JM Posted on 2010-04-15 13:01:15.0Z
Sender: 5632.4bc701fe.1804289383@sybase.com
From: JM
Newsgroups: sybase.public.ase.general
Subject: Re: Reload Archive Database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bc70e1a.5874.1681692777@sybase.com>
References: <4bc6f6e8@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Apr 2010 06:01:15 -0700
X-Trace: forums-1-dub 1271336475 10.22.241.41 (15 Apr 2010 06:01:15 -0700)
X-Original-Trace: 15 Apr 2010 06:01:15 -0700, 10.22.241.41
Lines: 43
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29131
Article PK: 78370


> <JM> wrote in message
> news:4bc4b8d7.369d.1681692777@sybase.com... >> <JM> wrote
> in message >> news:4bc4b0a7.3542.1681692777@sybase.com...
> >I created an >> > archive database from a dump from our
> ASE 15.02 >> production database server. Each night there
> is a dump >> > from that production database. I want to
> reload that >> > archive database with the nightly dump.
> How do I do >> > that? I can't use dump and then load
> again on the >> > archive db because that's not supported.
> >>
> >> "Reload"? Wouldn't it be a case of "create archive
> >> database ..." each night to the new dump? Or is the
> dump >> done in place to the same file?
> >>
> >>
> >
> > The dump is done to the same file every night. In other
> > words the backup script/routine just over writes the
> > previous days backup.
> >
> > So, I just want to "refresh" the archive database with
> > the new nightly backup dump. Does that make sense?
>
> The goal makes sense.
>
> I'm rather
> > new to Sybase. I desire to have this Archive database
> > current or in sync with the production database. At
> > least from a day old perspective.
>
> I don't think that it should work since the "scratch
> database" is not updated with "modified pages" when the
> dump is overwritten. See pages 15-16, 26-27 and 32-39
> at
>
http://www.sybase.com/files/Product_Overviews/Sybase-ISUG-101707.pdf
>
>

Thanks for your input. This is what I'm going to do. I'll
just drop the archive database each night and do a load with
the new dump that was done earlier. That should work fine.
Agree?


Carl Kayser Posted on 2010-04-15 15:09:36.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4bc6f6e8@forums-1-dub> <4bc70e1a.5874.1681692777@sybase.com>
Subject: Re: Reload Archive Database
Lines: 61
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bc72c30$1@forums-1-dub>
Date: 15 Apr 2010 08:09:36 -0700
X-Trace: forums-1-dub 1271344176 10.22.241.152 (15 Apr 2010 08:09:36 -0700)
X-Original-Trace: 15 Apr 2010 08:09:36 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29132
Article PK: 78369


<JM> wrote in message news:4bc70e1a.5874.1681692777@sybase.com...
>> <JM> wrote in message
>> news:4bc4b8d7.369d.1681692777@sybase.com... >> <JM> wrote
>> in message >> news:4bc4b0a7.3542.1681692777@sybase.com...
>> >I created an >> > archive database from a dump from our
>> ASE 15.02 >> production database server. Each night there
>> is a dump >> > from that production database. I want to
>> reload that >> > archive database with the nightly dump.
>> How do I do >> > that? I can't use dump and then load
>> again on the >> > archive db because that's not supported.
>> >>
>> >> "Reload"? Wouldn't it be a case of "create archive
>> >> database ..." each night to the new dump? Or is the
>> dump >> done in place to the same file?
>> >>
>> >>
>> >
>> > The dump is done to the same file every night. In other
>> > words the backup script/routine just over writes the
>> > previous days backup.
>> >
>> > So, I just want to "refresh" the archive database with
>> > the new nightly backup dump. Does that make sense?
>>
>> The goal makes sense.
>>
>> I'm rather
>> > new to Sybase. I desire to have this Archive database
>> > current or in sync with the production database. At
>> > least from a day old perspective.
>>
>> I don't think that it should work since the "scratch
>> database" is not updated with "modified pages" when the
>> dump is overwritten. See pages 15-16, 26-27 and 32-39
>> at
>>
> http://www.sybase.com/files/Product_Overviews/Sybase-ISUG-101707.pdf
>>
>>
>
> Thanks for your input. This is what I'm going to do. I'll
> just drop the archive database each night and do a load with
> the new dump that was done earlier. That should work fine.
> Agree?

I don't work for Sybase and I'm not an expert on this (caveat lector)
although I have used this feature (anf think that it is pretty neat). I
think that all that you have to do is

Keep the archive database (possibly unless you have done "alter database"
since the previous dump?).
Load the database from the newer dump.
Online the database.

I'm not 100% sure about the the first step that I suggest since I have never
"overwritten" a database this way. If it doesn't work then dropping the
archive database and re-creating it would replace the "keep archive
database".


Carl Kayser Posted on 2010-04-19 18:27:35.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4bc6f6e8@forums-1-dub> <4bc70e1a.5874.1681692777@sybase.com> <4bc72c30$1@forums-1-dub>
Subject: Re: Reload Archive Database
Lines: 78
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bcca097$1@forums-1-dub>
Date: 19 Apr 2010 11:27:35 -0700
X-Trace: forums-1-dub 1271701655 10.22.241.152 (19 Apr 2010 11:27:35 -0700)
X-Original-Trace: 19 Apr 2010 11:27:35 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29137
Article PK: 78374


"Carl Kayser" <kayser_c@bls.gov> wrote in message
news:4bc72c30$1@forums-1-dub...
>
> <JM> wrote in message news:4bc70e1a.5874.1681692777@sybase.com...
>>> <JM> wrote in message
>>> news:4bc4b8d7.369d.1681692777@sybase.com... >> <JM> wrote
>>> in message >> news:4bc4b0a7.3542.1681692777@sybase.com...
>>> >I created an >> > archive database from a dump from our
>>> ASE 15.02 >> production database server. Each night there
>>> is a dump >> > from that production database. I want to
>>> reload that >> > archive database with the nightly dump.
>>> How do I do >> > that? I can't use dump and then load
>>> again on the >> > archive db because that's not supported.
>>> >>
>>> >> "Reload"? Wouldn't it be a case of "create archive
>>> >> database ..." each night to the new dump? Or is the
>>> dump >> done in place to the same file?
>>> >>
>>> >>
>>> >
>>> > The dump is done to the same file every night. In other
>>> > words the backup script/routine just over writes the
>>> > previous days backup.
>>> >
>>> > So, I just want to "refresh" the archive database with
>>> > the new nightly backup dump. Does that make sense?
>>>
>>> The goal makes sense.
>>>
>>> I'm rather
>>> > new to Sybase. I desire to have this Archive database
>>> > current or in sync with the production database. At
>>> > least from a day old perspective.
>>>
>>> I don't think that it should work since the "scratch
>>> database" is not updated with "modified pages" when the
>>> dump is overwritten. See pages 15-16, 26-27 and 32-39
>>> at
>>>
>> http://www.sybase.com/files/Product_Overviews/Sybase-ISUG-101707.pdf
>>>
>>>
>>
>> Thanks for your input. This is what I'm going to do. I'll
>> just drop the archive database each night and do a load with
>> the new dump that was done earlier. That should work fine.
>> Agree?
>
> I don't work for Sybase and I'm not an expert on this (caveat lector)
> although I have used this feature (anf think that it is pretty neat). I
> think that all that you have to do is
>
> Keep the archive database (possibly unless you have done "alter database"
> since the previous dump?).
> Load the database from the newer dump.
> Online the database.
>
> I'm not 100% sure about the the first step that I suggest since I have
> never "overwritten" a database this way. If it doesn't work then dropping
> the archive database and re-creating it would replace the "keep archive
> database".
>

Just had an interesting problem with ADA. ADA database had a reference to
an external database. Since the database is read-only the sysreferences
rows could not be directly deleted after allowing system updates. Nice way
to paint oneself into a corner.

We simply did a load database of the same database but with a dump for a
database without any cross-database references. Then online and drop
database. The proposed solution of Load and Online with new dumps looks
like a solution for you. The only caveat that I can think of is if the
dumped database grows signifigantly in size it might be that the ADA
database might have to be bigger - this will depend upon how much float you
already have in the ADA database creation.