Re: RMAN incomplete recovery on 8.1.7.0/W2K

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 ); }

run {
allocate channel Canal_U type disk format 'U:\ora_backup\XXXX\b_%u_%s_%p';
allocate channel Canal_O type disk format 'O:\ora_backup\XXXX\b_%u_%s_%p';
allocate channel Canal_Q type disk format 'Q:\ora_backup\XXXX\b_%u_%s_%p';
backup

   ( database include current controlfile ); }

> First of all it looks like a datafile has been added and a resync
> catalog was never executed.

  Yes. Normally the resync is carried out but in this case the failure occured before this could happen. However, we recovered to a point in time before the datafile was added.

> Secondly, there are usually problems during restore when you didn't
> archive the online redolog prior to backing up the archive logs.
  I'm not sure if this occurs or not but given that this was a point-in-time recovery, would this have had any effect?   

> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Jun 17 2003 - 09:24:03 CDT