This discussion is archived
5 Replies Latest reply: Jan 6, 2013 9:25 AM by JohnWatson RSS

rac to non rac standby file name convert option

857396 Newbie
Currently Being Moderated
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...

Legend

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