Re: Rman Database Identifier Problem

Choco wrote:
>
> Hi all,
>
> I use Oracle 8.1.7 on AIX.
> I have manually copy database files to create a new one on another server,
> let's say TEST to PROD.
> When I try to register my new PROD database, it used the same DB_ID that the
> TEST one... and rman becomes inusable.
>
> The manual said : use rman duplicate command to copy your DB, but it's too
> late for me because my PROD DB is already online and in use....
>
> Is there an other solution than using a new recovery catalog with a new
> schema name to avoid my problem ?
>
> Thanks in advance.
>
> Choco.

The trick here is to actually use RMAN to duplicate the database (it takes care of generating a new dbid). Unfortunately, to my knowledge there is no facility yet to change a dbid

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."