| Bishal |
Posted: Apr 28, 2008 08:01:41 AM |
Total Post: 160
Joined: Apr, 2008
|
IS there any way we can know about corrupt files or blocks using user managed backups... i know we can do it through rmaN BUT CAN WE FIND OUT THROUGH USER MANAGED BACKUPS...
YOUR REPLIES WILL BE VERY MUCH APPRECIATED... |
|
|
 GOPU |
| Posted: Apr 28, 2008 08:09:27 AM |  |
|
Total Post: 239
Joined: Apr, 2008
|
you can detect the data block corruption using the DBVERITY utility.
DBVERIFY is an external command-line utility that performs a physical data structure integrity check on an offline database. It can be used against backup files and online files. Integrity checks are significantly faster if you run against an offline database.
Restrictions:
DBVERIFY checks are limited to cache-managed blocks. It’s only for use with datafiles, it will not work against control files or redo logs.
The following example is sample output of verification for the data file system_ts_01.dbf. And its Start block is 9 and end block is 25. Blocksize parameter is required only if the file to be verified has a non-2kb block size. Logfile parameter specifies the file to which logging information should be written. The feedback parameter has been given the value 2 to display one dot on the screen for every 2 blocks processed.
$ dbv file=system_ts_01.dbf start=9 end=25 blocksize=16384 logfile=dbvsys_ts.log feedback=2
DBVERIFY: Release 8.1.7.3.0 - Production on Fri Sep 13 14:11:52 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Output:
$ pg dbvsys_ts.log
DBVERIFY: Release 8.1.7.3.0 - Production on Fri Sep 13 14:11:52 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = system_ts_01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 17
Total Pages Processed (Data) : 10
Total Pages Failing (Data) : 0
Total Pages Processed (Index) : 2
Total Pages Failing (Index) : 0
Total Pages Processed (Other) : 5
Total Pages Empty : 0
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
You can go through this link, it will hepl you to get some more information
http://www.revealnet.com/newsletter-v4/0103_C.htm
|
|
|
|
|
| Bishal |
| Posted: Apr 28, 2008 08:16:58 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
THANX A LOT FOR YOUR REPLY
|
|
|
|
|
| Murtuja |
| Posted: Apr 28, 2008 08:28:46 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Hi Gopu,
Please don't copy/paste content from any sites. It’s can create copyright issues and effect this forum.
Instead of copy/paste just point to that site.
Original content is from this site:
http://www.revealnet.com/newsletter-v4/0103_C.htm
|
|
|
|
|
| GOPU |
| Posted: Apr 28, 2008 08:35:14 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
Hi Murtuja,
Sorry for that :)
Regards
Gopu G
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
