Question in DBID

Printable View

06-25-2008, 02:24 PM
nagendra

Question in DBID

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
06-25-2008, 02:36 PM
LKBrwn_DBA

Resetlogs

Did you open the database with RESETLOGS? :p
06-25-2008, 02:40 PM
nagendra

Yes, I opened the database with RESETLOGS.

-Nagendra
06-25-2008, 02:42 PM
LKBrwn_DBA

init.ora

Did you shutdown and restart db with modified init.ora?
:cool:
06-25-2008, 02:43 PM
nagendra

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

-Nagendra
06-25-2008, 03:14 PM
hrishy

Hi

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

regards
Hrishy
06-25-2008, 04:31 PM
nagendra

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

-Nagendra
06-25-2008, 05:03 PM
LKBrwn_DBA

Problem is fixed?

Quote:

Originally Posted by nagendra

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!
:p