Current Position:Home > Recover corrupted datafile

Recover corrupted datafile

Update:11-30Source: network consolidation
Advertisement
I created database from cold backup and db is up and running. After recovery identified some datafiles has corruption with dbfsize.
Could anybody please help me how to recover corrupted datafile from cold backup?

The Best Answer

Advertisement
sorry in my first message I mentioned I verified with dbfsize. It is not dbfsize it is dbv than I found some files has corruption. I db verified original backup datafiles those file are fine no corruption. The problem is while copying the files to the new location some corruption happened. Now I will try to copy original file and dbv first. Now I to recover bad datafiles? I need some steps. Thanks in advance.
Please provide your Oracle version, OS , the actual ORA- errorsOracle version is 9.2.0.7.0
OS SunOS 9
when I run dbv I got big list of errors copied portion of it....
$cat DEEFF.log |more
DBVERIFY: Release 9.2.0.7.0 - Production on Fri Feb 27 00:20:14 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /u01/oracle/DEEFF.dbf
Page 1024 is marked corrupt
Corrupt block relative dba: 0x1f400400 (file 125, block 1024)
Bad header found during dbv:
Data in bad block -
type: 6 format: 2 rdba: 0x1ac580dd
last change scn: 0x0004.f72fdb41 seq: 0x1 flg: 0x04
consistency value in tail: 0xdb410601
check value in block header: 0xb656, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
Page 1025 is marked corrupt
Corrupt block relative dba: 0x1f400401 (file 125, block 1025)
Bad header found during dbv:
Data in bad block -
type: 6 format: 2 rdba: 0x1dc6d021
last change scn: 0x0002.f8bcf84b seq: 0x1 flg: 0x06
consistency value in tail: 0xf84b0601
check value in block header: 0x5983, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
Page 1026 is marked corrupt
Corrupt block relative dba: 0x1f400402 (file 125, block 1026)
Bad header found during dbv:
Data in bad block -
type: 6 format: 2 rdba: 0x1e415f13
last change scn: 0x0004.3e23e1dd seq: 0x1 flg: 0x04
consistency value in tail: 0xe1dd0601
check value in block header: 0x502f, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
Message was edited by:
Gud
  • Recover corrupted datafile Update:11-30

    I created database from cold backup and db is up and running. After recovery identified some datafiles has corruption with dbfsize. Could anybody please help me how to recover corrupted datafile from cold backup?sorry in my first message I mentioned

  • How to diagnose and recover corrupted datafile? Update:11-30

    DBMS: Oracle v.9.2.0.1.0 OS: MS Server 2003 R2 SP2 x86 Problem: Database begin to stop every few minutes. I start to check and found that one and the largest of two datafiles is probably corrupted. Now I have no idea how to repair that datafile. Firs

  • Open database with corrupt datafile Update:11-30

    hi.. all i'm use oracle10g R2 on RHEL 3 ,because power outage my datafile INDEXES.dbf was corrupted and i can't open my database with this corrupted datafile , i'm try to recover the corrupted block with blockrecover command using RMAN and block reco

  • Restore & Recover SYSAUX datafile while DB up Update:11-30

    Hi, Due to data block corruption of SYSAUX, need to keep it offline then recover and make it online. sql 'alter database datafile 2 offline'; restore datafile 2; recover datafile 2; sql 'alter database datafile 2 online'; Is it possible to do this op

  • Recovering a datafile from backup in different server Update:11-30

    Hi All, I usually take hot backup of datafiles to different server like this because i dont have enough space in same server. I SQL> alter tablespace XXXX begin backup; host scp /bu1/oradaTA/XXXXX/XXXXX [email protected]:/db1dw/oradata/backup/dec2010

  • Corrupt Datafiles following "Successful" Clone Process Update:11-30

    Looking for help with the following problem/issue: We attempted to clone our production database to our development environment using RMAN, following a process successfully used on multiple occasions in the past. Both databases are running on UNIX an

  • Corrupted datafiles in standby Update:11-30

    Hello I used to have three indexes in nologging mode in primary database. When I scan the datafiles of these indexes in standby database, I notice that datafiles are logically corrupted. Today, I dropped these indexes in primary database and recreate

  • Maxdb has corrupt datafile Update:11-30

    Hi Everyone, I have my content server running Maxdb 7.3 and it ran out of space when the autoextend was tring to add a datafile.  The database is not able to start now due to the corrupt datafile.  Can you offer any assistance? Is it possible to upgr

  • Why recovering the datafile ? Update:11-30

    Hi, why must we recover a datafile after taking it offline (without restore) to take it online again: SQL*Plus SYS> alter database datafile 27 offline; Datenbank wurde geändert. SQL*Plus SYS> alter database datafile 27 online; alter database datafil

  • Way to recover corrupt .PSD's and / or .JPG's ? Update:11-30

    I am recovering my system after a bad crash. I have many .psd's and .jpg's which are corrupt. Is there any method, tool, or application you would recommend as the best attempt? I see several advertised on the internet. Do any of them work? What is th