Re: Can we run DBVERIFY on raw file system?

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

[root_at_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

(c) Copyright 2000 Oracle Corporation. All rights reserved.

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

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

6020+1 records in

6020+1 records out

[root_at_oraserv ORA8]# dbv file=test.dbv blocksize=8192

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

(c) Copyright 2000 Oracle Corporation. All rights reserved.

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_at_oraserv ORA8]# mkfifo dbpipe

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

[1] 6313

[root_at_oraserv ORA8]# dbv file=dbpipe blocksize=8192

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

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBV-00100: Specified FILE (dbpipe) not accessible

"Forte Agent" <1443131_at_usenetplanet.com> wrote in message news:4hl360l597b39g5ad8dgopbj8i2ot7fgn1_at_4ax.com...
>
> Can we run DBVERIFY on raw file system? If possible, does it need any
> special parameter or anything? Thank you in advance.
>
>
>
Received on Wed Mar 24 2004 - 14:58:27 CST