10 Replies Latest reply: Nov 8, 2012 9:19 AM by User447797-OC RSS

    control files creating twice at each location

    User447797-OC
      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?