Backup and restore example with password encryption in Oracle
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…
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…
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…
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…
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…
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…
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…
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…
Fragmentation is caused in table when we do update, delete operation within the table which make the space available in between the table which lead to fragmentation. The space is…
Enable DDL logging in Oracle can be done in several ways. Enable the parameter ENABLE_DDL_LOGGING in Oracle 12c Enable the audit of the database and enable DDL auditing on objects…