ORA-16826: apply service state is inconsistent with the DelayMins property

ORA-16826: apply service state is inconsistent with the DelayMins property (Doc ID 1608166.1)


DGMGRL> show configuration verbose;

Configuration - orcl1_site

  Protection Mode: MaxPerformance
  Databases:
    orcl1   - Primary database
    dgorcl1 - Physical standby database
      Warning: ORA-16826: apply service state is inconsistent with the DelayMins property     <<<<<<<<<<<<<<<






Solution:



Check on Which node MRP process is running.


SQL>alter database recover managed standby database cancel;
SQL> alter database recover managed standby database using current logfile disconnect; 


 

Comments

Post a Comment

Popular posts from this blog

adop phase=prepare [ERROR] META:18:03:58.800: bad stylesheet: kustrigc (Tested on R12.2.5 by me)

Initializing.     Run Edition context  : /oradev/oracle/r12/uat/fs1/inst/apps/sid_hostname/appl/admin/sid_hostname.xml     Patch edition context: /oradev/oracle/r12/uat/fs2/inst/apps/sid_hostname/appl/admin/sid_hostname.xml     Patch file system free space: 222.29 GB Validating system setup.     Node registry is valid.     [ERROR]     META:18:03:58.800: bad stylesheet: kustrigc     Encountered the above errors when performing database validations.     Resolve the above errors and restart adop. [STATEMENT] Please run adopscanlog utility, using the command "adopscanlog -latest=yes" to get the list of the log files along with snippet of the error message corresponding to each log file. adop exiting with status = 1 (Fail) $ Solution: 1. To find the current version of the adgrants.sql script on the instance, do the following:   a. Source the database environ...
Read more

After cloning - adapcctl.sh: exiting with status 204

After cloning on appsTier, following was error as on source SSO was enabled: Error: applprod@hostname:…1_hostname/admin/scripts$ sh adapcctl.sh start                                                                                            You are running adapcctl.sh version 120.7.12010000.2 Starting OPMN managed Oracle HTTP Server (OHS) instance ... adapcctl.sh: exiting with status 204 In the logfile: 19/07/09 20:35:17 Start process -------- /erp_ndr/app/inst/apps/SID_hostname/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing ht...
Read more

ORA-46697: Keystore password required - create pluggable database pdb1clone from pdb1

  select con_id,name,open_mode from v$pdbs;     CON_ID NAME     OPEN_MODE ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 PDB$SEED     READ ONLY 3 PDB1     READ WRITE SQL> create pluggable database pdb1clone from pdb1; create pluggable database pdb1clone from pdb1 * ERROR at line 1: ORA-46697: Keystore password required. Solution: If  TDE is configured, you have to supply the keystore password  SQL> CREATE PLUGGABLE DATABASE PDB1clone FROM PDB1  KEYSTORE IDENTIFIED BY password;
Read more