Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!intgwlon.nntp.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail
From: "Howard J. Rogers" <howardjr2000@yahoo.com.au>
Newsgroups: comp.databases.oracle.server
References: <abb2933c.0210100327.13fe257a@posting.google.com>
Subject: Re: Academic question to online files or database to experienced users/admins.
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <9Ckp9.50388$g9.146090@newsfeeds.bigpond.com>
Date: Fri, 11 Oct 2002 05:41:49 +1000
NNTP-Posting-Host: 144.138.45.25
X-Trace: newsfeeds.bigpond.com 1034278405 144.138.45.25 (Fri, 11 Oct 2002 05:33:25 EST)
NNTP-Posting-Date: Fri, 11 Oct 2002 05:33:25 EST
Organization: Telstra BigPond Internet Services (http://www.bigpond.com)
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163770
X-Received-Date: Thu, 10 Oct 2002 12:41:48 MST (news.easynews.com)

Yeah, well... you can't (apparently) expect documentation writers to be able
to communicate using plain English.  What that monstrosity of a
juxtaposition means is: whether the database is up or down, dbverify can
still be used to check for corruption in datafiles.  It makes no difference
if the file is offline or online, or if the entire database is down so that
*all* datafiles are "offline". And, wuite rightly, it says you can also use
it to check *copies* of datafiles (ie, backups taken using copy commands).

Incidentally, a little undocumented fact about dbverify: it checks control
files, too.

Regards
HJR

"Ric" <wolf@wondersoft.de> wrote in message
news:abb2933c.0210100327.13fe257a@posting.google.com...
> In Oracle Doc (Oracle 8i Utilities Release 2 (8.1.6) A76955-02
> you find this to sentences, following directly one after the other:
> Start Doc:
> DBVERIFY is an external command-line utility that performs a physical
> data structure integrity check on an offline database.
> It can be used against backup files and online files (or pieces of
> files).
> End Doc.
>
> So what? I do not understand.
> Sentence One does say the database must be offline, doesn't it?
>
> Sentence Two says, the datafile can be online.
>
> Can a Data file be online with the Database beeing offline?
>
> Please give a clue or help me to interpret because a DBA here says
> this two
> sentences means that DBVERIFY is not a offline tool.
>
> Note that the header of the doc is:
>
> DBVERIFY: Offline Database Verification Utility.
>
> Thank you in advance