Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Skips unavailable archive logs during recovery via RMAN

427 views
Skip to first unread message

AMIT

unread,
Jan 12, 2004, 12:47:38 PM1/12/04
to
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

unread,
Jan 12, 2004, 12:53:51 PM1/12/04
to


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

unread,
Jan 13, 2004, 11:39:26 AM1/13/04
to
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

<gooid...@nospam.demon.nl> wrote in message news:<cln500dfj601bad4f...@4ax.com>...

Sybrand Bakker

unread,
Jan 13, 2004, 2:40:01 PM1/13/04
to
On 13 Jan 2004 08:39:26 -0800, kuma...@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 to
>store unavailab archive logs during recovery.
>
>Please reply.
>
>Thanks
>AMIT

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.

AMIT

unread,
Jan 14, 2004, 3:09:40 AM1/14/04
to
Hi Sybrand Bakker

Thanks for useful information.

AMit

<gooid...@nospam.demon.nl> wrote in message news:<iai800pbuf6bdvoo1...@4ax.com>...

0 new messages