Error Adding datafile
edited Sep 22, 2010 10:02PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 11 commentsAnswered
Hi Guys,
I have some problem when i want to adding a datafile. When i run this sql syntax:
SQL> ALTER TABLESPACE MCGDATA ADD DATAFILE '/oradata/pritest/datafile/mcgdata14.dbf ' SIZE 5000M AUTOEXTEND OFF;
the datafile was created in my primary database, but it's doesn't created in my standby. After that my standby would not apply the redolog from my primary. This is the error that i get from the alert on my standby:
NOTE: I created the datafile in different location / directory from oldest datafiles. I have analized the directory in spfile on my primary and my standby this is the information about my primary and standby spfile:
I have some problem when i want to adding a datafile. When i run this sql syntax:
SQL> ALTER TABLESPACE MCGDATA ADD DATAFILE '/oradata/pritest/datafile/mcgdata14.dbf ' SIZE 5000M AUTOEXTEND OFF;
the datafile was created in my primary database, but it's doesn't created in my standby. After that my standby would not apply the redolog from my primary. This is the error that i get from the alert on my standby:
NOTE: I created the datafile in different location / directory from oldest datafiles. I have analized the directory in spfile on my primary and my standby this is the information about my primary and standby spfile:
0