datafile creation in primary not creating datafile in standby
edited Apr 15, 2015 1:00PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 2 commentsAnswered ✓
Hello,
I created datafile in primary however it's not creating datafile in standby
standby_file_management=auto
It creates a file as unnamed in $ORACLE_HOME/dbs and which can be seen only in v$datafile that too in recover status but if I check in dba_data_files this file is not there.
On primary:
SQL> alter tablespace users add datafile '+DATA_CLD01';
Tablespace altered.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA_CLD01/newdb/system01.dbf
+DATA_CLD01/newdb/sysaux01.dbf
+DATA_CLD01/newdb/undotbs01.dbf
0