Oracle Database Cloning
DESCRIPTION: In this blog,we are going to learn Oracle Database Cloning. INTRODUCTION: The cloning operation creates a copy of the database data files, and creates new online redo log files…
Read MoreRECOVER THE LOST DATAFILE USNIG FLASHBACK SCN CONCEPT
RECOVER THE LOST DATAFILE USNIG FLASHBACK SCN CONCEPT In this blog we are going to learn about how to recover the lost data file by using flashback database in SCN method You can restore any lost or dropped datafile with flashback and rman after a tablespace is dropped. First of all, create a tablespace, user a table and insert data as your wish. CONNECT TO THE DATABASE AND…
Read MoreBackup 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 MoreEXPORT 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 MoreORA-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 MoreORA – 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 MorePerforming 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 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 More