Re: Error when startup database

dbv is the executable for the dbverify application.

I don't have the syntax to hand (check the doco at technet.oracle.com), but basically you say "dbv 'filename' blocksize=X log=blah.txt" (at the command prompt, not within SQLPlus or Server Manager -it's a standlone application).

You can leave out the blocksize bit if your Oracle blocksize is 2K, but otherwise, it's compulsory.

The filename bit can refer to any online or offline datafile -ie, you can point it at a dead copy of a datafile copied as part of a backup, or to a file currently in use.

The output is a text file (the log bit), and it basically lists all the blocks scanned (though dbverify calls them "pages") -and reports all the good ones, plus the count of any corrupt ones found.

Personally, I always recommend that anyone doing O/S backups should make running dbv at the end of the backup against the backed up files damn well near compulsory (it's the only real check you've got that the backup set is meaningful).

If you need more help, mail me... I should have the syntax to hand by then (but *do* check technet first... it's a mine of information).

Regards
HJR "misscat" <leoxu100_at_yahoo.com> wrote in message news:af764291.0108130954.7bb00d7f_at_posting.google.com...
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
 news:<3b776b3b_at_usenet.per.paradox.net.au>...
> > There seems to be a problem with it not being able to find or access the
> > system data file. Is it still physically in the directory where the
 error
> > message says it should be? (A quick ls will sort that out).
> >
> > If it's not, you're in to recovery.
> >
> > If it is, check that the file permissions are set properly (I tend to
 chmod
> > 777 just in case, and sort it out more properly if that resolves the
 issue
> > later on).
> >
> > If permissions aren't the issue, then it could be file corruption. To
 check
> > that, you could run dbv against that named datafile, and see what it
> > reports. If it's corruption, then you're in to recovery.
> >
> > Regards
> > HJR
> >
> >
> > Hi Howard,
> I am the new begining of oracle, can you tell me what's meaning of dbv
> and how it works?
>
> misscat>
> >
Received on Tue Aug 14 2001 - 05:05:24 CDT