Home » RDBMS Server » Backup & Recovery » failure of backup command (Oracle 10g/ Windows 2003)
failure of backup command [message #456655] Wed, 19 May 2010 02:25 Go to next message
bnrk1212
Messages: 12
Registered: May 2010
Location: Kigali/RWANDA
Junior Member

channel ORA_DISK_4: sid=329 instance=rtlprod2 devtype=DISK
could not read file header for datafile 26 error reason 4
could not read file header for datafile 26 error reason 4
could not read file header for datafile 26 error reason 4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/19/2010 08:37:36
RMAN-06056: could not access datafile 26

RMAN>
Re: failure of backup command [message #456656 is a reply to message #456655] Wed, 19 May 2010 02:30 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Looks like datafile is corrupted (or disk is broken).
Re: failure of backup command [message #456657 is a reply to message #456656] Wed, 19 May 2010 02:32 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=39527
http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmcomre.htm#CHDDAGHH

sriram Smile

[Updated on: Wed, 19 May 2010 02:35]

Report message to a moderator

Re: failure of backup command [message #461096 is a reply to message #456657] Wed, 16 June 2010 09:38 Go to previous messageGo to next message
bnrk1212
Messages: 12
Registered: May 2010
Location: Kigali/RWANDA
Junior Member

Hi all;

i tied to restore and recover that datafile called wrong "datafile 26" and datafile come on service but my backup is done;thank you for this!

RMAN> SQL 'ALTER DATABASE DATAFILE 26 OFFLINE';
RMAN> RESTORE DATAFILE 26;
RMAN> RECOVER DATAFILE 26;
RMAN> SQL 'ALTER DATABASE DATAFILE 26 ONLINE'

;but i still have problem with location and name of the datafile 26 which is different like others;in its path where it is there no specific disk group DB name ect .. ( eg:+DG3_DATA/rtlprod)

23 5120 ABILLITY_TABLES NO +DG3_DATA/rtlprod/datafile/abillity_tables_03
24 1036 USERS NO +DG3_DATA/rtlprod/datafile/users006.dbf
25 8192 ABILLITY_CDRS NO +DG3_DATA/rtlprod/datafile/abillity_cdrs_20100517
26 44 SYSAUX NO /data1/app/oracle/product/10.2.0/db_1/dbs/Dt_file20100517
27 680 USERS NO +DG3_DATA/rtlprod/datafile/users007.dbf
28 4096 ABILLITY_TABLES NO +DG3_DATA/rtlprod/datafile/abillity_tables_04
29 600 USERS NO +DG3_DATA/rtlprod/datafile/users008.dbf


Plse advise!
Re: failure of backup command [message #464132 is a reply to message #461096] Tue, 06 July 2010 07:35 Go to previous message
bnrk1212
Messages: 12
Registered: May 2010
Location: Kigali/RWANDA
Junior Member

thx Mr ramoradba for your support and thank you all
Previous Topic: Error in database cloing
Next Topic: How to recover DB using RMAN if my target and catalog both are lost?
Goto Forum:
  


Current Time: Fri Mar 29 10:42:29 CDT 2024