a2zinterviews

29.	What is catalog command and how it is used?
	Catalog command is used to register different types of information with RMAN's repository.
	Discuss Your Name Your Email-ID Your Answer

30.	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.
	Discuss Your Name Your Email-ID Your Answer

31.	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.
	Discuss Your Name Your Email-ID Your Answer

32.	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
	Discuss Your Name Your Email-ID Your Answer