Search This Blog

Total Pageviews

Friday 18 March 2011

Oracle dbv database verify Utility

15:57:07 SQL> set linesize 100
15:57:13 SQL> show parameter block
NAME_COL_PLUS_SHOW_PARAM TYPE VALUE_C
-------------------------------------------------------------------------------- ----------- -------
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TRUE
db_block_size integer 8192
db_file_multiblock_read_count integer 16




15:58:09 SQL> !dbv file=/opt/oracle/oradata/orcl/dmdocbase01.dbf blocksize=8192 feedback=3200

DBVERIFY: Release 10.2.0.4.0 - Production on Fri Mar 18 15:58:12 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

DBVERIFY - Verification starting : FILE = /opt/oracle/oradata/orcl/dmdocbase01.dbf
................................................................................
........................

DBVERIFY - Verification complete

Total Pages Examined : 331776
Total Pages Processed (Data) : 184373
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 121327
Total Pages Failing (Index): 0
Total Pages Processed (Other): 8360
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 17716
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 2909064 (0.2909064)

Oracle Goldengate download 32bit etc

go to this site
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
if you don't find the product



Oracle GoldenGate v10.4.0.x for Oracle 10g 32bit on Redhat 4.0
Oracle GoldenGate v10.4.0.x for Oracle 10g 32bit on Redhat 5.0

Oracle GoldenGate on Oracle Media Pack v3 for Linux x86

then

go to https://edelivery.oracle.com/

then fill all the field

then select

select a product Pack: Oracle Fusion Middleware
platform Linux x86

then select this

Oracle GoldenGate on Oracle Media Pack for Linux x86 n/a B56872-03 JUL-19-2010 6 /

Then download for 32 bit

Oracle 10g redhat5.0 v18428-01 26m
Oracle 11g redhat5.0 v18429-01 26m

Oracle DBA

anuj blog Archive