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 …

Generating AWR Reports You can generate AWR reports by running SQL scripts, as described below :- # Generating an AWR Report @$ORACLE_HOME/rdbms/admin/awrrpt.sql   # To generate an AWR report on …

RMAN Backup Script for Windows Create Batch file named as rmanbackup.cmd and copy the below given script in that batch file. set oracle_sid=orcl rman target sys/passwd nocatalog cmdfile=’c:\app\rman\rmanbkp.cmd’ log=’c:\app\rman\bkp_log.log’ ————— –rmanbackup.cmd run …

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 …