I must thank my fellow DBA Franky Weber Faust for his publication in Portuguese OTN. Apply the PSU in Standby with RAC database using the standby-first patch apply method. In this article, I introduce how to apply the patch using the standby-first patch apply the method in a DataGuard environment with Oracle RAC 12c, where […]
All posts by Anuradha Mudgal
Oracle Data Guard 12cR2 “Multitenant”(Part -3)
I must thank my fellow DBA César Aguilar and Joel Pérez for his publication in Spanish OTN. Continuing with the sequence of Oracle Data Guard 12c articles in “Multitenant” Architecture: PDBs behavior, we will end the series by analyzing what happens in the Data Guard “DG” when we delete and when we do an “unplug” […]
Oracle Data Guard 12cR2 “Multitenant”(Part -2)
I must thank my fellow DBA César Aguilar and Joel Pérez for his publication in Spanish OTN. In previous article: Oracle Data Guard 12c in “Multitenant” Architecture: Behavior of PDBs (Part I) we observed how the process of configuration Data Guard 12c in multitenant architecture is reduced, simplifying thus habitual tasks of the previous versions […]
Oracle Data Guard 12cR2 “Multitenant”(Part -1)
I must thank my fellow DBA César Aguilar and Joel Pérez for his publication in Spanish OTN. The following article is part of a series that describes the behavior of “Pluggable databases (PDB)” in a Disaster Recovery and High Availability environment designed with Oracle Data Guard 12c on a base Of Container data, it will […]
Archive Redo log
As DBA We all know backups play an important role in business operations but in some case backup also get corporate than we can not make database alive. To solve this kind of issue Oracle recommends us to keep a database in archive log mode. To preserve redo information, create archived copies of redo log files […]
ORA-01031: insufficient privileges(Add) user in group
In this article we are going to learn about the privileges . The ORA-01031: “insufficient privileges” error occurs when you attempt to execute a program or function for which you have not been granted the appropriate privileges. For the DBA, the ORA-01031 can happen if the target OS executable do not have read and execute permissions (e.g. […]
Oracle Import(parameters)
In this article, we are going to learn about the parameters of Import Oracle Datapump. Parameter Description abort_step undocumented feature access_method data access method : default is automatic attach attach to existing job : default is no cluster start workers across cluster: default is y content content to import : default is ALL data_options Import data […]
Oracle Export(parameters)
11g Oracle database’s Export parameters In this article, we are going to learn about the parameters of Export Oracle Datapump. Parameter Explanation abort_step Undocumented feature access_method Data access method – default is automatic attach Attach to exiting job -default is no cluster Start work across cluster- default is yes compression Content to export, default is metadata […]
Oracle and it’s different Versions
Oracle Database Technology – the Oracle server versioning Oracle Version 2 – first commercial RDBMS Oracle Version 3 – rewritten in the C programming language Oracle Version 4 – improved query performance Oracle Version 5 – added a networking stack for client-server computing Oracle Version 6 – OLTP improvements, Oracle parallel server Oracle Version 7 – first “Modern” Oracle New security model […]
Roll Forward Physical Standby Database using RMAN incremental backup
There would be scenarios where the standby database lags far behind from the primary database leading to Archive Gap. It could be due to one of the following reasons 1. Might be due to the network outage between the primary and the standby database leading to the archive gaps. Data guard would be able to detect […]