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

Read More

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

Read More

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

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

Physical Backup(User Managed )

What is a User-managed backup in oracle? User-managed backup is accomplished with whatever operating system facilities happen to be available and SQL*Plus commands. These may be as simple as the copy commands on windows or cp on Unix/Linux.  The significance of archive log mode for the backup technique available is the same for user-managed backup as for server-managed […]

Read More

Physical Backup

What is physical Backup? The operating system saves the database files onto tape or some other media. This is useful to restire the system to an earlier point whenever needed. In its simplest form, a physical backup is the movement of all data from one raw device to another; in the context of file system […]

Read More