When trying to start or increase parallel of recover manager on datagauard (MRP):
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; * ERROR at line 1: ORA-01153: an incompatible media recovery is active
I simply happen because there already are a process runnning, let’s check:
SQL> select PROCESS,CLIENT_PROCESS,THREAD#,SEQUENCE#,BLOCK# from v$managed_standby where process = 'MRP0' or client_process='LGWR'; PROCESS CLIENT_P THREAD# SEQUENCE# BLOCK# --------- -------- ---------- ---------- ---------- MRP0 N/A 1 26 0
If you want to change it, it’s just stop it first and then start with the clauses you want:
SQL> alter database recover managed standby database cancel; Database altered. SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; Database altered.
See ya!
Matheus.
Thanks for sharing.. solved my issue
thanks man 😉
Thanks for your simple and helpful answer
Thank you for your report 🙂
It was really helpful!
from 2019.05
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
ERROR at line 1:
ORA-38500: USING CURRENT LOGFILE option not available without standby redo logs