Standby versus primary database files (10g)
We are having the following situation (occurred couple of days ago). It appears that a few weeks ago someone put two tablespaces into backup mode (alter datafile start backup) and forgot to end it. Everythying was looking great (there were some warning in the rman logfiles, but nobody paid attention to them) until recently when the primary DB was shut down. When tried to restart it couldn't open these two tablespaces because they were very out of sync with the database. We ended up taking them offline to open the rest of the database tablespaces
Now the fix that we are working on is to replace the datafiles in these tablespaces with the corresponding datafiles from the standby DB. Is this reasonable? Are standby datafiles not affected by the primary datafiles being in backup mode? Would it have worked to simply do alter tablespace end backup when starting up the primary DB?