Re: RMAN incomplete recovery on 8.1.7.0/W2K

From: konsultant_1 - konsultancIT.pl <konsultant_1_at_konsultancIT.pl>
Date: Tue, 17 Jun 2003 17:04:11 +0200
Message-ID: <3EEF2DEB.9020502@konsultancIT.pl>

Anthony Hogan wrote:
> Sybrand,
> Thank you for your reply. My comments are in-line
>
> Regards,
> Anthony Hogan
>
> Sybrand Bakker wrote:
>

>>On Mon, 16 Jun 2003 14:41:45 +0100, Anthony Hogan
>><ahogan-nospam-_at_iespana.es> wrote:
>>
>>
>>>Did I miss something with the restore or is this normal behaviour? I am
>>>rather annoyed with myself for offering advice which would have resulted
>>>in more data loss than necessary.
>>>
>>>Any thoughts??
>>
>>This is definitely not normal behavior, and my gut feeling is your
>>backup script is in error.

>
>
> These are the backup scripts (generated by OEM)
> run {
> allocate channel Canal_U type disk format
> 'U:\ora_backup\XXXX\b_%u_%s_%p';
> allocate channel Canal_Q type disk format
> 'Q:\ora_backup\XXXX\b_%u_%s_%p';
> backup ( archivelog all delete input );
> }

Try to add "alter system archive log current" clause in archivelog script:

run {
sql "alter system archive log current";
....

Thats helps yoo to prevent recovery problem.

-- 

   www.konsultancIT.pl
Oracle&MS-SQL consulting

Received on Tue Jun 17 2003 - 10:04:11 CDT