DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: why use "using backup controlfile" clause

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    when use backup control file, we should use
    recover database until cancel using backup controlfile.

    what i don't understand is why we need "using backup controlfile" clause?

    is it because each controlfile recorded SCN,
    so by this clause, it tells oracle that the target of recovery
    may go beyond the SCN recorded in controlfile ?
    otherwise , oracle will stop at SCN recorded in controlfile.
    am i right?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    That is correct. It is the way to notify the oracle that I has to start with the scn on the control file and then once it runs out, it has to start applying the new scn to the point you specified.


    Folks please correct me if I'm wrong.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width