Recover from backup (obsolete) with nocatalog

[dharma]

Hi,

I have rman running with nocatalog, and we take weekly copies of backup for atleast 6 months. but say if rman removes obsolete copies from the control file, How do I restore to a old backup set because the control file doesnt have any information on the backup set.
Is it possible to set some time and specify the backup set to recover?

Note: Uses control file because I am in nocatalog.

Thanks,
-dharma

[julian]

Originally posted by dharma
Hi,

I have rman running with nocatalog, and we take weekly copies of backup for atleast 6 months. but say if rman removes obsolete copies from the control file, How do I restore to a old backup set because the control file doesnt have any information on the backup set.
Is it possible to set some time and specify the backup set to recover?

Note: Uses control file because I am in nocatalog.

Thanks,
-dharma

Set the init.ora parameter CONTROL_FILE_RECORD_KEEP_TIME to 183 (half a year).

It is an "alter system" parameter.

But why don't you use a catalog database?

[dharma]

Thanks julian, I will try. The company doesnt want to spend $$$ and I have to settle for a nocatalog.

Thanks,
-dharma

[BV1963]

What do money have to do with recovery catalog? It is a small database, possibly about 100 Mb which idles most of the time.

[dharma]

That means I will have to create the catalog in the same instance I am running..which conflict with oracles reccomendation that it be created in a different instance.
-dharma

[julian]

Put in into a small NT/2000 1 CPU machine. That's not much €€€ :-)