Home / Installation/Configurations12c

Installation/Configurations12c

Temporary Tablespace and Datafile Management in Oracle database

Temporary Tablespace and Datafile Management in Oracle database   1.  For Finding temp file and temp tablespace with size SELECT file#,         status,         bytes / 1024 / 1024 “Size_MB”,         name  FROM   v$tempfile;  SELECT file_name,         tablespace_name,         bytes / 1024 / 1024 / 1024,         status  FROM   dba_temp_files;    …

Read More »

Change Date and Time Formats In Oracle Database?

Change Date and Time Formats In Oracle Database? Option 1. If We want to change this format to DD/MONTH/YYYY format. SQL> alter session set nls_date_format=’DD/MONTH/YYYY’; Session altered. SQL> select sysdate …

Read More »

Comparison Between Oracle GoldenGate and DataGuard

Comparison Between Oracle GoldenGate and DataGuard   Technical Points Oracle Dataguard / Active Dataguard Oracle Golden Gate Operating System Primary Database and Standby Database Should be same. (But 11g Onwards …

Read More »

RMAN backup and logical backup With Different User

RMAN backup and logical backup With Different User Step 1: Create the user CREATE USER bkp_user IDENTIFIED BY bkp_user DEFAULT TABLESPACE users TEMPORARY  TABLESPACE temp PROFILE DEFAULT;  GRANT CONNECT TO bkp_user;  GRANT exp_full_database TO bkp_user;  GRANT imp_full_database TO bkp_user;  GRANT recovery_catalog_owner TO bkp_user;  GRANT select_catalog_role TO bkp_user;  GRANT CREATE SESSION TO bkp_user;  Step 2: Connect RMAN with the Above Created User …

Read More »