Dbverify (dbv) in parallel
Today, I read the blog of Uwe Hesse about multiple dbverify sessions accessing one large datafile in parallel. I had some doubts if running multiple dbverify in parallel can significantly speed up the verification process but it looked like a good idea to me, so I decided to write a perl script to fetch size of the datafile, then spawn dbverify processes according to the desired parallelism.
Here’s the test result:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
[oracle@cloudcontrol12 ~]$ dbv file=/oracle/oradata/emrep/mgmt.dbf;date DBVERIFY: Release 11.2.0.3.0 - Production on Tue Aug 21 17:46:55 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. DBVERIFY - Verification starting : FILE = /oracle/oradata/emrep/mgmt.dbf DBVERIFY - Verification complete Total Pages Examined : 339200 Total Pages Processed (Data) : 26880 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 15980 Total Pages Failing (Index): 0 Total Pages Processed (Other): 32496 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 263844 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Total Pages Encrypted : 0 Highest block SCN : 1868007 (0.1868007) Tue Aug 21 17:47:12 EEST 2012 |