5 Replies Latest reply: Jan 6, 2013 11:25 AM by JohnWatson RSS

    rac to non rac standby file name convert option

    857396
      Hi,

      Rac to non rac with ASM both, please find the below details.

      Primary Setup.
      ------------------

      diskgroup NAME for all files for both primary and standby +DATA

      pmon,unique and service name at standby-rac1, rac2

      db version -11.2.0.1

      platform - HP -UX

      $ ps -ef | grep pmon
      oracle11 22329 1 0 22:33:55 ? 0:28 ora_pmon_rac1
      oragrid 23522 1 0 Jan 2 ? 1:30 asm_pmon_+ASM1

      $ ps -ef | grep pmon
      oracle11 22329 1 0 22:33:55 ? 0:28 ora_pmon_rac2
      oragrid 23522 1 0 Jan 2 ? 1:30 asm_pmon_+ASM2
      database and Unique name - RAC, so all files on ASM created under +DATA/RAC

      -------------------------

      Stanby setup


      diskgroup NAME for all files for both primary and standby +DATA

      pmon,unique and service name at standby- racdr


      $ ps -ef | grep pmon
      oracle11 22329 1 0 22:33:55 ? 0:28 ora_pmon_racdr
      oragrid 23522 1 0 Jan 2 ? 1:30 asm_pmon_+ASM


      database name and unique name is racdr, so all files on ASM created under DATA/racdr when cloned with RMAN from primary backup. (by settling log_file and db_file covert from DATA/RAC to +DATA/racdr )

      so now everything ok... but how do we create a new datafiles at primary for the above setting success, ??? and reflect on standby ???.

      1.create tablespace tbs size 10g;

      2.create tablespace tbs datafile '+/DATA/RAC/test.dbf size 10g; ??

      3.create tablespace tbs datafile '+/DATA size 10g;???

      4. directories name on asm and specifying on the convert options is case sensitive ???


      Thanks in advance...