Author's posts
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.
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 …
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: Configure 2 Virtual Machine (VM) for 2 Nodes RAC. Install …
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:
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.
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.
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)
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.
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 …
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.