ORA – 19809 & ORA – 19804
DESCRIPTION: In this article, we are going to see how to resolve ORA – 19809 & ORA – 19804. CAUSE: By default RMAN backup goes to Flash Recovery Area if…
Read MoreORA-02019: CONNECTION DESCRIPTION FOR REMOTE DATABASE NOT FOUND.
DESCRIPTION: In this blog,we are going to know about how to overcome ORA-02019 error in database. CAUSE: An attempt was made to connect or log in to a remote database…
Read MoreRESTORE DROPPED TABLES FROM RECYCLE BIN
DESCRIPTION: In this blog,we are going to see how to restore dropped table from recyclebin. Oracle database has the recycle bin which is a data dictionary table and contains information…
Read MoreTransportable Tablespace using RMAN
DESCRIPTION: In this article, we are going to know how to perform Transportable tablespace using Rman. [oracle@trichy BIJU1]$ rman target / Recovery Manager: Release 12.2.0.1.0 - Production on Mon Jan…
Read MoreRestore control file without backup
DESCRIPTION: In this article we are going to see how to Restore control file without backup. Step 1 – Start the instance [oracle@trichydoyen ~]$ export ORACLE_SID=BIJU1 [oracle@trichydoyen ~]$ sqlplus /…
Read MoreCreating A Multitenant Database in Oracle 19c using DBCA.
Description:- In this Blog,we are going to Creating A MultiTenant Database In Oracle 19c. The primary database that contains multiple plugged-in databases. Many operations can be performed at the container…
Read MoreCreating container database in Oracle 12c using DBCA.
Description: In this blog, we are going to know about how to create container database in Oracle 12c using DBCA method. Creating a multitenant container database has many uses and…
Read MoreORACLE DATABASE CRITICAL PATCH – JANUARY 2021
Description: In this article we are going to see Oracle12c Critical Patch Update for January 2021 High Level steps for applying the Patch: Check current version of Opatch Tool Upgrade…
Read More