Oracle : Important Queries for Data Pump

—– Create user for using EXPDP/IMPDP : create user admin identified by PW;grant connect,resource to admin;grant unlimited tablespace to admin;grant create any view to admin;create or replace directory DBA_EXPORT as ‘/u01/app/oracle/admin/cloud12c/dpdump’ grant write on directory DBA_EXPORT to admin;grant EXP_FULL_DATABASE to admin;grant IMP_FULL_DATABASE to admin; —–… Read More

Oracle : Important Queries for RMAN

RMAN Backup Size :  set linesize 300 SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(instance_name, 17) current_instance FROM v$instance; SET TERMOUT ON; PROMPT PROMPT +————————————————————————+ PROMPT | Report : RMAN Status | PROMPT | Instance : &current_instance | PROMPT +————————————————————————+ SET ECHO OFF… Read More