Home » RDBMS Server » Backup & Recovery » Restore problem with RMAN (merged)
Restore problem with RMAN (merged) [message #383543] Thu, 29 January 2009 02:33 Go to next message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
Hi guys,

I have problem with Oracle restore.
I have one database. I backed up it. And I want to restore it in itself.

How to do that?
What am I write in target?
Target and restoring database is one, is it okay? Confused
Do you have example of the restoring procedure (restore itself)?

When I executed following command:
rman target sys@testins auxiliary / nocatalog

Displayed messages:

connected to target database: testins (not mounted)
using target database controlfile instead of recovery catalog
connected to auxiliary database: testins (not mounted)
Re: Restore problem with RMAN (merged) [message #383549 is a reply to message #383543] Thu, 29 January 2009 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost your question.
If you have any problem, check again the forum BEFORE recreating the topic.

Regards
Michel
Re: Restore problem with RMAN (merged) [message #383628 is a reply to message #383543] Thu, 29 January 2009 06:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/server.101/b10734/rcmrecov.htm

You are confused with restoring a database and using an auxillary database.
How can you be connected to a database that you are about to restore?
Re: Restore problem with RMAN (merged) [message #383706 is a reply to message #383628] Thu, 29 January 2009 18:12 Go to previous messageGo to next message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
Thanks for your reply.

Mahesh Rajendran, you are right. I confused.

1) Backup the database
2) Shutdown database
3) Start up database nomount
4) rman target sys@testins auxiliary / nocatalog

Than I don't know next step. Sad
I will not use the auxillary database.
Exactly, I don't know how to connect rman tool without auxillary database.

Thanks,
Enjgaa
Re: Restore problem with RMAN (merged) [message #383715 is a reply to message #383706] Thu, 29 January 2009 19:35 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Auxillary is for duplication.
You are trying to restore.
Check the URL that is been posted.
Previous Topic: Restore error RMAN-03015,RMAN-06026,RMAN-06023
Next Topic: backup optimization
Goto Forum:
  


Current Time: Fri Dec 09 17:17:21 CST 2016

Total time taken to generate the page: 0.16929 seconds