Vidya Bala's Blog

Search My Blog

Add RSS Feed

Monday, November 27, 2006

recover database until cancel and online redo's

on a noarchivelog mode database, recover database until cancel will still prompt for archive logs.
This had me puzzled initially until I looked at the sequence number and realized, the sequence number corresponds to the online redolog (although the recovery command prompted for an archive log). When prompted if the appropriate online redolog is entered the Incomplete recovery will succeed.

1 Comments:

  • i have seen this too and started doing a strings for the SCN in my online redolog location ever since :)

    By Blogger Arunkumar, at 10:51 AM  

Post a Comment

<< Home