IDS Forum

RE: consistency check on offline database

Posted By: Sebastian, Norma J.
Date: Thursday, 4 January 2007, at 12:52 p.m.

In Response To: consistency check on offline database (Andreas.KUTSCHE@spar.at)

That is an interesting question.

I don't have the answer. Is there more about your env that you can share?

We also do SRDF and play with BCVs, but we don't back up the raw data to tape because that's a lot more to back up than if informix/onbar controlled it and only sent what is used to the backup media.

Do you have a test systems that can take the BCV image? then bring up the test system and run onchecks?
i.e., we copy PRD BCVs to several test systems and bring those up as informix instances for those test systems.
We also have SRDF running to the R2s at our hotsite. The hotsite has a BCV which normally is in sync with the R2s. When we need to test hotsite, we split the BCV and bring informix up on it, meanwhile SRDF is still in sync with production DB.
We run full onchecks at the hotsite.

Norma Jean Sebastian
ERP Support Administration
IT - Enterprise Technical Services

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Andreas.KUTSCHE@spar.at
Sent: Thursday, January 04, 2007 6:28 AM
To: ids@iiug.org
Subject: consistency check on offline database [8105]

Hello,

is there a possibility/tools to do a consistency check on an offline database?

Background information:
We do full backups with onmode -c block and a split disk mirror solution
(SRDF, BCV).
We would like to check the consistency (at table or page level) of the mirror
copy, but without starting an IDS instance on the mirror copy, because that
would change the copy (e.g. write a checkpoint) and we would loose the
possibility to apply logical logs to
the mirror copy in case of a restore.

Regards,
Andreas Kutsche
-------------------------------------------
SPAR Oesterreichische Warenhandels-AG
Hauptzentrale
Europastrasse 3
A - 5015 Salzburg

Tel: +43 662 4470 24223
Mobile: +43 664 6259575
E-Mail: Andreas.KUTSCHE@spar.at
Internet: http://www.spar.at

Wichtiger Hinweis: Der Inhalt dieser E-Mail kann vertrauliche und rechtlich
geschützte Informationen, insbesondere Betriebs- oder Geschäftsgeheimnisse,
enthalten, zu deren Geheimhaltung der Empfänger verpflichtet ist. Die
Informationen in dieser E-Mail sind ausschließlich für den Adressaten
bestimmt. Sollten Sie die E-Mail irrtümlich erhalten haben so ersuchen wir
Sie, die Nachricht von Ihrem System zu löschen und sich mit uns in Verbindung
zu setzen.
Über das Internet versandte E-Mails können leicht manipuliert oder unter
fremdem Namen erstellt werden. Daher schließen wir die rechtliche
Verbindlichkeit der in dieser Nachricht enthaltenen Informationen aus. Der
Inhalt der E-Mail ist nur rechtsverbindlich, wenn er von uns schriftlich
bestätigt und gezeichnet wird.
Sollte trotz der von uns verwendeten Virus-Schutzprogramme durch die Zusendung
von E-Mails ein Virus in Ihre Systeme gelangen, haften wir nicht für evtl.
hieraus entstehende Schäden.
Wir danken für Ihr Verständnis.

Important notice: The contents of this e-mail may contain confidential and
legally protected information that is in particular related to operational and
trade secrets, which the recipient is obliged to treat as confidential. The
information in this e-mail is made available exclusively for use by the
addressee. In the event that the e-mail may have been sent to you in error, we
would ask you to kindly delete this communication from your system and to
contact us.
E-mails sent via the Internet can be easily manipulated or sent out under
someone else's name. We therefore do not accept legal liability for the
information contained in this communication. The contents of the e-mail are
only legally binding if they have been confirmed and signed by us in writing.
If, in spite of our using Antivirus protection software, a virus may have
penetrated your system through the sending of this e-mail, we do not accept
liability for any damage that may possibly arise as a result of this.
We trust that you appreciate our position.

-------------------------------------------

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================

Messages In This Thread

• consistency check on offline database
  Andreas.KUTSCHE@spar.at -- Thursday, 4 January 2007, at 7:28 a.m.
  • Re: consistency check on offline database
    Keith Simmons -- Thursday, 4 January 2007, at 9:21 a.m.
    • AW: consistency check on offline database
      Andreas.KUTSCHE@spar.at -- Thursday, 4 January 2007, at 9:56 a.m.
  • RE: consistency check on offline database
    Sebastian, Norma J. -- Thursday, 4 January 2007, at 12:52 p.m.
    • AW: consistency check on offline database
      Andreas.KUTSCHE@spar.at -- Thursday, 4 January 2007, at 2:03 p.m.
      • RE: consistency check on offline database
        Sebastian, Norma J. -- Friday, 5 January 2007, at 12:33 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.