Can we run DBVERIFY on raw file system?

Forte Agent

unread,

Mar 24, 2004, 1:41:39 PM3/24/04

to

Can we run DBVERIFY on raw file system? If possible, does it need any
special parameter or anything? Thank you in advance.

Howard J. Rogers

unread,

Mar 24, 2004, 3:10:59 PM3/24/04

to

"Forte Agent" <144...@usenetplanet.com> wrote in message
news:4hl360l597b39g5ad...@4ax.com...

>
> Can we run DBVERIFY on raw file system? If possible, does it need any
> special parameter or anything? Thank you in advance.

Given that dbv takes two key arguments, namely file=xxxx and blocksize=yyyy,
it's going to be difficult to work with raw, because you're not going to be
able to provide a file name for the first argument. But assuming you get
past that hurdle somehow, 'yyyy' needs to be your actual db_block_size.

Regards
HJR

Brian Peasland

unread,

Mar 24, 2004, 3:13:48 PM3/24/04

to

DBVERIFY can verify just a segment. It would be interesting to see if
one can verify a segment on a raw device with this utility. I don't have
such disks available to me, otherwise I would test it out.

Cheers,
Brian

--
===================================================================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.

"I can give it to you cheap, quick, and good. Now pick two out of
the three"

koert54

unread,

Mar 24, 2004, 3:58:27 PM3/24/04

to

you could use dd (or ocopy on wintel) to make it a file (skip 4k on AIX) :

[root@oraserv ORA8]# dbv file=/dev/raw/raw16 blocksize=4096

DBVERIFY: Release 8.1.7.0.1 - Production on Wed Mar 24 21:51:58 2004

DBV-00102: File I/O error on FILE (/dev/raw/raw16) during read operation
(-2)

root@oraserv ORA8]# dd if=/dev/raw/raw16 of=test.dbv bs=8192

6020+1 records in

6020+1 records out

[root@oraserv ORA8]# dbv file=test.dbv blocksize=8192

DBVERIFY: Release 8.1.7.0.1 - Production on Wed Mar 24 21:53:02 2004

DBVERIFY - Verification starting : FILE = test.dbv

DBVERIFY - Verification complete

Total Pages Examined : 5120

Total Pages Processed (Data) : 34

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 2

Total Pages Failing (Index): 0

Total Pages Processed (Other): 97

Total Pages Empty : 4987

Total Pages Marked Corrupt : 0

Total Pages Influx : 0

I tried using a named pipe, but dbv doesn't take a pipe for input so it
seems :

[root@oraserv ORA8]# mkfifo dbpipe

[root@oraserv ORA8]# dd if=/dev/raw/raw16 of=dbpipe bs=8192 &

[1] 6313

[root@oraserv ORA8]# dbv file=dbpipe blocksize=8192

DBVERIFY: Release 8.1.7.0.1 - Production on Wed Mar 24 21:56:31 2004

DBV-00100: Specified FILE (dbpipe) not accessible

"Forte Agent" <144...@usenetplanet.com> wrote in message
news:4hl360l597b39g5ad...@4ax.com...
>

koert54

unread,

Mar 24, 2004, 4:00:30 PM3/24/04

to

I also tried using a symbolic to the raw device (platform is linux) without
success :
[root@oraserv ORA8]# dbv file=temp01.dbf blocksize=8192

DBVERIFY: Release 8.1.7.0.1 - Production on Wed Mar 24 22:00:13 2004

DBV-00102: File I/O error on FILE (temp01.dbf) during read operation (-2)

"koert54" <nos...@spam.com> wrote in message
news:TDm8c.11488079$Id.19...@news.easynews.com...