OraFAQ Forum: Backup & Recovery » Error ORA - 19870 error while restoring backup piece ...

Home » RDBMS Server » Backup & Recovery » Error ORA - 19870 error while restoring backup piece ...

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

Error ORA - 19870 error while restoring backup piece ... [message #662092]

Mon, 17 April 2017 22:20

chauthm
Messages: 3
Registered: April 2017

Junior Member

Hi everybody,

I tried to create a database on Oracle 11 but got these error message. Pls help me to resolve them Sad

- ORA-19870: error reading backup piece
- ORA-19599: block number 45289 is corrupt in backup piece

Report message to a moderator

Re: Error ORA - 19870 error while restoring backup piece ... [message #662094 is a reply to message #662092]

Mon, 17 April 2017 22:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

[oracle@vbgeneric ~]$ oerr ora 19599
19599, 00000, "block number %s is corrupt in %s %s"
// *Cause: A corrupt block was found in a control file, archived log, or
// backup piece that
// is being read for a backup or copy. Corruption shall not be
// tolerated in control files, archived logs, or backup pieces.
// *Action: None. The copy or backup operation fails. Note that in the case of
// a backup set, the conversation is still active and the piece may
// be retried.
[oracle@vbgeneric ~]$ oerr ora 19870
19870, 00000, "error while restoring backup piece %s"
// *Cause: This error should be followed by other errors indicating
// the cause of the problem.
// *Action: See other errors actions.
[oracle@vbgeneric ~]$

I suspect that you have a corrupt backup.

Report message to a moderator

Re: Error ORA - 19870 error while restoring backup piece ... [message #662095 is a reply to message #662094]

Mon, 17 April 2017 23:21

chauthm
Messages: 3
Registered: April 2017

Junior Member

Thank BlackSwan, these other error displays:
https://drive.google.com/file/d/0B6cQ5TyCugGiZUJidl84cjJWbGM/view?usp=sharing
I searched on many sites but can't resolve this. I also tried to deinstall then reinstall many times Sad

[Edit MC: change image of an url to an actual clickable url]

[Updated on: Tue, 18 April 2017 00:31] by Moderator

Report message to a moderator

Re: Error ORA - 19870 error while restoring backup piece ... [message #662097 is a reply to message #662095]

Tue, 18 April 2017 00:33

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Your backup is corrupted, there is nothing you can do but use another backup.

Report message to a moderator

Re: Error ORA - 19870 error while restoring backup piece ... [message #662101 is a reply to message #662097]

Tue, 18 April 2017 01:39

chauthm
Messages: 3
Registered: April 2017

Junior Member

What should I do to use another backup in this case. Can you explain the details steps

Report message to a moderator

Re: Error ORA - 19870 error while restoring backup piece ... [message #662102 is a reply to message #662101]

Tue, 18 April 2017 01:43

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You use EM or DBCA, I don't use and know them, I can move your topic to our Enterprise Manager forum if you want but I'm not sure it is more appropriate than this one.
Maybe someone else can answer this point.

[Updated on: Tue, 18 April 2017 01:46]

Report message to a moderator

Re: Error ORA - 19870 error while restoring backup piece ... [message #662110 is a reply to message #662095]

Tue, 18 April 2017 03:34

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

chauthm wrote on Tue, 18 April 2017 05:21

Thank BlackSwan, these other error displays:
https://drive.google.com/file/d/0B6cQ5TyCugGiZUJidl84cjJWbGM/view?usp=sharing
I searched on many sites but can't resolve this. I also tried to deinstall then reinstall many times

[Edit MC: change image of an url to an actual clickable url]

You have a damaged template file. You could select a different template when creating the database (fr example, the "custom" template does not rely on any existing files) or you could deinstall and reinstall. You say the tried to deinstall/reinstall ay times, but clearly none if those times actually worked. What went wrong?

Report message to a moderator

Previous Topic:	Oracle Backup with RMAN take a long time
Next Topic:	Manual Hot Backup in Oracle 11gR2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 01:01:10 CST 2025