Home » RDBMS Server » Backup & Recovery » Restore controlfile problem (Oracle 10.2.0.3)
Restore controlfile problem [message #393455] Sun, 22 March 2009 23:31 Go to next message
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?
Re: Restore controlfile problem [message #393456 is a reply to message #393455] Sun, 22 March 2009 23:42 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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
Re: Restore controlfile problem [message #393457 is a reply to message #393456] Sun, 22 March 2009 23:50 Go to previous messageGo to next message
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?
Re: Restore controlfile problem [message #393460 is a reply to message #393455] Sun, 22 March 2009 23:55 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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!
Re: Restore controlfile problem [message #393511 is a reply to message #393460] Mon, 23 March 2009 03:06 Go to previous messageGo to next message
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.
Re: Restore controlfile problem [message #393536 is a reply to message #393511] Mon, 23 March 2009 04:27 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: Restore controlfile problem [message #393589 is a reply to message #393455] Mon, 23 March 2009 08:12 Go to previous messageGo to next message
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
Re: Restore controlfile problem [message #393911 is a reply to message #393455] Tue, 24 March 2009 20:58 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Restore controlfile problem [message #394642 is a reply to message #393455] Sun, 29 March 2009 02:58 Go to previous message
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.

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


Current Time: Fri Dec 02 20:40:20 CST 2016

Total time taken to generate the page: 0.08460 seconds