Question in DBID

[nagendra]

I clone (cold) a database "X" with a diff name "Y" by using the re-create control file.
CREATE CONTROLFILE SET DATABASE "Y" RESETLOGS ARCHIVELOG
and then open the database resetlogs.

1) At this time, is the DBID for X and Y the same ?
2) I use the DBNEWID for "Y" and change the DBID, but in my alertlog I see error like
ORA-00367: checksum error in log file header
ORA-00305: log 5 of thread 1 inconsistent; belongs to another database


What is the issue here and how can I fix it ?

Thanks
Nagendra

[LKBrwn_DBA]

Did you open the database with RESETLOGS?

[nagendra]

Yes, I opened the database with RESETLOGS.

-Nagendra

[LKBrwn_DBA]

Did you shutdown and restart db with modified init.ora?

[nagendra]

Yes the DB was shutdown and re-started the the new name.

-Nagendra

[hrishy]

Hi

When you used the cold clone did you copy over the redologs as well ?

regards
Hrishy

[nagendra]

Yes, redolog files were also copied. FYI, I was able to create the controlfile and open the database resetlogs successfully.

-Nagendra

[LKBrwn_DBA]

Yes, redolog files were also copied. FYI, I was able to create the controlfile and open the database resetlogs successfully.

-Nagendra

Does this mean the problem is fixed?

If not, I recommend you start from the begining without the create controlfile part for renaming the database (maybe only to rename the files).

Then use the nid (DBNEWID) utility to change BOTH the db name and dbid.

Good luck!