OraFAQ Forum: Backup & Recovery » Restore controlfile problem

Home » RDBMS Server » Backup & Recovery » Restore controlfile problem (Oracle 10.2.0.3)

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

Restore controlfile problem [message #393455]

Sun, 22 March 2009 23:31

rumman
Messages: 48
Registered: June 2007
Location: Bangladesh

Member

Hi all,

When I tried to restore from RMAN tape backupset I found the following error:

RMAN> restore controlfile;

channel ORA_SBT_TAPE_1: starting datafile backupset restore
channel ORA_SBT_TAPE_1: restoring control file
channel ORA_SBT_TAPE_1: reading from backup piece c-613196953-20090315-00
ORA-19864: Piece c-613196953-20090315-00 had no data
failover to previous backup

channel ORA_SBT_TAPE_1: starting datafile backupset restore
channel ORA_SBT_TAPE_1: restoring control file
channel ORA_SBT_TAPE_1: reading from backup piece ora_dPBLPROD_T20090315_264_1.bak
ORA-19864: Piece ora_dPBLPROD_T20090315_264_1.bak had no data
failover to previous backup

But the backup of control files exists in tape.
Could anyone please tell me what the problem is?

Report message to a moderator

Re: Restore controlfile problem [message #393456 is a reply to message #393455]

Sun, 22 March 2009 23:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>But the backup of control files exists in tape.
RMAN does not agree
>Could anyone please tell me what the problem is?
ORA-19864: Piece ora_dPBLPROD_T20090315_264_1.bak had no data

Report message to a moderator

Re: Restore controlfile problem [message #393457 is a reply to message #393456]

Sun, 22 March 2009 23:50

rumman
Messages: 48
Registered: June 2007
Location: Bangladesh

Member

>But the backup of control files exists in tape.
RMAN does not agree
>Could anyone please tell me what the problem is?
ORA-19864: Piece ora_dPBLPROD_T20090315_264_1.bak had no data

Why does RMAN does not agree?

Report message to a moderator

Re: Restore controlfile problem [message #393460 is a reply to message #393455]

Sun, 22 March 2009 23:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You have provided no factual evidence that "But the backup of control files exists in tape.".
You have only proclaimed it to be true.
If I have to pick which knows reality, I pick RMAN over rookie!

Report message to a moderator

Re: Restore controlfile problem [message #393511 is a reply to message #393460]

Mon, 23 March 2009 03:06

rumman
Messages: 48
Registered: June 2007
Location: Bangladesh

Member

Hey,

You must remember that orafaq forum is not a fun space. So without facing any problem, people do not write here.

I am facing a problem and I know that the data exists in tape and I required any suggestion from people who faced this kind of problem.

Please if you don't know the solution you don't need to answer anything.

Report message to a moderator

Re: Restore controlfile problem [message #393536 is a reply to message #393511]

Mon, 23 March 2009 04:27

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Ofcourse.

>>You must remember that orafaq forum is not a fun space. So without facing any problem, people do not write here.

>>But the backup of control files exists in tape.

Yes. I agree; How we come to know backup exists or NOT. If it's exists you may post the backup details. Right? (For our confirmation)

According your error message. Metalink document 5870989.8

Babu

Report message to a moderator

Re: Restore controlfile problem [message #393589 is a reply to message #393455]

Mon, 23 March 2009 08:12

ocmPravin
Messages: 1
Registered: March 2009
Location: INDIA

Junior Member

yes.. you may need to look at the article 5870989.8 .. It can be a bug

Report message to a moderator

Re: Restore controlfile problem [message #393911 is a reply to message #393455]

Tue, 24 March 2009 20:58

alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com

Senior Member

Hi,

you can run crosscheck before restore.

rman> crosscheck backup of controlfile;

Rman will let you know which backup piece is good, then you can use that backup piece to restore.

Regards,
Alex

[Updated on: Wed, 25 March 2009 02:07] by Moderator

Report message to a moderator

Re: Restore controlfile problem [message #393958 is a reply to message #393455]

Wed, 25 March 2009 03:37

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Hi,

run the following command:-
=========================
rman> restore controlfile from '<PATH>;

Please let me know it working or not.

Pokhraj

Report message to a moderator

Re: Restore controlfile problem [message #394642 is a reply to message #393455]

Sun, 29 March 2009 02:58

rumman
Messages: 48
Registered: June 2007
Location: Bangladesh

Member

Hi,

At last I successfully restored my data. The following command was required:

RMAN> restore controlfile from tag '<tag_name>'

There is a bug in Oracle 10.2.0.3 from metalink and it does not support any other "restore controlfile" command except the above one.

Report message to a moderator

Previous Topic:	Rman not backing up Archivelog
Next Topic:	rollforward issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 07:39:17 CST 2024