Oracle Backup and Recovery Question

9. What is logical backup?
 
  • Logical backup is a process of extracting data in the form of SQL statements, where it is useful to recover in case the objects are lost.
  • The main drawback of using this backup is that MEAN TIME TO RECOVER is high.
 
Your Name Your Email-ID
Your Answer
10. Which tools can you use for full backup?
 
  • You can use either the operating system utilities or the RMAN utility for full backup.
  • However, Oracle recommends the use of RMAN utility.
 
Your Name Your Email-ID
Your Answer
11. What is catalog command?
  Catalog command is used to register different types of information with RMAN’s repository.
 
Your Name Your Email-ID
Your Answer
12. What are time based and change based recoveries?
 
  • Time based and change based recoveries are forms of incomplete recovery.
  • These are used when one knows the time or system change number up to which one wants to recover the database.
 
Your Name Your Email-ID
Your Answer
123456789 Page 3 of 9