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
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: 25042
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


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: 10672
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.
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?
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: 25042
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
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?
Re: RMAN backup failed [message #331529 is a reply to message #331488] Thu, 03 July 2008 15:29 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Do both. You can never have too many backups!
Previous Topic: Archive log
Next Topic: privileges in using RMAN
Goto Forum:
  


Current Time: Wed Dec 07 04:59:56 CST 2016

Total time taken to generate the page: 0.06241 seconds