OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » restore database

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

restore database [message #503113]

Wed, 13 April 2011 01:40

soru05
Messages: 21
Registered: April 2011
Location: india

Junior Member

dear sir/mam,

I am new in oracle. I want to restore my database in oracle 10g enterprise. Actually i have a backup file(.bkp file) from oracle 10g xe and now i wanna restore in oracle 10g enterprise. so please help me.

with regards,
saurabh

[Updated on: Wed, 13 April 2011 01:43]

Report message to a moderator

Re: restore database [message #503116 is a reply to message #503113]

Wed, 13 April 2011 02:08

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What is contained in your .BKP file?

Report message to a moderator

Re: restore database [message #503125 is a reply to message #503116]

Wed, 13 April 2011 02:24

soru05
Messages: 21
Registered: April 2011
Location: india

Junior Member

All the backup of my oracle xe database. Sir right now i uninstalled oracle xe and i have oracle 10g enterprise. Can i restore .BKP file in oracle 10g enterprise?

Report message to a moderator

Re: restore database [message #503134 is a reply to message #503125]

Wed, 13 April 2011 02:46

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why don't you just try it?
And then post what you do and get if you have any problem.

Regards
Michel

Report message to a moderator

Re: restore database [message #503138 is a reply to message #503134]

Wed, 13 April 2011 02:54

soru05
Messages: 21
Registered: April 2011
Location: india

Junior Member

sir i tried restore command but i have some error.

RMAN> restore controlfile from 'D:\export\O1_MF_NNNDF_TAG20110411T121549_6T58WZ0
0_.BKP';

Starting restore at 13-APR-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/13/2011 13:12:51
ORA-19697: standby control file not found in backup set

Report message to a moderator

Re: restore database [message #503139 is a reply to message #503138]

Wed, 13 April 2011 03:03

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1) Post the whole RMAN session including the connection strings (remove the passwords)
2) The control file is not in this backup

Regards
Michel

Report message to a moderator

Previous Topic:	Recovery Catalog
Next Topic:	Control files dropped

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:03:38 CDT 2024