What is Active DataGuard DML Redirection? Active Dataguard DML Redirection feature present in Oracle 19c. In this feature DML(insert/update/delete) operation can performed on Standby Database which redirected to Primary Database …
-
-
OracleTroubleshoot
ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failedWhat is Active DataGuard DML Redirection?
Error: Following error occurred during insert/DML operation on the Standby side of Active Dataguard in Oracle. On Standby Database: [oracle@orcl19c ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production …
-
ERROR: Redo transport problem detected: redo transport to database orcl has the following error: ORA-03111: break received on communication channel Redo transport problem detected: redo transport to database orcl …
-
Following are the things for running the RMAN Backup with Password Protected: Set the configuration of RMAN to use Encryption: — Check the configuration RMAN> Show all; — Set the …
-
RMAN Backup can be scheduled in DBMS SCHEDULER without using password script at Operating system but you have to create credential for Operating system user for that. Following are the …
-
OracleTroubleshoot
ORA-16857: member disconnected from redo source for longer than specified threshold
Parameter used to get this warning error is TransportDisconnectedThreshold Parameter. It value defined in seconds. Default value : 30 seconds, We can also set the parameter to zero value to …
-
Getting following warning in one of the standby server in Dataguard environment: Error: ORA-16853: apply lag has exceeded specified threshold On Oracle ORA ERROR C:\Oracle>oerr ora 16853 16853,0000, “apply lag …
-
In one of the DR system, we are getting the following Warning ORA-16855:transport lag exceeded specific threshold On Oracle check ORA error: ORA-16855 Description: transport lag has exceeded specified threshold …
-
Error ORA-31641: unable to create dump file “C:employee.dmp” ORA-27038: created file already exists C:\windows\system32>expdp directory=dbbackup dumpfile=employee.dmp logfile=employee.log Export: Release 18.0.0.0.0 – Production on Mon Apr 13 09:33:27 2020 Version 18.4.0.0.0 …
-
ENCRYPTION in EXPDP and IMPDP datapump jobs in Oracle During the EXPDP job we can implement more security with dump file. so that other will not able to restore …