dbasamad – Page 3

Nov 07 2020

Performing Block Media Recovery in Oracle

By dbasamad in Backup & Recovery, OCM Preparation

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

By dbasamad in Backup & Recovery, OCM Preparation

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

By dbasamad in Oracle Database 12c, RAC & ASM

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

By dbasamad in Scripting

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

By dbasamad in Oracle Core

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

By dbasamad in Oracle Database 11g, Oracle Database 12c, Upgrade and Migration

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

By dbasamad in Upgrade and Migration

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

By dbasamad in Oracle Database 11g, Oracle Database 12c, Upgrade and Migration

Oct 02 2020

Oracle Database Upgrade Manually from 12.1 to 19.3

By dbasamad in Oracle Database 12c, Oracle Database 19c, Upgrade and Migration

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

By dbasamad in Unix

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.

Mohammad Samad

Author's posts