0 Comments

Oracle Database Appliance Odacli & Odaadmcli Command reference 0 (0)

Oracle Database Appliance Odacli & Odaadmcli Command reference In this blog, we will demonstrate several different usages of odacli, odaadmcli & virsh commands along with some commands output that can be used to administer and manage your Oracle Database Appliance (ODA) with KVM residing in your ODA. ODACLI: It is used for everyday tasks on […]

 303 Total Views,  9 Views Today

0 Comments

How to Find Database Properties in Oracle 0 (0)

How to Find Database Properties in Oracle In this article, we will prepare a script for How to Find Database Properties in Oracle. Using the view DATABASE_PROPERTIES, we can fetch the default values of the database like the default permanent & temporary tablespace, dictionary endian type, character set, global database name, etc. Execute the below […]

 427 Total Views,  1 Views Today

0 Comments

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle 0 (0)

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle In this article, we are going to prepare a script for RMAN Incremental and differential Level 1 (L1) database backup which includes backup of datafiles (L1), control files, spfile along with archives. RMAN incremental backups back up only datafile blocks that have changed since […]

 1,848 Total Views,  3 Views Today

0 Comments

How to Enable & Disable Block Change Tracking (BCT) in Database Oracle 5 (1)

How to Enable & Disable Block Change Tracking in Database Oracle In this article, we will demonstrate How to Enable & Disable Block Change Tracking in Database Oracle. Block change tracking was introduced in version 10g. Prior to this feature, RMAN had to scan all those blocks which were not changed since the base incremental […]

 1,723 Total Views,  1 Views Today

0 Comments

RMAN Incremental Level 0 Database Backup Scripts in Oracle 0 (0)

RMAN Incremental Level 0 Database Backup Scripts in Oracle In this article, we are going to prepare a script for RMAN Incremental Level 0 (L0) database backup which includes backup of datafiles (L0), control files, spfile along with archives. RMAN incremental backups back up only datafile blocks that have changed since a specified previous backup. You […]

 2,248 Total Views

0 Comments

How to Find all Physicals Files in Multitenant Architecture CDB and PDB DATABASE in Oracle 5 (1)

How to Find all Physicals Files in Multinanent Architecture CDB and PDB DATABASE in Oracle Below is the command, how to find all physical files in Oracle in one short (control files, datafiles & redolog files) in the multitenant architecture CDB and PDB in the database. Option 1: Connect to container database CDB$ROOT and fetch […]

 1,054 Total Views,  5 Views Today

0 Comments

How to Find ROLE Creation Date in Oracle 5 (1)

How to Find Role Creation Date in Oracle In this article, we will prepare an SQL command for How to Find ROLE Creation Date in Oracle. View DBA_ROLES doesn’t have a column for ROLE creation date however we fetch other information about ROLE after creation. To achieve it we use the base table SYS.USER$ of […]

 1,191 Total Views,  1 Views Today

0 Comments

Validate Applied Patches in Database Oracle 19c 5 (1)

Validate Applied Patches in Database Oracle 19c In this article, we are going to demonstrate validate applied patches in Oracle 19c and 12c on both ORACLE HOME & DATABASE using various methods/options including container & pluggable database. Validation becomes important before and after the patch apply. Let’s begin practical. 1. Validation in ORACLE HOME First, […]

 1,791 Total Views,  7 Views Today

4 Comments

How to Grant READ ONLY Access on Schema Using ROLE in Oracle 0 (0)

How to Grant READ ONLY Access on Schema Using ROLE in Oracle This is a very frequent and common request by developers to grant READ ONLY access to specific application schema. To fulfill this request either we can grant SELECT privileges on all tables to requestor which are owned by specific application schema or create […]

 2,772 Total Views,  4 Views Today

0 Comments

RMAN Full Database Backup Scripts in Oracle 5 (2)

RMAN Full Database Backup Scripts in Oracle. In this article, we are going to prepare a script for RMAN full database backup which includes backup of datafiles, control files, spfile along with archives. This RMAN full database script will create a backup in a specified location (local directory) on the database server. Generally, we do […]

 1,573 Total Views,  1 Views Today