This discussion is archived
10 Replies Latest reply: Nov 8, 2012 7:19 AM by user447797 RSS

control files creating twice at each location

user447797 Newbie
Currently Being Moderated
could someone help me on this:

Oracle RDBMS : 11.2.0.2, Host : RHEL 5.6

i have created physical standby with rman using Duplicate from Active database, primary,standby uses OMF files with ASM. I see at the standby site on the DATA1 diskgroup under controlfile directory there are two files as opposed to one. I have 2 files under DATA1 and 2 under DATA2.

I queryed v$controlfile to see which control files it is using:
DATA1/ebstst_sty/controlfile/current.468.789323789, DATA2/ebstst_sty/controlfile/current.467.789323789

In the disk groups there are other two file one in each group which are not used like:
DATA1/ebstst_sty/controlfile/current.465.789323789, DATA2/ebstst_sty/controlfile/current.466.789323789

My duplicate output is like:
contents of Memory Script:
{
sql clone "alter system set control_files =
''+REDO1A/eistst_sby/controlfile/current.539.790167061'', ''+REDO1B/eistst_sby/controlfile/current.538.790167061'' comment=
''Set by RMAN'' scope=spfile";
backup as copy current controlfile for standby auxiliary format '+REDO1A/eistst_sby/controlfile/current.540.790167061';
restore clone controlfile to '+REDO1B/eistst_sby/controlfile/current.539.790167061' from
'+REDO1A/eistst_sby/controlfile/current.540.790167061';
sql clone "alter system set control_files =
''+REDO1A/eistst_sby/controlfile/current.540.790167061'', ''+REDO1B/eistst_sby/controlfile/current.539.790167061'' comment=
''Set by RMAN'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}

And what i figured is, it should be like this in order to avoid that :
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '+REDO1A/eistst_sby/controlfile/current.540.790167061';
restore clone controlfile to '+REDO1B/eistst_sby/controlfile/current.539.790167061' from
'+REDO1A/eistst_sby/controlfile/current.540.790167061';
sql clone "alter system set control_files =
''+REDO1A/eistst_sby/controlfile/current.540.790167061'', ''+REDO1B/eistst_sby/controlfile/current.539.790167061'' comment=
''Set by RMAN'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}

in correct script we are missing
sql clone "alter system set control_files =
''+REDO1A/eistst_sby/controlfile/current.539.790167061'', ''+REDO1B/eistst_sby/controlfile/current.538.790167061'' comment=
''Set by RMAN'' scope=spfile";



1)What do i need to do so that i have only one control file created at each location?
2)For already created control files can i just use asmcmd>rm file_name to remove it or it is not correct way to remove? If so how do i need to remove?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points