Database Blog

OEM Installation on 11g database

OEM installation on oracle 11g database   1)emctl start dbconsole [oracle@sakthi admin]$ emctl start dbconsole The following exception occurred: java.net.UnknownHostException: ol6-112.localdomain: ol6-112.localdomain at java.net.InetAddress.getAllByName0(InetAddress.java:1174) at java.net.InetAddress.getAllByName(InetAddress.java:1101) at java.net.InetAddress.getAllByName(InetAddress.java:1037) at java.net.InetAddress.getByName(InetAddress.java:987)…

Read More

Snapshot Standby Database

STEPS TO CREATE SNAPSHOT STANDBY DATABASE PRIMARY: SQL> select name, open_mode, database_role from v$database; NAME   OPEN_MODE        DATABASE_ROLE ——— ——————– —————- GPROD   READ WRITE        PRIMARY SQL>     STANDBY SQL> select…

Read More

Logical Standby Database

LOGICAL STANDBY PRIMARY SQL> select name, open_mode, database_role from v$database; NAME   OPEN_MODE        DATABASE_ROLE ——— ——————– —————- GPROD   READ WRITE        PRIMARY SQL>   STANDBY SQL> select name, open_mode, database_role from v$database;…

Read More

Redo Transport Attributes required for setting in different protection mode

In this post let us see what attributes we can use under different protection mode. Redo Transport Attributes required for setting different protection mode  1. SYNC, ASYNC , AFFIRM ,…

Read More

Database upgrade 12c to 19c using DBUA

STEPS TO UPGRADE A DATABASE FROM 12C TO 19C   DBUA UPGRADE 12C TO 19C TAKE A RMAN FULL BACKUP. STOPPING THE LISTENER RUN THE PREUPGRADE FIXUPS RUN THE PREUPGARDE…

Read More

Oracle Dataguard Protection modes

Oracle Dataguard Protection modes There are three types of Protection Modes in Oracle Dataguard . Maximum Availability It provides highest level of protection of data without compromising availability of database. In…

Read More

Oracle Dataguard Architecture & Background processes

In this post let us understand the Oracle dataguard Architecture and processes with the help of diagrams. Oracle Dataguard Architecture: how data flows when standby is configured   LNS process…

Read More

RMAN Clonning Active duplication

RMAN CLONNING WITH ACTIVEDUPLICATION: Steps in source database: STEP1:verify whether the database is up with pfile or spfile if started with spfile create a pfile from spfile and transfer the…

Read More

Introduction to Oracle Dataguard

In the following posts we will discuss about  Oracle Dataguard concepts and implementation. Introduction to Oracle Dataguard 1. Oracle Data Guard ensures high availability, data protection,and disaster recovery for enterprise…

Read More

Transportable Database from Linux to Windows

Transportable Database from Linux to Windows Overview : – TDB requires that data files be converted to the target platform format. The data file conversion can occur on either the…

Read More