-
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
-
Resetlogs
Did you open the database with RESETLOGS?
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Yes, I opened the database with RESETLOGS.
-Nagendra
-
init.ora
Did you shutdown and restart db with modified init.ora?
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Yes the DB was shutdown and re-started the the new name.
-Nagendra
-
Hi
When you used the cold clone did you copy over the redologs as well ?
regards
Hrishy
-
Yes, redolog files were also copied. FYI, I was able to create the controlfile and open the database resetlogs successfully.
-Nagendra
-
Problem is fixed?
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!
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|