Quorum failure group in Oracle ASM

Voting files manage information about node membership. OCR is a system that manages cluster and Oracle Real Application Clusters (Oracle RAC) database configuration information. A quorum failure group is a special type of failure group and disks in these failure groups do not contain user data. A quorum failure group is not considered when determining […]

Read More

File Group in a Flex Disk Group

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In the goal here is to know a bit more about the Flex Disk Group. Let’s see here what a File Group is. In a Flex Disk Group we can separate our databases, be they PDBs, CDBs or non-CDBs, in different File Group. Each […]

Read More

Storing a PDB in a Flex Disk Group

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In this post I board a little more about the Flex Disk Group. In the previous post we had started this subject, if you did not see check there The purpose here is to show how to store a PDB in a Flex Disk Group. In […]

Read More

Tablespace growth in Oracle

— Find Tablespace growth size in number of days. set feed off set pages 1000 lines 180 column “tablespace_name” heading “Tablespace | Name” format a20 select to_char (sp.begin_interval_time,’dd-mm-yyyy’) days, ts.tsname, max(round((tsu.tablespace_size* dt.block_size )/(1024*1024),2) ) cur_size_mb, max(round((tsu.tablespace_usedsize* dt.block_size )/(1024*1024),2)) usedsize_mb from dba_hist_tbspc_space_usage tsu, dba_hist_tablespace_stat ts, dba_hist_snapshot sp, dba_tablespaces dt where tsu.tablespace_id= ts.ts# and tsu.snap_id = sp.snap_id and […]

Read More

Creating a Disk Group with Flex Redundancy

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The goal here is to introduce how to create a disk group with one of the new features of Oracle ASM in version 12.2.0.1, the Flex Redundancy or Flex Disk Group. This new type of Disk Group redundancy in ASM […]

Read More

Monitoring RMAN Backup with QBR tools

The Quest Backup Reporter is a windows client application. It can connect too many databases at a time and reports directly from oracle data dictionary views and RMAN catalog. It does not make any modification to either database as well as RMAN configuration. It is just a read only reporting tools. Quest Backup Reporter tools […]

Read More

Upgrade to Oracle 12.2 with dbupgrade utility

Oracle Database 12c release 1 (12.1) introduced the Parallel Upgrade Utility, catctl.pl. This utility reduces the total amount of time it takes to perform an upgrade by loading the database dictionary in parallel, and by using multiple SQL processes to upgrade the database. Performing parallel upgrades of components enables you to take advantage of your […]

Read More

Configure Data Redaction on Oracle

In previous article we provide the brief introduction about Data Redaction on Oracle. Now in this post, we are going to configure different type of Data Redaction in Oracle 12c. Full Data Redaction Partial Data Redaction Random Data Redaction Data Redaction with REGEXP For the demonstration on this I have a table that holds credit […]

Read More

Oracle Data Redaction

Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by applications. You can redact column data by using one of the following methods: Full redaction. You redact all of the contents of the column data. The redacted value returned to the querying application user depends on the data type of […]

Read More