Posted inOracle

Recover Block Corruption

What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. The block may have contents that are not internally consistent, or it…
No Comments
Posted inOracle SQL

ROWNUM Pseudocolumn

The ROW_NUMBER built-in SQL function provides superior support for ordering the results of a query. ROW_NUMBER is an analytic function. It assigns a unique number to each row to which…
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 RAC

Relocating enabl database for oracle 19c

Relocating enabl database for oracle 19c 1:- After the upgrade add this hosting members as below $GRID_HOME/bin/crsctl modify resource ora.enabl.db -attr "HOSTING_MEMBERS='server01 server02' PLACEMENT='favored'" -unsupported 2:- Create directories as show…
No Comments