renaming a database - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: renaming a database

  1. #11
    Join Date
    Jan 2001
    Posts
    230
    Hi
    Following steps I have received from Jeff Hunter and I tried it (8.0.5). It worked fine for me.


    1. alter system backup controlfile to trace
    2. shutdown database (normal or immediate)
    3. backup database
    4. create new $ORACLE_BASE/admin/$ORACLE_SID directory
    5. copy files from $ORACLE_BASE/admin/old_oracle_sid to
    $ORACLE_BASE/admin/new_oracle_sid
    6. edit init.ora and change any references from old SID to new SID
    7. create orapw file (orapw file=orapwNEW_SID)
    8. edit trace file
    8.1 Get rid of garbage before STARTUP NOMOUNT
    8.2 Change CREATE CONTROLFILE REUSE to CREATE CONTROLFILE
    REUSE SET
    8.3 Comment out RECOVER DATABASE
    8.4 Change ALTER DATABASE OPEN to ALTER DATABASE OPEN
    RESETLOGS
    8.5 Change any references of the old SID to the new SID
    9. svrmgrl
    10. connect internal
    11. @your_trace_file_name_created_in_step_8
    12. shutdown (immediate or normal)
    13. backup database (don't overwrite step #2)
    14. startup database

  2. #12
    Join Date
    Oct 2000
    Posts
    80
    Why reset logs?

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