OraFAQ Forum: Backup & Recovery » Restore problem with RMAN (merged)

Home » RDBMS Server » Backup & Recovery » Restore problem with RMAN (merged)

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

Restore problem with RMAN (merged) [message #383543]

Thu, 29 January 2009 02:33

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)

Report message to a moderator

Re: Restore problem with RMAN (merged) [message #383549 is a reply to message #383543]

Thu, 29 January 2009 02:43

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: Restore problem with RMAN (merged) [message #383628 is a reply to message #383543]

Thu, 29 January 2009 06:31

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator

Re: Restore problem with RMAN (merged) [message #383706 is a reply to message #383628]

Thu, 29 January 2009 18:12

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

Report message to a moderator

Re: Restore problem with RMAN (merged) [message #383715 is a reply to message #383706]

Thu, 29 January 2009 19:35

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Previous Topic:	Restore error RMAN-03015,RMAN-06026,RMAN-06023
Next Topic:	backup optimization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 01:29:12 CDT 2024