Skips unavailable archive logs during recovery via RMAN

[AMIT]

Hi

We have a command in RMAN via which we can skip inaccessible archive
logs during backup.
For Example:
Backup database archivelog all skip inaccessible.

But during recovery is there any command available in RMAN via which
we can skip inaccessible archive files from backup, because in control
file the information is stored about unavailable archivelogs.
I am facing problem during restore the database with archive logs ,it
gave the error on RMAN that Unavailable Archive logs do not restored
from backup.
So for backup point of view we can utilize the above command to skip
all the unavailable archive logs.
How should we skip the unavailable archive logs during recovery.

Thanks

Amit

[Sybrand Bakker]

On 12 Jan 2004 09:47:38 -0800, kumar_929@yahoo.co.uk (AMIT) wrote:
HiWe have a command in RMAN via which we can skip inaccessible archivelogs during backup.For Example:Backup database archivelog all skip inaccessible.But during recovery is there any command available in RMAN via whichwe can skip inaccessible archive files from backup, because in controlfile the information is stored about unavailable archivelogs.I am facing problem during restore the database with archive logs ,itgave the error on RMAN that Unavailable Archive logs do not restoredfrom backup.So for backup point of view we can utilize the above command to skipall the unavailable archive logs.How should we skip the unavailable archive logs during recovery.ThanksAmit


Basically you can't. Think of it: if you want to perform complete
recovery would you consider it a complete recovery if you miss out on
random archive logs.
If you have missing archive logs you can perform *incomplete* recovery
until the first archive log missing, and start repenting you didn't
take measures to back up all the archive logs


--
Sybrand Bakker, Senior Oracle DBA

[AMIT]

Hi Sybrand Bakker,

Could we do that requirement using script.
Is that problem solved by writing a script, which tell Rman not to
store unavailab archive logs during recovery.

Please reply.

Thanks
AMIT











<gooiditweg@nospam.demon.nl> wrote in message news:<cln500dfj601bad4fg5csk0qcqoq9icgig@4ax.com>... On 12 Jan 2004 09:47:38 -0800, kumar_929@yahoo.co.uk (AMIT) wrote:HiWe have a command in RMAN via which we can skip inaccessible archivelogs during backup.For Example:Backup database archivelog all skip inaccessible.But during recovery is there any command available in RMAN via whichwe can skip inaccessible archive files from backup, because in controlfile the information is stored about unavailable archivelogs.I am facing problem during restore the database with archive logs ,itgave the error on RMAN that Unavailable Archive logs do not restoredfrom backup.So for backup point of view we can utilize the above command to skipall the unavailable archive logs.How should we skip the unavailable archive logs during recovery.ThanksAmit Basically you can't. Think of it: if you want to perform complete recovery would you consider it a complete recovery if you miss out on random archive logs. If you have missing archive logs you can perform *incomplete* recovery until the first archive log missing, and start repenting you didn't take measures to back up all the archive logs

[Sybrand Bakker]

On 13 Jan 2004 08:39:26 -0800, kumar_929@yahoo.co.uk (AMIT) wrote:
Hi Sybrand Bakker,Could we do that requirement using script.Is that problem solved by writing a script, which tell Rman not tostore unavailab archive logs during recovery.Please reply.ThanksAMIT

You don't seem to understand me. If you are missing an archivelog
during recovery, you will have a 'hole' in your sequence of
archivelogs. Recovery will not be capable to go beyond that 'hole'.
Period.


--
Sybrand Bakker, Senior Oracle DBA

[AMIT]

Hi Sybrand Bakker

Thanks for useful information.

AMit

<gooiditweg@nospam.demon.nl> wrote in message news:<iai800pbuf6bdvoo1uih0lmttbg5de9kli@4ax.com>... On 13 Jan 2004 08:39:26 -0800, kumar_929@yahoo.co.uk (AMIT) wrote:Hi Sybrand Bakker,Could we do that requirement using script.Is that problem solved by writing a script, which tell Rman not tostore unavailab archive logs during recovery.Please reply.ThanksAMIT You don't seem to understand me. If you are missing an archivelog during recovery, you will have a 'hole' in your sequence of archivelogs. Recovery will not be capable to go beyond that 'hole'. Period.