Solved

dbf restored corrupted but not in the production

Posted on 2011-09-16
2
452 Views
Last Modified: 2012-05-12
It has been several times since during the  restore of our db of prod we meet with corrupt dbf :
DBVERIFY - Verification starting : FILE = /data4/test_data_07.dbf
Page 1412419 is marked corrupt
***
Corrupt block relative dba: 0x51d58d43 (file 327, block 1412419)
Bad check value found during dbv:
Data in bad block -
 type: 6 format: 2 rdba: 0x51d58d43
 last change scn: 0x0011.cf2ec495 seq: 0x1 flg: 0x06
 consistency value in tail: 0xc4950601
 check value in block header: 0xf7cf, computed block checksum: 0x40
 spare1: 0x0, spare2: 0x0, spare3: 0x0
***
How is it possible?
Why dbf restored can be corrupted and not in the production?

Thanks

bibi
0
Comment
Question by:bibi92
2 Comments
 
LVL 29

Accepted Solution

by:
Randy Downs earned 500 total points
ID: 36549167
Your backup media could be corrupt.
0
 

Author Closing Comment

by:bibi92
ID: 36550246
Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
selective queries 7 27
PL SQL Developer 7 32
create a nested synonym 4 25
Creation date for a PDB 5 18
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question