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.
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.
posted by Vidya Balasubramanian at
4:29 AM
1 Comments:
i have seen this too and started doing a strings for the SCN in my online redolog location ever since :)
By
Arunkumar, at 10:51 AM
Post a Comment
<< Home