on 9i
Server A Primary LIVE
Server B Physical standby DR
Switched successfully so DB on Server B is now primary and physical standby on server A.
Tried to switch back.
On ServerB:
alter database commit to switchover to standby with session shutdown;
ERROR at line 1:
ORA-16014: log 2 sequence# 7 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/u3/oradata/LIVE/redo02.log'
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE MOUNT STANDBY DATABASE
*
ERROR at line 1:
ORA-01665: controlfile is not a standby controlfile
So now I have a standby on server A and a partial (broken) Primary on server B.
init.ora on Server B:
*.log_archive_dest_1='LOCATION=/u2/oradata/LIVE/archive'
*.standby_archive_dest=/u2/oradata/LIVE/archive
Any ideas?