Description:- Oracle Flashback Technology provides a set of features that support viewing and rewinding data back and forth in time. The flashback features offer the capability to query past versions…
Read MoreDescription:- Partitioning is powerful functionality that allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer…
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 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:- 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 MoreDescription:- 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 MoreDescription:- RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote…
Read MoreDescription:- If you lost both spfile and pfile of the instance when it is up and running. Suppose you don’t have any type of rman or autobackup also. How can…
Read More