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.

Raw (dd) backup of master database

4 posts in Backup and Recovery Last posting was on 2001-04-12 13:31:58.0Z
royen99 Posted on 2001-04-11 11:16:15.0Z
From: royen99
Date: Wed, 11 Apr 2001 07:16:15 -0400
Newsgroups: sybase.public.sqlserver.backup+recovery
Subject: Raw (dd) backup of master database
Message-ID: <8B534D77A1A55860003DE9BD85256A2B.003DE9D285256A2B@webforums>
Lines: 26
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:329
Article PK: 1060846

Hi,

We are running sybase sql server with it's databases as raw-devices on a
HP-Autoraid system (hp9000/800-hpux10.20.
We recently had a problem where all disks from the autoraid where destroyed
and we hat to restore the entitre system.
Since also the master database was gone, the sql server did not want to
startup as it was missing the master.
We where able to dd a different master database from a different system
(but with the same layout), copy the dd file to the affected system and dd
it back there so we could start the sql server again to recreate the rest
of the databases.
We now want to make regular dd backups of each master database that we
have. The problem is that the sql server is not allowed to be shutdown at
all times. and if the sql server is writing to the disk while we are dd'ing
the raw-device to file, it may become unusable.
We want to know a way to in some way tell sybase that it is not allowed to
write to the device for a certain timeframe (15 to 20 minutes) so we can dd
the data, and once done sql is allowed to write again to the disk to
perform all writes it wanted to do during the time we were dd'ing.
possible ?

Thanks in advance...

Nico van Royen
KPN Telecom The Netherlands.


Bret Halford Posted on 2001-04-11 19:06:06.0Z
Message-ID: <3AD4AB1E.B37EE318@sybase.com>
Date: Wed, 11 Apr 2001 13:06:06 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Raw (dd) backup of master database
References: <8B534D77A1A55860003DE9BD85256A2B.003DE9D285256A2B@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 58
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:327
Article PK: 1060843

There is no way to tell ASE to continue operating but without any disk
activity.
Even if there were, it would probably quickly come to a halt once data cache
was
filled with dirty pages (ie, no room to swap in new pages) waiting for a chance
to
write.

If you can't shutdown the server, then taking a dd copy of the master database
is not a good approach. I would instead advise taking a regular sybase dump
of the master database, and as extra insurance you could bcp out all of the
major
system tables (the most critical are syslogins, sysdatabases, sysusages, and
sysdevices).

Note that there is, in ASE 12.0, a new command "QUEISCE DATABASE" which
can halt all activity on a set of user databases, which can be used to make a
consistant
copy of the underlying devices without shutting down the whole server.
However,
the command does stop all activity on the databases, it does not put the db
into a
"cache-only" kind of mode.

-bret

royen99 wrote:

> Hi,
>
> We are running sybase sql server with it's databases as raw-devices on a
> HP-Autoraid system (hp9000/800-hpux10.20.
> We recently had a problem where all disks from the autoraid where destroyed
> and we hat to restore the entitre system.
> Since also the master database was gone, the sql server did not want to
> startup as it was missing the master.
> We where able to dd a different master database from a different system
> (but with the same layout), copy the dd file to the affected system and dd
> it back there so we could start the sql server again to recreate the rest
> of the databases.
> We now want to make regular dd backups of each master database that we
> have. The problem is that the sql server is not allowed to be shutdown at
> all times. and if the sql server is writing to the disk while we are dd'ing
> the raw-device to file, it may become unusable.
> We want to know a way to in some way tell sybase that it is not allowed to
> write to the device for a certain timeframe (15 to 20 minutes) so we can dd
> the data, and once done sql is allowed to write again to the disk to
> perform all writes it wanted to do during the time we were dd'ing.
> possible ?
>
> Thanks in advance...
>
> Nico van Royen
> KPN Telecom The Netherlands.


royen99 Posted on 2001-04-12 13:08:34.0Z
From: royen99
Date: Thu, 12 Apr 2001 09:08:34 -0400
Newsgroups: sybase.public.sqlserver.backup+recovery
Subject: Re: Raw (dd) backup of master database
Message-ID: <FA383DC010CEF00E0048323985256A2C.006B3C8785256A2B@webforums>
References: <8B534D77A1A55860003DE9BD85256A2B.003DE9D285256A2B@webforums> <3AD4AB1E.B37EE318@sybase.com>
Lines: 19
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:321
Article PK: 1060839


>If you can't shutdown the server, then taking a dd copy of the master
database
>is not a good approach. I would instead advise taking a regular sybase
dump
>of the master database, and as extra insurance you could bcp out all of
the major
>system tables (the most critical are syslogins, sysdatabases, sysdevices).

Thanks,
Our problem was not, not beeing able to shutdown the server. While the
problem arrised, a HP support engineer was upgrading the firmware of our
disks, autoraid as well as replacing a failed disk in that autoraid. ALL
disks in the autoraid where erased of all data/partition info (by mistake
of the HP engineer) and the sql server/hp-ux machine was already shutdown.
We restored the server using ignite & omniback-II, but they do not backup
raw-devices, only mounted logical volumes.
While booting the server, the sql-dataengine was unable to come online
because it did not have a master-database.

Nico van Royen
KPN Telecom The Netherlands.


Anthony Mandic <amandic Posted on 2001-04-12 13:31:58.0Z
Date: Thu, 12 Apr 2001 23:31:58 +1000
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Raw (dd) backup of master database
References: <8B534D77A1A55860003DE9BD85256A2B.003DE9D285256A2B@webforums> <3AD4AB1E.B37EE318@sybase.com> <FA383DC010CEF00E0048323985256A2C.006B3C8785256A2B@webforums>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <hglfDf1wAHA.165@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 22
NNTP-Posting-Host: CPE-208-111-111-203.syd.dav.net.au 203.111.111.208
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:320
Article PK: 1060837


royen99 wrote:

> Our problem was not, not beeing able to shutdown the server. While the
> problem arrised, a HP support engineer was upgrading the firmware of our
> disks, autoraid as well as replacing a failed disk in that autoraid. ALL
> disks in the autoraid where erased of all data/partition info (by mistake
> of the HP engineer) and the sql server/hp-ux machine was already shutdown.
> We restored the server using ignite & omniback-II, but they do not backup
> raw-devices, only mounted logical volumes.

You should be using the Sybase Backup Server to make hot backups.
Dump your dbs to disk if you have the space and let Omni pick them
up. They probably have a plug-in too (I think there was a recent
post asking about this). Alternately, dump directly to tape. Read
up on the docs about this and how to recover.

-am © 2001