Re: HP-UX 11/9iR2/dbv

(reposting) Hi! In 9i, you can actually dbv files online. No blocks are falsely detected as corrupt, they're just rescanned in case block header tail SCN and wrap bytes don't match. If the block is continuously in change, then block is reported as being in flux not corrupt. Tanel

HP-UX 11/9iR2/dbv

Hi All! This is a question for the script gurus out there. I am running an SAP system. Recently, during a DR test, we found several files with corruption. These were found originally with an ORA-600 [12700], and confirmed with dbv. So now they want me to run dbv's on the database files during

Re: HP-UX 11/9iR2/dbv

Vergara, Michael (TEM) wrote: Hi All! This is a question for the script gurus out there. I am running an SAP system. Recently, during a DR test, we found several files with corruption. These were found originally with an ORA-600 [12700], and confirmed with dbv. So now they want me

RE: DBV Cannot Load Module LIBDCE.A

|grep -i dce I think you should get hits like dce.client.rte.pthreads If you don't, then I wonder why dbv thinks it needs it... Try the following just to make sure you're running the dbv you think you are: $ which dbv It should return $ORACLE_HOME/bin/dbv, for example: $which dbv /u01/app

RE: DBV Cannot Load Module LIBDCE.A - SOLUTION

Thanks Jared and Scott for your replies. Scott: I ran your lslpp -L |grep -i dce, but it did not produce any output. Which dbv did produce the expected output. I had opened up a TAR with Oracle this morning, and they set me straight in fairly short order. This problem is due to a bug

RE: DBV Cannot Load Module LIBDCE.A

Just found it: on AIX ( 4.3 at least ) it's LIBPATH [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/11/2003 03:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: DBV Cannot Load Module LIBDCE.A

RE: DBV Cannot Load Module LIBDCE.A

-L [EMAIL PROTECTED] cc: Subject:RE: DBV Cannot Load Module LIBDCE.A Hi all, First, thanks Jared for the info. The libdce.a file does not exist on any of our AIX servers. It just AINT there! I typed libdce.a into google and from there downloaded PTF2,3, and 4

DBV Cannot Load Module LIBDCE.A

We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. When I attempt to run DBV I get the following error messages $ dbv help=y exec(): 0509-036 Cannot load program dbv because of the following errors: 0509-150 Dependent module libdce.a(shr.o) could

Re: DBV Cannot Load Module LIBDCE.A

respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:DBV Cannot Load Module LIBDCE.A We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. When I attempt to run DBV I get the following

Re: DBV Cannot Load Module LIBDCE.A

Just found it: on AIX ( 4.3 at least ) it's LIBPATH [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/11/2003 03:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: DBV Cannot Load Module

Re[2]: DBV

, 9:34:49 PM, you wrote: JW I have used DBV repeatedly and heavily on a variety of platforms from JW version 7.3.2 on. ALthough it has always been called an Offline JW Verification Utility, that has never meant that it cannot be used on JW open datafiles. It just means it is not a utility

Re: DBV

Jeremiah, Perhaps the fact that my experience was with Personal Oracle 7.3.2.3 on Win95 explains the hosed database - Win95 not being the best platform, to say the least. I'll definitely try it again - on a test database, of course. BTW, I can't find any way to tell DBV to verify more than one

RE: DBV

