Re: Rman80 OracleEE8.0.5 problem

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 27 Mar 2002 05:54:45 +1100
Message-ID: <a7qg7l$ljb$1@lust.ihug.co.nz>

If there are no archives between the O/S backup and the OEM backup, then the O/S backup is useless, and cannot be used (unless they want to do an incomplete recovery, of course, which would take the database back to the time of the O/S backup in its entirety). You can't skip over a gap in the redo stream caused by missing archives.

If you're asking what would you do to make RMAN aware of the existence of prior backups and prior archive backups, then you can sit there issuing 'catalog datafilecopy' and 'catalog archivelog' commands.

Had you done that in this case, RMAN would have been smart enough to realise that the O/S copies were useless without the intervening archives, and would have performed the recovery by restoring from the OEM backup.

Regards
HJR

--
------------------------------------------
Resources for Oracle : www.hjrdba.com
============================


"OlgaS" <olgas_at_port.imtp.ilyichevsk.odessa.ua> wrote in message
news:a7q0j4$1dq5$1_at_News.TM.Odessa.UA...


> They have full backup made by OS tools, then they have backup made by

> Enterprise

> Manager (Full database) and all archived log files since that OEM backup.

> They have no archived logs between OS backup and OEM backup.

> Now they have restored database from OS backup.

> When they run

> rman target internal

> recover database

> .

> they got Database is consistent message

> when they run

> rman target internal nocatalog

> recover database

> .

>

>

>

Received on Tue Mar 26 2002 - 12:54:45 CST