Posted inOracle Scripts

Profiles

A profile is a collection of attributes that apply to a user.The profile is used to enable a single point of reference for multiple users who share theseattributes.You should assign…
No Comments
Posted inOracle Scripts

RMAN Basic Commands

Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats. RMAN  provides a common interface, via command line and Enterprise…
1
Posted inOracle RAC Scripts

RAC Basic Commands

Check the status of the cluster [oracle@rac1 ~]$ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online…
No Comments
Posted inDataGuard Oracle Scripts

Oracle Dataguard Scripts

1) Information of database (Primary & Standby). SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; 2) To display current status for Physical Standby Database background processes. SQL>…
No Comments
Posted inOracle Scripts SQL

Oratop Utility

Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time for RAC and Standalone DB. oratop utility can be downloaded…
No Comments