Syed Saad Ali
Syed Saad Ali

Oracle Weblogic Administration

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Oracle ACE Pro

Syed Saad Ali
Syed Saad Ali

Oracle Weblogic Administration

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Oracle ACE Pro

AppsDBA CV Download CV Contact Me

Oracle Database Material

October 6, 2017 Data Guard Vs SAN To SAN Replication
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

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

 No Limitations Limitations Exist

Recovery from human error or corruption

 Easy to detect and can be recovered by replaying logs Replicates block as it is and possible that corrupt blocks gets replicated.
October 6, 2017 Comparison Between Oracle GoldenGate and DataGuard
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

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 supports Heteregenous Data Guard Configurations.                       Example : We can imeplement Oracle Data Guard between Oracle Linux server 6.2 (x86_64)  and Microsoft Windows 2008 Server R2 (x64) Primary Database and Standby Database need not be same.
Database Should be Oracle Database in both Source and Target. Database can be different in Source and Target. Example :Source database can be Oracle and Target database can be MY SQL/MS SQL server.
Database Version Primary Database and Standby Database Should be same. Primary Database and Standby Database need not be same. (Including Database Software).
Replication method Data movement will be in-form of Log Files. It moves Data Transaction wise through Extract and Replicat process from Source to Target, when commits.
Database mode Source: Read write mode
Target:  Recovery Mode / Open Read Only.		 Source: Read write mode
Target:  Read write mode
Replication Type Unidirectional. (Data movement will happen in single direction). Multi-Directional.
Integrated Feature No additional software to install. Oracle Data Guard /Active Data Guard includes in Enterprise Edition. Oracle GoldenGate software to install in Source as well as Target.
License Cost No additional license required for Oracle Data Guard to install. Oracle Active Data Guard is an enterprise option with Oracle Enterprise Edition. Oracle GoldenGate Software Licence required in Source and Target Databases.
Database Edition Source: Oracle Enterprise Edition
Target: Oracle Enterprise Edition.		 Source: Can be Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One
Target:  Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One
October 6, 2017 Generating AWR Reports
Database ScriptsOracle Database Material

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 a specific database instance:

@$ORACLE_HOME/rdbms/admin/awrrpti.sql

 

# To generate an AWR report in an Oracle RAC environment: 

@$ORACLE_HOME/rdbms/admin/awrgrpt.sql

 

#To generate an AWR report on a specific database instance in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgrpti.sql

 

# To generate an AWR report for a particular SQL statement:

@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql

 

# To generate an AWR report for a particular SQL statement on a specified database instance:

@$ORACLE_HOME/rdbms/admin/awrsqrpi.sql

 

#To generate an AWR Compare Periods report:

@$ORACLE_HOME/rdbms/admin/awrddrpt.sql

 

# To generate an AWR Compare Periods report in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgdrpt.sql

 

# To generate an AWR Compare Periods report on a specified database instance:

@$ORACLE_HOME/rdbms/admin/awrddrpi.sql

 

# To generate an AWR Compare Periods report on a specified database instance in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgdrpi.sql

 

# To generate an ASH report:

@$ORACLE_HOME/rdbms/admin/ashrpt.sql

 

# To generate an ASH report on a specified database instance:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

 

# To generate an ASH report in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

 

 

October 6, 2017 Find and Delete Older Files in Linux
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

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 +1500 -exec mv {} /rman/archbkp/ \;

 

List files older than 2hours

find /rman/arch/*.dbf -mmin +120 -exec ls -ltr {} \;

 

Delete files older than 1 day

find /rman/arch/*.dbf -mtime +1 -exec rm {} \;

 

Delete files older than 1 hours

find /rman/arch/*.dbf -mmin +60 -exec rm {} \;

 

 

All Rights Reserved