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 MoreDescription:- 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 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 MoreDESCRIPTION: 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 MoreDESCRIPTION: 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 MoreDESCRIPTION: 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 MoreDescription:- 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 MoreDESCRIPTION: 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 MoreDESCRIPTION: 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 MoreDescription:- 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