Oracle Rman Backup and Recovery Interview Questions and Answers - 3
Question: 11
What is cancel based recovery?
Cancel based recovery is a user managed incomplete recovery where a user can apply the UNTIL CANCEL clause to perform recovery until the user manually cancels the recovery process.
The process can be cancelled when the user is sure that no more recovery is possible.
Cancel based recovery is performed when there is a requirement to recover up to a particular archived redo log file.
It allows a user to control the recovery process because the user can provide names of archive log files to be used for recovery.
Cancel based recovery can be performed using the following statement:
SQL> RECOVER DATABASE UNTIL CANCEL
Question: 12
Can you take the backup of log files if the database is running in the ARCHIVELOG mode?
No, you cannot take the backup of log files if the database is running in the ARCHIVELOG mode.
Question: 13
Can you track changes to blocks during hot backup?
Oracle database 11g offers block change tracking feature.
It records the information in block change tracking file.
RMAN uses this information to determine specific blocks to be backed up again without re-scanning the entire datafile.
Question: 14
What is catalog command and how it is used?
Catalog command is used to register different types of information with RMAN’s repository.
Engineering Materials Science MCQ Questions & Answers More
Material Science MCQ Questions Pdf Download More
Dairy Technology MCQ Questions and Answers More
Agricultural Engineering MCQ Questions & Answers Pdf More
Surveying and Levelling Agricultural Engineering MCQ Questions More
Top 100+ Logical Reasoning Test Word Utilization Problems More
Hydro Electric Power Projects in India Gk Questions and Answers More
1000+ Free Aptitude Test Questions and Answers Pdf More
1000+ Logical Puzzles Multiple Choice Questions with Answers More
7000+ Geography Questions and Answers 2024 - 2025 Pdf More