Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can we run DBVERIFY on raw file system?

Re: Can we run DBVERIFY on raw file system?

From: koert54 <nospam_at_spam.com>
Date: Wed, 24 Mar 2004 21:00:30 GMT
Message-ID: <OFm8c.632155$iA2.82820@news.easynews.com>


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

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

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

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

"koert54" <nospam_at_spam.com> wrote in message news:TDm8c.11488079$Id.1930372_at_news.easynews.com...
> 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 - 15:00:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US