Database Administration (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center