Home » RDBMS Server » Backup & Recovery » rman restore failure rdba: 0x01c00001 (oracle RDBMS 11.3 Linux)
rman restore failure rdba: 0x01c00001 [message #624804] Thu, 25 September 2014 17:44 Go to next message
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 messageGo to next message
Michel Cadot
Messages: 68624
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 #624850 is a reply to message #624804] Fri, 26 September 2014 10:26 Go to previous messageGo to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
thank you - was a bad backup, I made a new backup in production copied into the DR and all good,
Re: rman restore failure rdba: 0x01c00001 [message #624851 is a reply to message #624850] Fri, 26 September 2014 10:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK, all is fine now, thanks to let us know.

Re: rman restore failure rdba: 0x01c00001 [message #624854 is a reply to message #624804] Fri, 26 September 2014 11:00 Go to previous messageGo to next message
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
Re: rman restore failure rdba: 0x01c00001 [message #624855 is a reply to message #624854] Fri, 26 September 2014 11:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just execute a restore/recover command like you'd do it in real case and add VALIDATE option. RMAN will simulate the command, checking all the files but not actually doing the restore/recover.

[Updated on: Fri, 26 September 2014 11:18]

Report message to a moderator

Re: rman restore failure rdba: 0x01c00001 [message #624856 is a reply to message #624855] Fri, 26 September 2014 11:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I showed such a session here.

Re: rman restore failure rdba: 0x01c00001 [message #624859 is a reply to message #624856] Fri, 26 September 2014 12:33 Go to previous message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
thank you for your help
Previous Topic: FLASHBACK of a table but with a SCN of another table
Next Topic: Can not delete obsolete !
Goto Forum:
  


Current Time: Thu Mar 28 07:09:28 CDT 2024