Re: RMAN

For two reasons.

1. I wanted to use the backup to build a new host. The new host has the same directory structure. The backup has all the data files, control file and spfile. I need to decide which archivelogs need to be copied from the original host to the new host.
2. Wanted to estimate how long I need to keep archivelogs in the original host. I take full database backup without archivelogs online every night.

Thanks,

Jenny

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:4jg71113mg8hqq0sutrhvictnhea3ilmtv_at_4ax.com...
> On Wed, 16 Feb 2005 13:41:56 -0600, "Jenny Wang"
> <jennyw_at_housing.tamu.edu> wrote:
>
> >Is there a way to know starting from which archivelog an on-line RMAN
full
> >database backup needs for recovery?
> >
> >I'm using 9.2.0.2 in Windows 2000 Server.
> >
> >Thanks in advance!
> >
> >Jenny
> >
>
> In theory there is, however the essence of RMAN is RMAN automates
> restore and recovery.
> Also, you can't move your archives as that would invalidate your
> catalog.
> Please explain why you think you need this, it seems like you aren't
> using RMAN in the manner it was intended.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed Feb 16 2005 - 22:42:32 CST