Flashback Database
Flashback Drop: Recovering the table for the recycle bin, once a table is dropped it will be stored in recycle bin.Hence recovering the table from recycle bin. To perform flashback…
Read MoreCLOUD INSTANCE RESOPONSE FILE AND SILENT DB
CREATING A 12C DATABASE IN CLOUD INSTANCE: Create a instance in oracle cloud account Download the oracle 12c software using wget Edit the response file with ORACLE_HOME, ORACLE_BASE and groups…
Read MoreOracle 19c Database Upgrade From 12.2.0.1.0 to 19.3.0.0 Using Manual Method
Oracle 19c Database Upgrade DETAILS SOURCE TARGET OS_VERSION OEL 6.4 OEL 6.4 DB_VERSION 12.2.0.1 19.3.0.0 DB_NAME PROD PROD ORACLE_HOME /u01/app/oracle/product/12.2.0.1/db_1 /u01/app/oracle/product/19.0.0/dbhome_1 INSTALL THE 19C BINARIES CREATE THE REQIRED DIRECTORIES &…
Read MoreInstallation and Configuration of Oracle Application Express with Oracle REST Data Services and Apache Tomcat
Installation and Configuration of Oracle Application Express with Oracle REST Data Services and Apache Tomcat Installed Softwares (requirement may vary) Oracle Application Express 5.1.4 Apache Tomcat 7.0.96 Oracle Rest Data Service ORDS…
Read MoreOEM 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 MoreSnapshot 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 MoreLogical 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 MoreRedo 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 MoreDatabase 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 MoreOracle 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