Re: Where's that last archive log?

2002-12-19 Thread Hemant K Chitale
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

Where's that last archive log?

2002-12-18 Thread Smith, Ron L.
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