Use the following in the mount stage of your standby database:
SQL> recover standby database;
write "auto" when it asks for archive log files. (Assuming you check the archives transferred from primary to standby locations)
SQL> alter database open read only;
Post the output.




Reply With Quote