Home » RDBMS Server » Backup & Recovery » RMAN restore in RAC
RMAN restore in RAC [message #321841] Wed, 21 May 2008 08:16 Go to next message
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 !
Re: RMAN restore in RAC [message #321859 is a reply to message #321841] Wed, 21 May 2008 10:33 Go to previous messageGo to next message
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.
Re: RMAN restore in RAC [message #321864 is a reply to message #321841] Wed, 21 May 2008 10:44 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SQL> ALTER SYSTEM REGISTER;
Re: RMAN restore in RAC [message #321878 is a reply to message #321841] Wed, 21 May 2008 12:38 Go to previous messageGo to next message
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;
Re: RMAN restore in RAC [message #321915 is a reply to message #321878] Wed, 21 May 2008 16:08 Go to previous messageGo to next message
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>

Re: RMAN restore in RAC [message #321917 is a reply to message #321864] Wed, 21 May 2008 16:20 Go to previous message
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:
  


Current Time: Sun Dec 11 06:34:13 CST 2016

Total time taken to generate the page: 0.12364 seconds