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

Read More

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_mothed  Data access method – default is automatic  attach  Attach to rxixting job -default is no  cluster  Start work across cluster- default is yes  compression  Content to export, default is metadata […]

Read More

Oracle and it’s different Versions

Oracle Database Technology – the Oracle  server versioning  Oracle Version2 – first commercial RDBMS Oracle Version3- rewritten in the  C programming language Oracle Version4 – improved query performance Oracle Version5- added a networking stack for client-server computing Oracle Version6-OLTP improvements, Oracle parallel server Oracle Version7- first “Morden” Oracle New security model – roles and privileges. PL/SQL […]

Read More

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

Read More