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.

DB recovery

2 posts in General Discussion Last posting was on 2004-01-09 14:47:00.0Z
Thomas George Posted on 2004-01-08 16:36:56.0Z
From: "Thomas George" <georgeth@phmns.com>
Newsgroups: ianywhere.public.general
Subject: DB recovery
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 66.243.22.98
X-Original-NNTP-Posting-Host: 66.243.22.98
Message-ID: <3ffd8728$1@forums-1-dub>
Date: 8 Jan 2004 08:36:56 -0800
X-Trace: forums-1-dub 1073579816 66.243.22.98 (8 Jan 2004 08:36:56 -0800)
X-Original-Trace: 8 Jan 2004 08:36:56 -0800, 66.243.22.98
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2265
Article PK: 4473

I have a two tier replication set-up using SQLAnywhere 5.5.05
Consolidate Dabatase A which has 5 subscribers
Of the 5 subscribers, one of the databases (Database B) is a consolidated
database with one subscriber Database C


Database A--->Database B---->Database C

Its one way replication from A to B and from B to C

This morning I received an assertion error on Database B (Assertion failed:
50260
Page number on page does not match page requested ) and the database would
not start. I ran dbvalid but got the same error.
Fortunately, I have a backup from last night - this backup was made using
the dbbackup utility

dbbackup of Database B from 9 PM of Jan 7
Database B replicated at 1 AM on Jan 8
Database B crashed at 5 AM on Jan 8

Also, I run dbremote on all sites using the rename and restart transaction
logs and I have the "delete old logs" options set for all databases.

How do I go about restoring the Database B. Can I do it without having to
re-extract B and C?
Please help.
Thanks
Thomas


Stephen Rice Posted on 2004-01-09 14:47:00.0Z
Newsgroups: ianywhere.public.general
Subject: Re: DB recovery
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <3ffd8728$1@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns946B610883A47sricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
X-Original-NNTP-Posting-Host: srice-pc.sybase.com
X-Original-Trace: 9 Jan 2004 06:55:59 -0800, srice-pc.sybase.com
Lines: 79
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Jan 2004 06:32:20 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Jan 2004 06:47:00 -0800
X-Trace: forums-1-dub 1073659620 10.22.108.75 (9 Jan 2004 06:47:00 -0800)
X-Original-Trace: 9 Jan 2004 06:47:00 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2269
Article PK: 4472

"Thomas George" <georgeth@phmns.com> wrote in
news:3ffd8728$1@forums-1-dub:

> I have a two tier replication set-up using SQLAnywhere 5.5.05
> Consolidate Dabatase A which has 5 subscribers
> Of the 5 subscribers, one of the databases (Database B) is a
> consolidated database with one subscriber Database C
>
>
> Database A--->Database B---->Database C
>
> Its one way replication from A to B and from B to C
>
> This morning I received an assertion error on Database B (Assertion
> failed: 50260
> Page number on page does not match page requested ) and the database
> would not start. I ran dbvalid but got the same error.
> Fortunately, I have a backup from last night - this backup was made
> using the dbbackup utility
>
> dbbackup of Database B from 9 PM of Jan 7
> Database B replicated at 1 AM on Jan 8
> Database B crashed at 5 AM on Jan 8
>
> Also, I run dbremote on all sites using the rename and restart
> transaction logs and I have the "delete old logs" options set for all
> databases.
>
> How do I go about restoring the Database B. Can I do it without having
> to re-extract B and C?
> Please help.
> Thanks
> Thomas
>

The first question is "Do you have all of the transaction logs for
database B since the backup?" If you do then the sequence to recover is
approximately:

- shutdown dbremote everywhere
- make a copy of everything (paranoia) Do all work on copies because if
something goes wrong you can always start again
- create a working directory to do the recovery in
- copy the backup of B into your working directory
- validate a copy of the backup. If it is not OK you need to go back a
generation of backups and move forward from there
- recover database B by applying (dbeng -a) the transaction logs in
order
- validate a copy of the database
- make a new full backup


Before starting any of this you should review the documentation on
backup and recovery in both the ASA and SQL Remote guides. There are
also a couple of techdocs you should review:

"I've got an assertion! What should I do?" -
http://www.ianywhere.com/developer/technotes/assertion.html

Why You Should Not Run dbvalid Against a Backup of the Consolidated
Database -
http://www.ianywhere.com/developer/technotes/dbvalid_against_backup.html

If you want direct guidance you can always open a support case.

good luck

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer