-
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?
-
Recover Full Database from Cold Backup
Outline the steps for recovering the full database from cold backup?
-
RMAN Backup Time
How RMAN improves backup time?
-
Tape Backup Solutions
What are the various tape backup solutions available in the market?
-
Physical and Logical Backups
What is the difference between physical and logical backups?
-
Hot Backup Cold Backup
What is hot backup and what is cold backup?
-
DBID and Incarnation
What is the significance of incarnation and DBID in the RMAN backups?
-
Hot Backup Pre-requirements
When do you recommend hot backup? What are the pre-reqs?
-
Identify Expired, Active, Obsolete Backups
How do you identify the expired, active, obsolete backups? Which RMAN command you use?
-
RMAN Utility
What is the advantage of RMAN utility?
-
RMAN Backup Information
How do you see information about backups in RMAN?
-
DB Recovery File Dest
What is db_recovery_file_dest ? When do you need to set this value?
-
Obsolete and Expired RMAN backups
What is the difference between obsolete RMAN backups and expired RMAN backups?
-
Online Redo Logs
Outline the steps for recovery with missing online redo logs?
-
Backup Strategy
What are things which play major role in designing the backup strategy?
-
Clone database using RMAN
How do you clone the database using RMAN software? Give brief steps? When do you use crosscheck command?
-
RMAN Block Corruption
How do you identify the block corruption in RMAN database? How do you fix it?
-
Cancel based hot backup recovery
Outline the steps involved in CANCEL based recovery from the full database from hot backup?
-
RMAN with NetBackup, TSM Type Library
What are the steps required to perform in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software?
RMAN Interview Questions
Ans