OraFAQ Forum: Backup & Recovery » RMAN restore in RAC

Home » RDBMS Server » Backup & Recovery » RMAN restore in RAC

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

RMAN restore in RAC [message #321841]

Wed, 21 May 2008 08:16

supportx2008
Messages: 13
Registered: May 2008

Junior Member

We are running two nodes in Oracle RAC environment and try to use RMAN to do the restore.

Case 1
First, we try to stop both instance using sqlplus
SQLPLUS>shutdown immediate;

Then, we connect using RMAN
RMAN>connect target sys/manager@abc1
and receive error "listener does not currently know of service requested in connect descriptor"

Case 2
We also try to stop one instance in SQLPlus and then use RMAN to connect the other instance. Then, issue shutdown immediate under RMAN. After that, issue startup nomount. It then return "not connected"

Is there anything that I missed ??

Thanks !

Report message to a moderator

Re: RMAN restore in RAC [message #321859 is a reply to message #321841]

Wed, 21 May 2008 10:33

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Do you have abc1 defined in your listener?

Can you connect to abc1 with SQL*Plus?

I'm thinking you need to add a static entry for abc1 into your listener.ora.

Report message to a moderator

Re: RMAN restore in RAC [message #321864 is a reply to message #321841]

Wed, 21 May 2008 10:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> ALTER SYSTEM REGISTER;

Report message to a moderator

Re: RMAN restore in RAC [message #321878 is a reply to message #321841]

Wed, 21 May 2008 12:38

skempins
Messages: 16
Registered: June 2005
Location: Florida

Junior Member

You will also need an instance started in at least a nomount state. RMAN requires a target to connect.

Try this:
host$ export ORACLE_SID=abc1
host$ rman target /
RMAN> startup nomount;

Report message to a moderator

Re: RMAN restore in RAC [message #321915 is a reply to message #321878]

Wed, 21 May 2008 16:08

ebrian
Messages: 2794
Registered: April 2006

Senior Member

skempins wrote on Wed, 21 May 2008 13:38

You will also need an instance started in at least a nomount state. RMAN requires a target to connect.

Try this:
host$ export ORACLE_SID=abc1
host$ rman target /
RMAN> startup nomount;

You are already connected with "rman target /" regardless of state of instance.

$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed May 21 15:46:59 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database (not started)

RMAN>

Report message to a moderator

Re: RMAN restore in RAC [message #321917 is a reply to message #321864]

Wed, 21 May 2008 16:20

ebrian
Messages: 2794
Registered: April 2006

Senior Member

anacedent wrote on Wed, 21 May 2008 11:44

SQL> ALTER SYSTEM REGISTER;

Problem is OP is shutting down the database and it is un-registering itself from the listener. They won't be able to register unless they can at least startup nomount.

[Updated on: Wed, 21 May 2008 16:20]

Report message to a moderator

Previous Topic:	EM Backup problem
Next Topic:	RMAN Confusion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 00:00:18 CDT 2024