title: When to use “using backup controlfile” in Oracle
body: <p>I know this is something not new to ask, however, I did not get the satisfactory answer where and where not to use "RECOVER DATABASE USING BACKUP CONTROLFILE" or "RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE".</p>
  
  <p>It will really help if someone can explain with proper examples and scenarios.</p>
  
  <p>Thanks a bunch.</p>