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…
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…
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…