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

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

Creating diskgroup via asmcmd

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – This article is about creating disk-group via asm cmd. Being an Oracle DBA we have knowledge of ASM. Automatic Storage Management (ASM) is Oracle’s logical volume manager, it uses OMF (Oracle Managed Files) to name and locate the database files. […]

Read More

Applying the first RU for Oracle Grid Infrastructure 12.2.0.1

The first RU (Release Update) for Oracle 12.2 is available on most platforms since July 18, 2017. And of course I started applying the first RU for Oracle Grid 12.2.0.1 as soon as it got released. Download the RU 12.2.0.1.170718 for Linux First of all I downloaded the Database RU 12.2.0.1.170718 Patch 26133434 for Linux […]

Read More

Oracle Data Guard 12cR2 “Multitenant”(Part -3)

I must thank my fellow DBA César Aguilar and Joel Pérez for his publication in Spanish OTN. Continuing with the sequence of Oracle Data Guard 12c articles in “Multitenant” Architecture: PDBs behavior, we will end the series by analyzing what happens in the Data Guard “DG” when we delete and when we do an “unplug” […]

Read More

Oracle Data Guard 12cR2 “Multitenant”(Part -2)

I must thank my fellow DBA César Aguilar and Joel Pérez for his publication in Spanish OTN. In previous article: Oracle Data Guard 12c in “Multitenant” Architecture: Behavior of PDBs (Part I) we observed how the process of configuration Data Guard 12c in multitenant architecture is reduced, simplifying thus habitual tasks of the previous versions […]

Read More

Oracle Data Guard 12cR2 “Multitenant”(Part -1)

I must thank my fellow DBA César Aguilar and Joel Pérez for his publication in Spanish OTN. The following article is part of a series that describes the behavior of “Pluggable databases (PDB)” in a Disaster Recovery and High Availability environment designed with Oracle Data Guard 12c on a base Of Container data, it will […]

Read More

Backup

In the 24/7 working environment, any organization requires database available all time. In business world, there are three type of users (Top Management(C.E.O, Board of Directors etc), Technical user(DBA, Developers etc.)/Non -Technical user(Hr , C.A, Market department etc.), End Users(Customers) )who interact with database any  organization according to their roles and privileges. N number of activity done by them […]

Read More