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 …
Oracle
-
-
Backup&RecoveryOracle
Backup and restore example with password encryption in Oracle
by tuanlpby tuanlpFollowing 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 …
-
OracleTroubleshoot
ORA-16198: Timeout incurred on internal channel during remote archival Dataguard
by tuanlpby tuanlpERROR: 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 …
-
Backup&RecoveryOracle
Scheduled RMAN Backup without password in Script in DBMS Scheduler
by tuanlpby tuanlpRMAN 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 …
-
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 …
-
OracleTroubleshoot
ORA-16857: member disconnected from redo source for longer than specified threshold
by tuanlpby tuanlpParameter 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 …
-
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 …
-
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 …
-
-