-
RMAN Utility
What is the advantage of RMAN utility?
-
Clone database using RMAN
How do you clone the database using RMAN software? Give brief steps? When do you use crosscheck command?
-
RMAN Recovery Catalog
How do you install the RMAN recovery catalog?
-
Backup Strategy
What are things which play major role in designing the backup strategy?
-
Global Temporary Table
What is Global temporary table? and what are the benefits of it?
-
What is the function of checkpoint (CKPT)?
The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files and control files of the database.
-
What do Database Buffers contain ?
Database buffers store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk.
-
What is Database Link ?
A database link is a named object that describes a "path" from one database to another.