I am try to add a datafile into my standby database after add the same datafile to my primary database.
But when i execute the add datafile command on my standby database i am getting the following error
ERROR at line 1:
ORA-01516: nonexistent log file, datafile or tempfile
please guide me
when did you add the datafile in primary database...?
all the archive logs are applied to standby db after creating datafiles in primary???.....if the answer is NOOOO.Please wait...
till get applied are archive log files....when the particular datafile archive is applied it will cry asking need 'BLAWBLAW datafile missing" like that.
at that time ....create datafile...in standby db..by
ALTER DATABASE CREATE DATAFILE 'XXXXXXXXX.DBF' AS 'XXXXXXXXX.DBF';
it will accept and allow you to create.
Till then please sit fingures crossed..
If you use Oracle 9i or later, you can also set STANDBY_PRESERVE_NAMES to true to keep synchronized between PRIMARY DB and STANDBY DB.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
Click Here to Expand Forum to Full Width