rman restore failure rdba: 0x01c00001 [message #624804] |
Thu, 25 September 2014 17:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
evoradba
Messages: 144 Registered: April 2005 Location: Canada
|
Senior Member |
|
|
Hello
while restoring a database via rman from production into a Standby server the restore failed with errors below, however it did recover the previous tablespaces , im concerned that the corruption is coming from production? which is the source of the copy of data ..
How can this be fixed?
Trace file _ora_560.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/11.3
System name: Linux
Node name:
Release: 2.6.32-431.29.2.el6.x86_64
Version: #1 SMP Sun Jul 27 15:55:46 EDT 2014
Machine: x86_64
VM name:
Instance name: TEST
Redo thread mounted by this instance: 1
Oracle process number: 17
Unix process pid: 560, image: (TNS V1-V3)
*** 2014-09-25 14:08:46.099
*** SESSION ID:(63.9) 2014-09-25 14:08:46.099
*** CLIENT ID:() 2014-09-25 14:08:46.099
*** SERVICE NAME:() 2014-09-25 14:08:46.099
*** MODULE NAME:(rman@b(TNS V1-V3)) 2014-09-25 14:08:46.099
*** ACTION NAME:(0000011 FINISHED129) 2014-09-25 14:08:46.099
Hex dump of (file 7, block 1)
Dump of memory from 0x00007FA36037BE00 to 0x00007FA36037DE00
7FA36037BE00 0000A200 01C00001 00000000 05010000 [................]
7FA36037BE10 0000A6C1 00000000 00000000 00000000 [................]
7FA36037BE20 00000000 00000000 00000000 00000000 [................]
Repeat 508 times
7FA36037DDF0 00000000 00000000 00000000 00000001 [................]
Corrupt block relative dba: 0x01c00001 (file 7, block 1)
Bad header found during kcvxfh v8
Data in bad block:
type: 0 format: 2 rdba: 0x01c00001
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000001
check value in block header: 0xa6c1
computed block checksum: 0x0
Reading datafile '/u02/oradata/_data01.dbf' for corruption at rdba: 0x01c00001 (file 7, block 1)
Reread (file 7, block 1) found same corrupt data (no logical check)
Hex dump of (file 7, block 1) in trace file _ora_560.trc
Corrupt block relative dba: 0x01c00001 (file 7, block 1)
Bad header found during kcvxfh v8
Data in bad block:
type: 0 format: 2 rdba: 0x01c00001
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000001
check value in block header: 0xa6c1
computed block checksum: 0x0
Reading datafile '/_data01.dbf' for corruption at rdba: 0x01c00001 (file 7, block 1)
Reread (file 7, block 1) found same corrupt data (no logical check)
Thu Sep 25 14:28:56 2014
_____________
|
|
|
Re: rman restore failure rdba: 0x01c00001 [message #624810 is a reply to message #624804] |
Fri, 26 September 2014 00:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68648 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:im concerned that the corruption is coming from production?
Execute dbverify on the file of production database.
Quote:How can this be fixed?
If the corruption is not in the production database then do a new backup of the file
If it is, I think, as it in block 1, you should have a message in alert.log file and the file should be waiting for a recovery (v$datafile.status or dba_data_file.online_status='RECOVER', v$datafile_header.error!=NULL) and it should be restore from a previous backup.
[Updated on: Fri, 26 September 2014 00:41] Report message to a moderator
|
|
|
|
|
Re: rman restore failure rdba: 0x01c00001 [message #624854 is a reply to message #624804] |
Fri, 26 September 2014 11:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
evoradba
Messages: 144 Registered: April 2005 Location: Canada
|
Senior Member |
|
|
is there a way of validating rman backups? just wondering for future after this happen, this was a production copy and was bad,i have RMAN job doing a backup daily + i have through out the day a data pump job, but i rather use the RMAN backup, however after yesterdays scar im worried now
thank you
|
|
|
|
|
|