-
Oracle Dead Locks
If dead lock happened for 2 applications at a time in a banking sector..how to resolve this issues without forcing any one of the application ..we should not have to stop the transaction...
-
-
RMAN Catalog
What is the use of catalog and no catalog in RMAN?
-
Oracle Catlog & Archive Log
Explain what are Oracle Catlog & Oracle Archive Log ?
-
bdump, cdump & udump
Explain in detail what are bdump, cdump & udump?
-
Remote Backup
What is meant by Remote Backup?
-
Alert log files
What are four errors found in an alert (error) log that can ruin a DBA's appetite and how can you avoid them?
-
RMAN without Catalog
Where RMAN keeps information of backups if you are using RMAN without Catalog?
-
Identify target database
How do you identify what are the all the target databases that are being backed-up with RMAN database?
-
RMAN Backup
How to take backup using RMAN backup, without catalogdb?
-
-
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.