Oracle DBA (12c/19c) Articles and Scripts

OCR (Oracle Cluster Registry) & OLR (Oracle Local Registry) In this section, I am going to cover the details about OCR (Oracle Cluster Registry) and OLR (Oracle Local Registry). Let's go into the topic!!! OCR (Oracle Cluster Registry) OCR will have all the cluster information. If the OCR is loss, the entire cluster will be affected.  OCR is the central repository which stores the metadata, configuration, status of the clusterware resources.OCR is used to maintain application resources and availability.It also stores configuration information for CRS daemons and clusterware managed applications. Below are the information stored in the OCR. Node membership information ex: which nodes are the part of the cluster Software active version Server pools Status/Configuration for the cluster resources such as RAC databases, listeners, instances and services ASM instance and disk groups CRS application resource profiles such as VIP addresses etc.. Database services characteri

Please find below an example for how to migrate a Database to another ser using RMAN BACKUPS and without use OPEN RESETLOGS option. Database: db01 Source Server: srv001 Target Server: srv002 1.) Copy Password File from Source to Target; [oracle@srv001 dbs]$ scp orapwdb01 oracle@srv002:/opt/oracle/product/11.2.0.3/dbhome_1/dbs The authenticity of host ‘srv002 (10.163.3.14)’ can’t be established. RSA key fingerprint is 2f:60:86:4a:3f:7c:16:97:8d:d8:6e:21:f5:27:a5:75. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added ‘srv002,10.163.3.14’ (RSA) to the list of known hosts. oracle@srv002’s password: orapwdb01 100% 1536 1.5KB/s 00:00 2.) Copy init.ora Source to Target [oracle@srv001 dbs]$ sql SQL*Plus: Release 12.1.0.2.0 Production on Fri May 18 14:24:17 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production With the Partitioning, OLAP, Data

In this section, I am going to cover the details about RMAN. Let's go into the topic!!! RMAN RMAN also like a normal backup operation. However, it has own recovery catalog to track the backups taken in the database. The database can be in two formats 1) Archivelog           -->  Once the redo log is full, it will write the                        info  into archive log file. So, we can recover                        the  database in any Point- In-Time 2) Nonarchivelog   -->  Redo log will get overwritten, recovery only                        from the last backup Types of Backup Below are the types of RMAN backup Whole backup     -->  This is full database backup Incremental     -->  This is incremental database backup                 -->  Only changed block from the last incremental Backup                 -->  There are 2 types in incremental backup                 -->  1. Differential Incremental Backup                 -->  2. Cumulative Incremen