Re: Academic question to online files or database to experienced users/admins.

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_at_wondersoft.de> wrote in message news:abb2933c.0210100327.13fe257a_at_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
Received on Thu Oct 10 2002 - 14:41:49 CDT