ORA-01111 name for data file 10 is unknown
Hi,
I created two new tablespaces (11 and 12) with 1 datafile in each of them in my primary database,
I forgot to set the parameter in standby server standby_file_management=AUTO,
the standby server auto create the tablespace 11 with datafile in D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\UNNAMED00010,
although there is no such file 'UNNAMED00010' in D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\.
in the v$tablespace and v$datafile, I can see that the entry had been created in control file in standby server.
Below is the listing of datafile in my standby server,
TS# name
----- --------------------------------------------------------
0 G:\OFSDB\OFS4\ORADATA\OFS4\SYSTEM01.DBF
1 G:\OFSDB\OFS4\ORADATA\OFS4\UNDOTBS01.DBF
2 G:\OFSDB\OFS4\ORADATA\OFS4\SYSAUX01.DBF
4 G:\OFSDB\OFS4\ORADATA\OFS4\USERS01.DBF
6 G:\OFSDB\OFS4\ORADATA\OFS4\DATA_SE.ORA
7 G:\OFSDB\OFS4\ORADATA\OFS4\INDEX_SE
8 G:\OFSDB\OFS4\ORADATA\OFS4\FLOW_1.DBF
9 G:\OFSDB\OFS4\ORADATA\OFS4\CJHIT01.DBF
10 G:\OFSDB\OFS4\ORADATA\OFS4\DBMON_TS.DBF
11 D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\UNNAMED00010
Anyone know how to correct this problem?
Thanks