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. […]
Monthly Archives: June 2017
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 […]
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 […]
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 […]