Tuesday 3 May 2011

Cloned databases and RMAN (the NID utility)

I ran into an issue with RMAN recently when trying to setup backups for one of our production databases. It kept erroring, saying that it effectively couldn’t reconcile the database name against the DBID. It turned out this was because our test database was in the same recovery catalog and, since it was cloned from production, had the same DBID.

So just in case you weren’t aware, if you’re going to be using RMAN (with a recovery catalog) to backup cloned databases, make sure you renew the DBID of the clone immediately after cloning using the nid utility.

Shutdown the database, startup mount and execute:

nid target=sys/

Cheers,

Ian

No comments:

Post a Comment