I got the following error while disabling archivelog mode on a database. SQL> alter database noarchivelog;alter database noarchivelog*ERROR at line 1: ORA-38774: cannot disable media recovery - flashback database is…
Recovery process on a standby database terminated with the following error in the alert log. PR00 (PID:1200024): Managed Standby Recovery starting Real Time Apply2022-12-29T23:12:39.387793+00:00PR00 (PID:1200024): MRP0: Background Media Recovery terminated…
In this article we will demonstrate how to clone a RAC database to a single instance Non ASM database on a new host using RMAN backup from the RAC database.…
I saw these errors in the alert logs after firewall was implemented by the network team. MRP process terminated therefore primary database was not in sync with the standby database.…
1. Connect to database [oracle@srv1 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Mar 27 20:56:28 2022 Version 19.8.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights…
Follow the steps below to multiplex the Control File. RAC ASM Environment STEP 1 Connect to any one of the RAC nodes and check the current control file status $…
By default, RMAN stores its repository in the control file during backups. How long this information is kept, is controlled by the parameter CONTROL_FILE_RECORD_KEEP_TIME. This parameter has a range from…
