OraFAQ Forum: Backup & Recovery » failure of backup command

Home » RDBMS Server » Backup & Recovery » failure of backup command (Oracle 10g/ Windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

failure of backup command [message #456655]

Wed, 19 May 2010 02:25

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>

Report message to a moderator

Re: failure of backup command [message #456656 is a reply to message #456655]

Wed, 19 May 2010 02:30

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Looks like datafile is corrupted (or disk is broken).

Report message to a moderator

Re: failure of backup command [message #456657 is a reply to message #456656]

Wed, 19 May 2010 02:32

ramoradba
Messages: 2457
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

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!

Report message to a moderator

Re: failure of backup command [message #464132 is a reply to message #461096]

Tue, 06 July 2010 07:35

bnrk1212
Messages: 12
Registered: May 2010
Location: Kigali/RWANDA

Junior Member

thx Mr ramoradba for your support and thank you all

Report message to a moderator

Previous Topic:	Error in database cloing
Next Topic:	How to recover DB using RMAN if my target and catalog both are lost?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 13:28:21 CST 2024