Hi,
I have a primary 11g RAC db and I'm trying to set up a 11g RAC standby
db. I have ASM and the nodeapps set up on the standby servers.
primary db instances: pridb1, pridb2
primary service name: pridb
standby db instances: stdydb1, stdydb2
standby service name: none
I ran the following rman command to get connected to the target and
auxiliary instances:
rman target sys/syspassword@[EMAIL PROTECTED]
auxiliary sys/syspassword@[EMAIL PROTECTED]
was able to connect to the target db and to the auxiliary (nomount
mode). I then issued the following command:
duplicate target database
for standby
from active database
dorecover
spfile
....
....
....
RMAN backed up the spfile and orapwpridb1 files, etc and then it
errored out when it tried to backup orapwpridb2. Obviously rman could
not find orapwpridb2 file on the pridb1 server. orapwpridb2 file was
on the pridb2 server.
I understand the set up of a single instance standby db but I guess I
do not understand conceptually how this is done in a RAC standby
environment. Is RMAN supposed to backup the second instance,
orapwpridb2 automatically on the pridb2 server and copies the file to
the stdydb2 server or am I supposed to tell RMAN that orapwpridb2 file
resides on pridb2 server.
Am I supposed to use the service name to connect to the target and
auxiliary instances like the following?
rman target sys/syspassword@[EMAIL PROTECTED]
auxiliary sys/syspassword@[EMAIL PROTECTED]
service name is not set up at this time. It's not clear to me
at what point I need to set up the stdydb service name. Probably after
getting the standby db up and running?
thanks.
