Re: Duplicate database using OEM

Ronald Rood <devnull_at_ronr.nl> wrote in message news:<0001HW.BBEAC11A000368EDF0305600_at_news.cis.dfn.de>...  

> The target is the database you backup to copy it, or have backed up before.
> The auxiliary database is the clone to produce. It's not that difficult to

Thanks Ron, I just wanted to be sure so I didn't blow away the wrong database. The biggest question I had was which database should be the target of the job. I managed to figure it out but there are some bugs with 8i so it can't be done. They are supposed to be resolved in 9i.

Basically when duplicating a database you have to make sure two environment variables are set. NLS_LANG and NLS_DATE_FORMAT. Since you can't do this in an rman script I was forced to specify to_date in the set until clause. This doesn't work because of a bug.

So for now, i'm just going to call an OS script from an rman job. I don't think this database will make it (decommissioned hopefully) to 9i so its good enough. I'd just prefer to have nothing sitting on the OS other than the IA.

Thanks! Received on Fri Nov 28 2003 - 10:19:59 CST