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.

recover from devices. Is it possible?

6 posts in Backup and Recovery Last posting was on 2009-07-02 17:22:33.0Z
"Manuel Espinoza" <jmespinoza_no_spam Posted on 2009-06-30 18:27:13.0Z
From: "Manuel Espinoza" <jmespinoza_no_spam@seicom_dot_com_dot_mx>
Newsgroups: sybase.public.ase.backup+recovery
Subject: recover from devices. Is it possible?
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a4a5901$2@forums-3-dub.sybase.com>
Date: 30 Jun 2009 11:27:13 -0700
X-Trace: forums-3-dub.sybase.com 1246386433 10.22.241.152 (30 Jun 2009 11:27:13 -0700)
X-Original-Trace: 30 Jun 2009 11:27:13 -0700, vip152.sybase.com
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3990
Article PK: 48076

Hi all;

I'm using ASE 15 Developer, and I had 4 DB for testing here. I have no idea
why, but the server just stopeed working last saturday, so no chance for a
backup(ok, my bad I didn'd do any backup before :( ). Now I have a new
server, but I wonder if I could get back my DB from only those .dat files.

Any idea?


Thanks in advance!


Bret Halford [Sybase] Posted on 2009-07-01 15:40:03.0Z
From: "Bret Halford [Sybase]" <bret@sybase.com>
Organization: Sybase, Inc.
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: recover from devices. Is it possible?
References: <4a4a5901$2@forums-3-dub.sybase.com>
In-Reply-To: <4a4a5901$2@forums-3-dub.sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a4b8353$3@forums-3-dub.sybase.com>
Date: 1 Jul 2009 08:40:03 -0700
X-Trace: forums-3-dub.sybase.com 1246462803 10.22.241.152 (1 Jul 2009 08:40:03 -0700)
X-Original-Trace: 1 Jul 2009 08:40:03 -0700, vip152.sybase.com
Lines: 17
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3993
Article PK: 48081


Manuel Espinoza wrote:
> Hi all;
>
> I'm using ASE 15 Developer, and I had 4 DB for testing here. I have no idea
> why, but the server just stopeed working last saturday, so no chance for a
> backup(ok, my bad I didn'd do any backup before :( ). Now I have a new
> server, but I wonder if I could get back my DB from only those .dat files.
>
> Any idea?
>
>
> Thanks in advance!

Yes. Use the DISK REINIT command to create the sysdevices table entries
for the devices, then DISK REFIT to cause ASE to scan the devices
and build up the sysdatabases and sysusages system tables from what
it finds on the disk.


José Manuel Espinoza Posted on 2009-07-01 17:15:35.0Z
From: José Manuel Espinoza <g.jmespinoza@gmail.com>
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: recover from devices. Is it possible?
Date: Wed, 1 Jul 2009 10:15:35 -0700 (PDT)
Organization: http://groups.google.com
Lines: 26
Message-ID: <e76f7cc6-ebfa-43a5-9beb-d0c2a81b42f5@n11g2000yqb.googlegroups.com>
References: <4a4a5901$2@forums-3-dub.sybase.com> <4a4b8353$3@forums-3-dub.sybase.com>
NNTP-Posting-Host: 189.237.96.209
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1246468535 20174 127.0.0.1 (1 Jul 2009 17:15:35 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 1 Jul 2009 17:15:35 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: n11g2000yqb.googlegroups.com; posting-host=189.237.96.209; posting-account=M2F0IwoAAAA4rX9L_TlKy2OTnQTgGqir
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.0.11) Gecko/2009060215 Firefox/3.0.11,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!n11g2000yqb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3994
Article PK: 48083


On 1 jul, 10:40, "Bret Halford [Sybase]" <b...@sybase.com> wrote:
> Manuel Espinoza wrote:
> > Hi all;
>
> > I'm using ASE 15 Developer, and I had 4 DB for testing here. I have no idea
> > why, but the server just stopeed working last saturday, so no chance for a
> > backup(ok, my bad I didn'd do any backup before :( ). Now I have a new
> > server,  but I wonder if I could get back my DB from only those .dat files.
>
> > Any idea?
>
> > Thanks in advance!
>
> Yes. Use the DISK REINIT command to create the sysdevices table entries
> for the devices, then DISK REFIT to cause ASE to scan the devices
> and build up the sysdatabases and sysusages system tables from what
> it finds on the disk.

Thansk for the answer, Bret.

I'm going to try it, but in the meanwhile... would it matter if the DB
where set on more than one device?


José Manuel Espinoza Posted on 2009-07-01 22:23:32.0Z
From: José Manuel Espinoza <g.jmespinoza@gmail.com>
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: recover from devices. Is it possible?
Date: Wed, 1 Jul 2009 15:23:32 -0700 (PDT)
Organization: http://groups.google.com
Lines: 12
Message-ID: <832d9301-ea68-4f40-83ee-57d4f194d515@b15g2000yqd.googlegroups.com>
References: <4a4a5901$2@forums-3-dub.sybase.com> <4a4b8353$3@forums-3-dub.sybase.com> <e76f7cc6-ebfa-43a5-9beb-d0c2a81b42f5@n11g2000yqb.googlegroups.com>
NNTP-Posting-Host: 189.237.96.209
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1246487012 4593 127.0.0.1 (1 Jul 2009 22:23:32 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 1 Jul 2009 22:23:32 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: b15g2000yqd.googlegroups.com; posting-host=189.237.96.209; posting-account=M2F0IwoAAAA4rX9L_TlKy2OTnQTgGqir
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.0.11) Gecko/2009060215 Firefox/3.0.11,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!b15g2000yqd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3995
Article PK: 48082

I can't get it to work... :(

I'm asked to start the server with "-m" option, then do the disk
reinit, but when I try to run the "disk refit" command, I'm asked to
run the server with the trace flag 3608, but I cannot start it with
such flag:

C:\sybase\ASE-15_0\bin\sqlsrvr.exe -sSERVERCHUY -T3608

Will lead to error.

Any idea?


Bret Halford [Sybase] Posted on 2009-07-02 17:22:33.0Z
From: "Bret Halford [Sybase]" <bret@sybase.com>
Organization: Sybase, Inc.
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: recover from devices. Is it possible?
References: <4a4a5901$2@forums-3-dub.sybase.com> <4a4b8353$3@forums-3-dub.sybase.com> <e76f7cc6-ebfa-43a5-9beb-d0c2a81b42f5@n11g2000yqb.googlegroups.com> <832d9301-ea68-4f40-83ee-57d4f194d515@b15g2000yqd.googlegroups.com>
In-Reply-To: <832d9301-ea68-4f40-83ee-57d4f194d515@b15g2000yqd.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a4cecd9$2@forums-3-dub.sybase.com>
Date: 2 Jul 2009 10:22:33 -0700
X-Trace: forums-3-dub.sybase.com 1246555353 10.22.241.152 (2 Jul 2009 10:22:33 -0700)
X-Original-Trace: 2 Jul 2009 10:22:33 -0700, vip152.sybase.com
Lines: 20
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3997
Article PK: 48085


José Manuel Espinoza wrote:
> I can't get it to work... :(
>
> I'm asked to start the server with "-m" option, then do the disk
> reinit, but when I try to run the "disk refit" command, I'm asked to
> run the server with the trace flag 3608, but I cannot start it with
> such flag:
>
> C:\sybase\ASE-15_0\bin\sqlsrvr.exe -sSERVERCHUY -T3608
>
> Will lead to error.
>
> Any idea?

Doesn't look like enough parameters being passed here, for instance
no -d <master device>....

Usually you would make a copy of the RUN_servername file and add the -m
and -T parameters there and use that file to start the server.


Bret Halford [Sybase] Posted on 2009-07-02 17:20:30.0Z
From: "Bret Halford [Sybase]" <bret@sybase.com>
Organization: Sybase, Inc.
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: recover from devices. Is it possible?
References: <4a4a5901$2@forums-3-dub.sybase.com> <4a4b8353$3@forums-3-dub.sybase.com> <e76f7cc6-ebfa-43a5-9beb-d0c2a81b42f5@n11g2000yqb.googlegroups.com>
In-Reply-To: <e76f7cc6-ebfa-43a5-9beb-d0c2a81b42f5@n11g2000yqb.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a4cec5e@forums-3-dub.sybase.com>
Date: 2 Jul 2009 10:20:30 -0700
X-Trace: forums-3-dub.sybase.com 1246555230 10.22.241.152 (2 Jul 2009 10:20:30 -0700)
X-Original-Trace: 2 Jul 2009 10:20:30 -0700, vip152.sybase.com
Lines: 26
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3996
Article PK: 48084


José Manuel Espinoza wrote:
> On 1 jul, 10:40, "Bret Halford [Sybase]" <b...@sybase.com> wrote:
>> Manuel Espinoza wrote:
>>> Hi all;
>>> I'm using ASE 15 Developer, and I had 4 DB for testing here. I have no idea
>>> why, but the server just stopeed working last saturday, so no chance for a
>>> backup(ok, my bad I didn'd do any backup before :( ). Now I have a new
>>> server, but I wonder if I could get back my DB from only those .dat files.
>>> Any idea?
>>> Thanks in advance!
>> Yes. Use the DISK REINIT command to create the sysdevices table entries
>> for the devices, then DISK REFIT to cause ASE to scan the devices
>> and build up the sysdatabases and sysusages system tables from what
>> it finds on the disk.
>
> Thansk for the answer, Bret.
>
> I'm going to try it, but in the meanwhile... would it matter if the DB
> where set on more than one device?
>

No, but you do need to do DISK REINIT for each device (and if you have
lost any of the devices this process won't work, although in some cases
where the lost device was a log device or a data device that didn't
yet have allocations it can still be possible to recover with
considerably more work).