Re: DBVERIFY

From: Paul Drake <paled_at_home.com>
Date: Wed, 27 Sep 2000 02:46:26 -0400
Message-Id: <10631.117956@fatcity.com>

On W2K, Ora 8.1.6.1.2 Standard Edition - the starter database that was not yet dropped ... (RMAN play area)

C:\>svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Oracle8i Release 8.1.6.1.0 - Production
JServer Release 8.1.6.0.0 - Production

SVRMGR> connect sys
Password:
Connected.
SVRMGR> select * from dba_data_files where lower(file_name) like '%indx%'; FILE_NAME

 FILE_ID    TABLESPACE_NAME                BYTES      BLOCKS     STATUS

RELAT
IVE_F AUT MAXBYTES MAXBLOCKS INCREMENT_ USER_BYTES USER_BLOCK

------------------------------ ---------- ---------- ---------
- --- ---------- ---------- ---------- ---------- ---------- C:\ORACLE\ORADATA\<db_name>\INDX01.DBF 6 INDX 20971520 2560 AVAILABLE 6 YES 3.4360E+10 4194302 160 20963328 2559 1 row selected.

SVRMGR> select * from dba_tablespaces where tablespace_name='INDX';

TABLESPACE_NAME                INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT

PCT_I
NCREA MIN_EXTLEN STATUS CONTENTS LOGGING EXTENT_MAN ALLOCATIO PLU

------------------------------ ---------- ---------- ---------- ----------

---------- --------- --------- --------- ---------- --------- --- INDX 131072 131072 1 4096 0 131072 ONLINE PERMANENT LOGGING DICTIONARY USER NO 1 row selected.

Executed as a batch file:

dbv FILE=INDX01.DBF BLOCKSIZE=8192 LOGFILE=c:\dbv_indx.log FEEDBACK=1 (it ran from the local directory C:\Oracle\Oradata\<dbname>\)

Produced this log file:
c:\dbv_indx.log

DBVERIFY: Release 8.1.6.1.0 - Production on Wed Sep 27 02:33:27 2000

DBVERIFY - Verification starting : FILE = INDX01.DBF

DBVERIFY - Verification complete

Total Pages Examined         : 2560
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1
Total Pages Empty            : 2559
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

So - as always - it dependz - on version, platform, etc.

Two things are for certain,

For 8.1.6 on NT, dbv.exe works on ONLINE datafiles.
The datafile that I ran it on was MIGHT empty
For those privileged to run on top of *nix, they won't care about this email ... 8^)

time for sleep,

Paul

renato.huliganga_at_au1.ibm.com wrote:

> You can use dbverify online and offline on UNIXs, while offline only on
> Windoze!
> This is not because of dbverify itself but because of O/S differences!

> hth
> R

> Rajesh Dayal <Rajesh_at_ohitelecom.com> on 27/09/2000 03:16:49 pm

> Please respond to ORACLE-L_at_fatcity.com

> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Renato Huliganga/Australia/IBM)

>


> Hi All,

>      I was just checking DBVERIFY. Can it really check the

> DATAFILES even when it is ONLINE?? I mean to say if the database
> is UP and Running can DBVERIFY work???
> All manuals say that it works on offline and online datafiles,
> but when I tried on my test (online) database (NT/Oracle 8.0.5) it
> gives following error :

> DBV-00100: Specified FILE (d:\oracle7\database\sys1ohir.ora) not
> accessible

> Appreciate your feedback,

> Rajesh
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rajesh Dayal
> INET: Rajesh_at_ohitelecom.com

>


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: renato.huliganga_at_au1.ibm.com

>


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------