when do we use the "recover database using backup controlfile until cancel;"
Hi,
Hi Uppal,
This is incomplete recovery or point in time recovery, if you search with incomplete recovery you will come to know the concepts and the requirements and when you actual need to do this. Backup control file is used when you do not want to use the current existing control file or all the control files are lost.
Brief overview of the BR scenarios: