Home » RDBMS Server » Backup & Recovery » RMAN backup failed
RMAN backup failed [message #331488] Thu, 03 July 2008 10:21 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
Our RMAN merge backup failed with:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/02/2008 12:11:17
ORA-19870: error reading backup piece /gstcon/backup/GSTCON_20180702_64632.rman
ORA-19625: error identifying file /gstcon/backup/GSTCON_20180629_64168.rman
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3


--Looks like some one deleted some of the backup files. What do i need to do to have a proper backup? Do i need to run a incremental backup followed by a merge backup? or do i need to take a full backup?

Thanks

Report message to a moderator

Re: RMAN backup failed [message #331490 is a reply to message #331488] Thu, 03 July 2008 10:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above


>HPUX-ia64 Error: 2: No such file or directory
>Additional information: 3
These are Operating System errors & have NOTHING to do with Oracle directly.
I'd suspect a file permissions problem.
Talk to the Unix SA

Report message to a moderator

Re: RMAN backup failed [message #331491 is a reply to message #331488] Thu, 03 July 2008 10:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> --Looks like some one deleted some of the backup files
You tell us.
If you are guessing, what are we supposed to respond?
If the files are NOT missing, it could be a permissions issue.

Report message to a moderator

Re: RMAN backup failed [message #331492 is a reply to message #331491] Thu, 03 July 2008 10:39 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
My question is do i need to take a incremental backup and then merge backup to have a safe backup or do i need to take a full backup?

Report message to a moderator

Re: RMAN backup failed [message #331493 is a reply to message #331488] Thu, 03 July 2008 10:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>My question is do i need to take a incremental backup and then merge backup to have a safe backup or do i need to take a full backup?
Yes

Report message to a moderator

Re: RMAN backup failed [message #331525 is a reply to message #331488] Thu, 03 July 2008 14:55 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
you mean full backup? or incremental backup?

Report message to a moderator

Re: RMAN backup failed [message #331529 is a reply to message #331488] Thu, 03 July 2008 15:29 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Do both. You can never have too many backups!

Report message to a moderator

Previous Topic: Archive log
Next Topic: privileges in using RMAN
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 13:23:28 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.