Nov 07 2020

Performing Block Media Recovery in Oracle

In most cases, the database marks a block as media corrupt and then writes it to disk when the corruption is first encountered. No subsequent read of the block will be successful until the block is recovered. You can only perform block recovery on blocks that are marked corrupt or fail a corruption check.

Continue reading

Oct 27 2020

Configure and Manage RMAN Recovery Catalog

Recovery Catalog: A set of Oracle tables and views used by RMAN to store RMAN repository information about one or more Oracle databases. RMAN uses this metadata to manage the backup, restore, and recovery of Oracle databases.

Target Database: In an RMAN environment, the database to which you are connected as TARGET. The target database is the database on which you are performing RMAN operations.

Continue reading

Oct 16 2020

Oracle Database 12c R2 (12.2) RAC On Oracle Linux 7

Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. In this article, I will show how to install Oracle RAC (12.2.0.1) on Oracle Enterprise Linux 7.1.

Below high level steps will perform to install/configure Oracle RAC:

Continue reading

Oct 16 2020

How to Show All Privileges for a User in Oracle Database

Sometimes DBA needs to generate the report to provide audit team or management about the users access information on database. In this article, I will show how to get list of access for oracle user.

Query to find all privileges for all users in Database:

Continue reading

Oct 07 2020

Rebuilding Indexes on Oracle Database

Indexing helps to improve performance for databases query. And most of the DBA believe that rebuilding indexes also help to increase the performance and they are rebuilding indexes at a regular period of time.

But most of the cases this is not true and very rare case index rebuild is required or helped on performance.

Continue reading

Oct 06 2020

Manually Upgrade Oracle Database from 11gR2 to 12cR2

This article provides an overview of upgrading an existing non-CDB database from Oracle 11.2.0.4 to Oracle 12.2.0.1. Upgrades can be very complicated, so this is highly recommended to read the oracle provided manual and test thoroughly before considering an upgrade of a production environment.

Continue reading

Oct 04 2020

Manual Upgrades to Non-CDB Oracle Database

This article provides an oracle important documents list for any versions which will help you to upgrade your database to any version.

Upgrade Oracle Database to 12.1:

Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) (Doc ID 1503653.1)

Continue reading

Oct 04 2020

Upgrade Oracle Database from 11gR2 to 12cR2 Using DBUA

This article provides an overview of upgrading an existing non-CDB database from Oracle 11.2.0.4 to Oracle 12.2.0.1. Upgrades can be very complicated, so this is highly recommended to read the oracle provided manual and test thoroughly before considering an upgrade of a production environment.

Continue reading

Oct 02 2020

Oracle Database Upgrade Manually from 12.1 to 19.3

This article provides an overview of upgrading an existing non-CDB database from Oracle 12c to Oracle 19c. Upgrades can be very complicated, so this is highly recommended to read the oracle provided manual and test thoroughly before considering an upgrade of a production environment.

Oracle Database Upgradation Manual – Read More.

Upgrade Path for Oracle Database 19c:

Continue reading

Oct 02 2020

Upgrade Oracle Enterprise Linux (OEL) 6 to OEL 7

In this article, we will discuss how can upgrade Oracle Linux from 6 to 7 on VM. We are planning to upgrade Oracle Database 12.1.0.2 to 19c. Database server’s OS is OEL 6.8 but oracle database 19c is not certified on OEL 6.8. So need to upgrade OS from version 6.8 to 7.6.

Continue reading