My Oracle Support Banner

Convert From Physical Standby To Logical hangs ALTER DATABASE RECOVER TO LOGICAL STANDBY <logical_db_name> (Doc ID 2481907.1)

Last updated on OCTOBER 14, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

SQL> STARTUP MOUNT EXCLUSIVE;
ORACLE instance started.

Total System Global Area 3,8655E+10 bytes
Fixed Size 29864136 bytes
Variable Size 9395244856 bytes
Database Buffers 2,9125E+10 bytes
Redo Buffers 104349696 bytes
Database mounted.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active


SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY eaistr;

2018-11-30T03:47:48.322671+03:00
ALTER DATABASE RECOVER TO LOGICAL STANDBY eaistr
2018-11-30T03:47:48.326206+03:00
Media Recovery Start: Managed Standby Recovery (eaistr2)
2018-11-30T03:47:48.366801+03:00
Started logmerger process
2018-11-30T03:47:48.431970+03:00
Managed Standby Recovery not using Real Time Apply

Conversion command won't come out and will kept running for hours.

Changes

 Nothing changed recently

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.