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…

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…

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…

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

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…

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…

Standby : Unnamed file issue

Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185 is unknown - rename to correct file ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185' ORA-01157: cannot identify/lock…