Oracle: Different options in Export and Imports

Different options in Export and Imports   Schema export and import using remap_schemas.   1) create directory dpump as ‘/u02/dpump’; 2) grant read,write on directory dpump to system;

For importing schema :   1) Cretae directory dpump as ‘/u02/DATAPUMP’; 2) grant read,write on directory… Read More

Oracle : Oracle Server Architecture

Oracle Server Architecture   An Oracle server includes an Oracle Instance and an Oracle database. Oracle instance:  An Oracle Instance is a combination of two different sets of components. The first component includes the Memory components. That is nothing but SGA (shared global area or system global area)   The second… Read More

Oracle : DATA MASKING (12c)

DATA MASKING     Every organization maintains the sensitive data regarding their operations. like  personal identifiable data, personal sensitive data or commercially sensitive data. organizations are required to protect their sensitive data falling to the wrong hands. Data can be protect by doing the common stuff… Read More

Oracle : Backup of GI and RDBMS home before patching

Note : Please test below steps in your lower environment before trying in Production   Backup of GI and RDBMS home before patching   As root do it when DB instance/CRS is down  :  

Restore : If any issues and needs to restore… Read More

Oracle : Add ASM Disks to existing Diskgroup (RAC)