Adding datafile to standby database problem?
Posted on 2004-04-13
I am running two 126.96.36.199 databases on win 2k server's. One is the primary and one the standby.
I have recently created a repository for management console on the primary database. Now I know that I also have to create a datafile on the standby database.
After I created the repository on the primary database I did a 'alter database archive log current;'.
On the standby database I did 'recover managed standby database cancel;'
and then 'alter database create datafile 'c:/oracle/oradata/standby/oem_repository.ora' AS 'c:/oracle/oradata/standby/oem_repository.ora';
I get an error 'ORA-01516: nonexistent log file, datafile, tempfile 'c:/oracle/oradata/standby/oem_repository.ora'
Can someone tell me where I am going wrong?