Installation/Configurations11g

Useful Commands For Unix Operating System   1.Deleting files older than N number of days ? find . -name ‘*.trc’ -mtime +[N in days]  -exec rm {} \;   Command will …

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;  2. Add …

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 …

Difference between P-File and SP-File? P-FILE SP-FILE It is called as parameter file. It is called as server parameter file. P-File is ASCII file and it can be edited Manually spfile is binary file and it …

Oracle Real Application Cluster Intro RAC Defination Oracle RAC stands for Oracle Real Application cluster. It is a clustering solution that ensures high availability of databases by providing instance failover …

Data Guard Vs SAN to SAN Replication   Oracle Data Guard SAN-to-SAN Implementation Cost Low High Database Aware Yes No Granularity of Replication Transaction level Disk Block Level Distance Limitations …

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 it …

Delete Older Files in Linux   Files older than 1 day find /rman/arch/*.dbf -mtime +1 -exec mv {} /rman/archbkp/ \;   Move files older than 25 hours find /rman/arch/*.dbf -mmin …

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 …