How to Add and drop Disks to ASM Disk Group in Oracle 12C
I will explain How to Add Disks to ASM Disk Group in Oracle with ALTER DISKGROUP DATA ADD DISK Command in this post. You can add disks to ASM Disk…
Read MoreHow to Use TABLE_EXISTS_ACTION During IMPDP in Oracle Datapump
I will explain How to Use TABLE_EXISTS_ACTION During IMPDP in Oracle Datapump in this post. Table_exists_action: While Import process is running if any table exists in database what will Oracle do…
Read Moreconfigure disk devices using Oracle ASMLIB in Oracle 12C
To manage Oracle database’s storage, Oracle recommends The Automatic Storage Management (ASM) to be used regardless of database’s configuration: single-instance Oracle Database or Oracle Real Application Clusters configurations. It is…
Read MoreHow to Use CONTENT ( DATA_ONLY , METADATA_ONLY ) Parameter in Oracle Datapump
I will explain How to Use CONTENT ( DATA_ONLY , METADATA_ONLY ) Parameter in Oracle Datapump CONTENT: This parameter enables you to filter what is export and import during the…
Read MoreHow to Flashback Database to Guaranteed Restore Point on Oracle 12C
Flashback must be turned on in order to be able to use Guaranteed Restore Point. To enable Flashback, we need to use the FRA parameter like following. SQL> show parameter…
Read MoreRECOVER DATAFILE: ORA-01157: cannot identify/lock data file %s – see DBWR trace file
Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit…
Read MoreRman Performance of Block change Tracking in Oracle 12c
Block Change Tracking : * Block Change Tracking Feature is used to speed up the RMAN incremental backup. *After Enabling this feature the records modified since the last…
Read MoreFlashback Data Archive in Oracle 12C
Flashback Data Archive feature is very much loved by Oracle DBA’s and it is come with Oracle 11g. The purpose of Flashback Data Archive is to store all DML and…
Read MoreDATABASE INCARNATION
In this tutorial we are going to learn about Database incarnation. I have mentioned below about incarnation and its different types of incarnation falls. Then follow below example for how…
Read MoreEXPORT DP AND IMPORT DP IN SCHEMAS PARAMETER USING PARFILE
EXPORT DP AND IMPORT DP IN SCHEMAS PARAMETER USING PARFILE In this tutorial we are going to learn about how to do export and import datapump using schemas parameter DESCRIPTION: A schema export is specified using the schemas parameter. This is the default export mode. If you have the DATAPUMP_EXP_FULL_DATABASE role, then you can specify a list of schemas, optionally including the schema definitions themselves and also system privilege grants to those schemas. If you do not have the DATAPUMP_EXP_FULL_DATABASE role, then you can export only your own schema. The sys schema cannot be used as a source schema for export jobs. [oracle@oracle ~]$ expdp directory=parexp dumpfile=schema.dmp logfile=schema.log schemas=lockdown Export: Release 12.2.0.1.0 – Production on Tue Sep 22 08:08:55 2020 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Username: lockdown/dba1 Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production Starting “LOCKDOWN”.”SYS_EXPORT_SCHEMA_04″: lockdown/******** directory=parexp dumpfile=schema.dmp logfile=schema.log schemas=lockdown Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA…
Read More