Jeremiah, [snip] BTW, I can't find any way to tell DBV to verify more than one datafile at a time. Is there? Doesn't look like it. I tried dbv blocksize=8192 file=system01.dbf,tools01.dbf dbv blocksize=8192 file*.dbf dbv blocksize=8192 file=(system01.dbf,tools01

Re: DBV

In Unix, maybe something like this? for X in *.dbf do dbv file=$X done Add logfiles, paths, etc. as you wish. I suppose something similar must be possible in batch scripting for windows. Then again maybe not! -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 27 Feb 2003

Re: DBV

One of the issues with dbv is that is assumes that you use a 2k block size. In addition, you will want to ignore files for temporary tablespaces. I use the following code to create a shell script to run the dbverify commands. Incorporate this code into a wrapper script and run it periodically

DBV

Hi, Can I use the program DBV on a production datafile (read and write), without take offline the tablespace ? -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K

DBV - New Info

Hi, Can I use the program DBV on a production datafile (read and write), without take offline the tablespace ? New Info : Windows 2000 Oracle 9.0.1.1.1 -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http

Re: DBV

Yes, you can. It may report that a block is influx if the block is being written while dbv is looking at it. If you encounter this error, run it again. If it does not report the same block, you are in the clear. As with any i/o intensive process, run it off-hours. Dan Fink Breno A. K. Magnago

Re: DBV

Dan, That must be new for 9i, since my 8.1.7 docs say it is an offline utility. I remember hosing an entire 7.3 test database years ago when I first ran DBV on it while it was up and open - can't remember the errors, but the DB was unusable. One of the (too) many times I learned to read

RE: DBV

dbv is not crashing my 7.3.4.3.1 instance on hp-ux 10.2 :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: DBV Dan, That must be new for 9i, since my 8.1.7

Re: DBV

I had a scheduled job that ran dbv on Solaris 8.0.4 databases once a week. Never a problem. It has been awhile since I used it on Windows, and I don't recall using it on 7.3 (not that I did not, but my memory is starting to go...). I have never had a problem with it, either with the db up

Re: DBV

I have used DBV repeatedly and heavily on a variety of platforms from version 7.3.2 on. ALthough it has always been called an Offline Verification Utility, that has never meant that it cannot be used on open datafiles. It just means it is not a utility that connects to the database. DBV has

Re: dbv Output - Pages Failing (Data)

Hello, I believe you are using the dbv on Solaris 8 on the datafile of Solaris 6 My experience has been that dbv acts 'very funny' in these type of scenarios in fact what you are encountering is 'expected behaviour' However, don't be surprised if dbv runs 'successfully

dbv Output - Pages Failing (Data)

? - Running dbv Utility for SOME of the Datafiles Giving the Following Error :- $ dbv file=/mis/data3/ACCT_MASTER_bby01_13.dbf blocksize=8192 DBVERIFY: Release 7.3.4.5.0 - Production on Thu Nov 15 13:46:03 2001 Copyright (c) Oracle Corporation 1979, 1996. All rights reserved. DBVERIFY

RE: dbv help

: Multiple recipients of list ORACLE-L Asunto: dbv help Can dbv be used against archive log files? If so, is the block size of archive logs the same as the db_block size? Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe LaCascio INET: [EMAIL

dbv help

Can dbv be used against archive log files? If so, is the block size of archive logs the same as the db_block size? Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: dbv help

nope -- data files only --- Joe LaCascio [EMAIL PROTECTED] wrote: Can dbv be used against archive log files? If so, is the block size of archive logs the same as the db_block size? Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe

HP-UX 11.0/8.1.7.1/DBV Question

Everyone: We noticed some weird ORA-600 messages in our of our test databases, so we ran 'dbv' against them. The database was shut down. Our SYSTEM tablespace shows 'Undo Segment Corrupt' errors, and I have two questions about this. 1) Does this mean my SYSTEM rollback segment is hosed

Re: HP-UX 11.0/8.1.7.1/DBV Question

Hi! sorry ..this may not be 'directly' related to your problem.. But, I am curious to know how you are 'managing' 8.1.7.1 with its bug of '566 session limit'. Cyril -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL

urgent synthax of DBV

i need in urgence DBV synthax thanks !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: urgent synthax of DBV

Try dbv help=y Or click here : http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76955/ch09.htm#1936 (found by searching for 'dbv' at http://tahiti.oracle.com/pls/tahiti/tahiti.homepage :) HTH, Regards, - Kirti Deshpande Verizon Information Services http