Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |