RENAME DATABASE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RENAME DATABASE

  1. #1
    Join Date
    Aug 2001
    Posts
    134

    Arrow

    How i can RENAME a database ?
    Please write step by step.
    Thanx

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    1. Run as internal or sys "ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

    2. You will get a trace file. Edit it so that it has the SET keyword:

    CREATE CONTROLFILE SET DATABASE (new_name_of_the_database) RESETLOGS;

    3. Shutdown immediate.

    4. Make a cold backup.

    5. Remove the existing controlfiles.

    6. Edit init.ora to include db_name = (new_name_of_the_database).

    6. startup nomount pfile=...;

    7. Run the trace file from step 1 in order to create the new control files.

    8. Run ALTER DATABASE OPEN RESETLOGS;

    9. Make full backup.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Cool

    The most detailed step-by-step instructions to do that:
    http://www.dbaclick.com/cgi-bin/ib3/...=161;hl=change

    It explains the recovery operation after the db name renaming.

    Hope that helps,



    --clio_usa
    Senior Oracle DBA

  4. #4
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306

    In this scneario if he has taken cold backup after shutting down the database ,
    he need not restore it right once the opens the database with resetlogs options
    bcoz the idea was just to change the SID_NAME in the init.ora file. right ?

    The backup one has to take is for precautionary purposes.

    --Pravin



    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

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