RAC to RAC RMAN clone- learnomate

HOW TO PERFORM RAC TO RAC RMAN CLONE IN 19C ? RAC Database Clone Prestep take source DB backups and transfer it to target RMAN Clone  Post Restore/Clone Steps Prestep take source DB backups and transfer it to target 2. RMAN Clone scenario:(different database name primDB:TEESTDB) CREATE DUMMY PFILE:   3.Post Restore/Clone Steps:(Converting restored standalone […]

                                                                          RAC 19C PATCHING NODE1 winscp latest patch to /u01/patches and unzip and change opatch version on both GH […]

Listeners in RAC        The listener.ora file is the configuration file for a listener. It can include the protocol addresses it is accepting connection requests on, a list of the database and other services it is listening for, and control parameters used by the listener. You can modify the configuration of the listeners used by Oracle Clusterware […]

How to Apply Patch On Oracle 19c Database Release Update 19.15.0.0.220419 using Oracle opatch utility? 0 Get the patch # that you want to download. For this document, I am using the following: Patch# is 33859214 1 Download Patch from Oracle Support. https://support.oracle.com/ for the platform your database is hosted on.   In this case, […]

In this blog , we will try to understand the rac command that will help for rac administration How to find the OCR location? How to find the OLR location? What is GPNP Profile and What it contains? ASM and Clusterware: Which One is Started First?

How to Shutdown and startup RAC Database How to Shutdown and startup Oracle Real Application Clusters Database : Stop Oracle Real Application Clusters 1. Stop Oracle Home LISTENER Listener LISTENER is enabled on node(s): rac1 Listener LISTENER is not running on node(s): rac1 2. Shutdown RAC Database Instances on all nodes Syntax: srvctl stop database […]

Unplugging and Plugging Oracle PDB from One Container to Another To Unplug and Plug in the Pluggable Database database (PDB) from One Container Database (CDB)to another Container Database (CDB), the primary thing is we should be connected to the root CDB and to the PDB. There are also some considerations to be taken care of […]

BACKUP ORACLE DATABASES TO AWS S3 There are different options for backing up Oracle databases to Cloud, but using Oracle Secure Backup module to take backups into AWS S3 is one of the most efficient methods in terms of costs and backup/restore performance. Oracle Secure Backup module must be installed into database Oracle Home. Using […]

Connect to an oracle database using python?   Step-1:download and install Python for 64-bit Windows -go to URL: https://www.python.org/downloads/windows/ -scroll down the list until you see Python 2.7.1 – 2010-11-27 -download Windows x86-64 MSI installer (filename: python-2.7.1.amd64.msi) -go through the installer by accepting all the defaults. The install directory will be C:Python -once the installation […]

ASM on vmware workstation     Prerequisites:- Step 1: Set up Oracle Database Server on VMware Workstation using( OEL) Linux 7.6 OS Platform?   Step 2: Connect to OEL 7.6 server via putty and install the below packages Add below OS groups Add asmdba as secondary group to Oracle user   Create Grid User   Change […]