Error in switch logfile between Primary DB and Secondary DB
Hi,
My database version is- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production.
I have to switch archive log file between primary DB and standby DB, earlier it was switch between both DB but recently it has stopped.
I have used command in Primary DB - SQL> Alter system switch logfile;
System altered.
I have used command in secondary DB- SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Received error- ORA-16136: Managed Standby Recovery not active
As per your solution I have used command in standby DB- SELECT status, recovery_mode, dest_name, destination FROM v$archive_dest_status;