Database Blog

Backup files through using to create Database in Oracle 12c

Description:- Backup your databases and use the restore and recover features to restore a database to the same or another system or to recover database files.It is important to create…

Read More

EXPORT AND IMPORT DATAPUMP IN REMAP_DATA & REMAP_SCHEMA

EXPORT AND IMPORT DATA PUMP IN REMAP_DATA & REMAP_SCHEMA In this blog we are going to learn about EXPORT AND IMPORT in data pump using remap data and remap schema…

Read More

ORA-01157: CANNOT IDENTIFY/LOCK DATA FILE %S – SEE DBWR TRACE FILE

DESCRIPTION: In this blog,we are going to resolve ORA-01157 error in database. Cause: The background process was either unable to find one of the data files or failed to lock…

Read More

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 More

ORA-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 More

Performing point in time recovery using RMAN

Description:- RMAN database point-in-time recovery (DBPITR) restores the database from RMAN backups. RMAN will be consider all ( required ) backups (full, incremental, transectional) to restore or roll forward to…

Read More

RESTORE 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 More

Transportable 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 More

How to Converting Non CDB to CDB in Oracle 12c

Description:- The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB). DBMS_PDB package permits to generate an XML metadata…

Read More

RMAN Active based Cloning Database using Oracle 12c

Description:- Duplicating from an active database doesn’t require any RMAN backup to be taken from the source database.Active database duplication copies the live target database over the network to the…

Read More