Database Software

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...