Re: Restoring & recovering in NOARCHIVELOG

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in news:E2F6A70FE45242488C865C3BC1245DA703F48055_at_lnewton.leeds.lfs.co.uk :

> Taking on board the comments from you and Tanel, I set up a small
> database and tested it out. Provided I only recover one or more of
> the datafiles (ie keep the current control and log files) I can
> indeed recover work done since the backup was taken.

I think you were possibly confusing the fact that if you were to lose the media were the logs reside, then you have to resort to the last full backup??? This is why they're plex'd and copied to other disks, to other machines, to the moon and more ...

-- 
Pablo Sanchez, Blueoak Database Engineering
http://www.blueoakdb.com