Re: Where's that last archive log?

In theory you should always be able to do an Incomplete Recovery [until the latest archive log you have available] provided that no database file was still in backup mode till a point in time after the last archive log.

How do you backup your tablespaces ?
Which archive logs are included in your D.R. backups ? You must have all the archive logs generated till the last END BACKUP command of that database backup set.
Else, you'd have to restore an _OLDER_ backup set and do an incomplete recovery.

Hemant
At 01:46 PM 18-12-02 -0800, you wrote:
>We do disaster recovery tests from time to time with a limited set of
>backups. We make an educated quess as to the time to recover but it doesn't
>always work. If I give Oracle a point in time to recover and then run out
>of archive logs how do I tell Oracle that that's all I have and recover with
>what is available? I have tried recover until cancel but Oracle always
>seems to need another archive log. It usually says the System file needs to
>be recovered. If I have all the archive logs it works fine.
>
>R.Smith
>If you are not the intended recipient of this e-mail message, any use,
>distribution or copying of the message is prohibited. Please let me know
>immediately by return e-mail if you have received this message by mistake,
>then delete the e-mail message. Thank you.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
My web site page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).