Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

change DB_NAME failed with NID-00133: Database should have only consistent.

856156Aug 17 2011 — edited Aug 17 2011
I have created two testing database for active data guard with Oracle 11g on Linux. I created standby DB by using rman backup from primary database. Now I want to change DB_NAME of standby database. I used DBNEWID utility

%> nid TARGET=SYS DBNAME=newname SETNAME=YES

It generated the error like this

NID-00133: Database should have only consistent datafiles
Change of database name failed during validation - database is intact

Many datafiles even system datafiles are not consistent. I shutdown DB and startup mount again and tried again. It all failed with the same errors. I searched solutions on Oracle Support web and other twchincal web and couldn't find
answers. Please help me to get the solutions. Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2011
Added on Aug 17 2011
8 comments
682 views