Question in DBID
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Question in DBID

  1. #1
    Join Date
    Dec 2006
    Posts
    4

    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

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Talking 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

  3. #3
    Join Date
    Dec 2006
    Posts
    4
    Yes, I opened the database with RESETLOGS.

    -Nagendra

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Talking 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

  5. #5
    Join Date
    Dec 2006
    Posts
    4
    Yes the DB was shutdown and re-started the the new name.

    -Nagendra

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

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

    regards
    Hrishy

  7. #7
    Join Date
    Dec 2006
    Posts
    4
    Yes, redolog files were also copied. FYI, I was able to create the controlfile and open the database resetlogs successfully.

    -Nagendra

  8. #8
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Talking 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!
    "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
  •  



Click Here to Expand Forum to Full Width