Karan Rajpoot Oracle DBA Blog's

In my previous blog, We saw the configuration steps of the data guard setup . In this blog, we will see the configuration of DGMGRL Oracle utility. let's start the configuration. Step 1) First we should check the DB name, DB unique name, open_mode, database_role of both the servers. Primary Server: - SQL>  select name, db_unique_name,open_mode,database_role, flashback_on from v$database; NAME   DB_UNIQUE_NAME OPEN_MODE       DATABASE_ROLE    FLASHBACK_ON --------- ------------------------------ -------------------- ---------------- ------------------ PROD   prod READ WRITE       PRIMARY        YES Standby Server: - SQL> select name, db_unique_name,open_mode,database_role, flashback_on from v$database; NAME   DB_UNIQUE_NAME OPEN_MODE       DATABASE_ROLE    FLASHBACK_ON --------- ------------------------------ -------------------- ----------...

Required Parameters to configure the Dataguard setup:- DB_NAME= It should be the same on the primary and standby side. DB_UNIQUE_NAME= Must be different on the primary and dr side. LOG_ARCHIVE_CONFIG= This parameter includes db_unique_name which is the part of data guard configuration. LOG_ARCHIVE_DEST_n=   It defines the local and remote archive log file location. LOG_ARCHIVE_DEST_STATE_n=  It defines the state of archiving (enable or differ). REMOTE_LOGIN_PASSWORDFILE=  it should be in EXCLUSIVE mode. FAL_SERVER= Use for archive log gap resolution (required only in physical standby server). DB_FILE_NAME_CONVERT=  It is required when directory structure is needed to be in the different datafile. LOG_FILE_NAME_CONVERT=     It is required when directory structure is needed to be in the different logfile. STANDBY_FILE_MANAGEMENT=  It helps to create the file automatically on the standby serve...

                                      Steps to Install Oracle SQL Developer  Step 1) You need to download the SQL developer rpm and java development kit rpm of the version as per your requirement. Links to download rpm's: - Java development kit: -  https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html SQL developer: -  https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Step 2) Login to your Linux Machine and install both the rpm's. [root@dr sf_Oracle_DBA_Softwares]# rpm -ivh sqldeveloper-18.4.0-376.1900.noarch.rpm Preparing...                ########################################### [100%]    1:sqldeveloper           ########################################### [100%] [root@dr sf_Oracle_DBA_Softwares]#...

Introduction: RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, a remote server will a different file structure or the local server with a different file structure.  In this demonstration , I am using the "prod" as a Source database and "clone" as an Auxiliary database. Prerequisites: RMAN must be connected as AUXILIARY to the instance of the duplicate database. The instance of the duplicate database is called the auxiliary instance. The auxiliary instance must be started with the NOMOUNT option. High-Level steps of  RMAN backup based cloning in Oracle 11g Source Server: - 1) The database should be in Archive log mode. 2) Set the recovery parameters. 3) Set the datafile and logfile convert parameter. 4) Create Parameter file (pfile). 5) Take a fresh backup. 6) Create Password fi...