Re: Rename a datebase!

From: WiDe <wdelamore_at_home.nl>
Date: 2000/08/10
Message-ID: <dJFk5.23541$dr.193385_at_news1.zwoll1.ov.nl.home.com>#1/1

Hi

Sometimes I use this method (Oracle734 running on unix) :

• DO NOT FORGET ! Before you start: Make a good backup of the database !
• Check if your ORACLE_SID is right !
• start Server manager
• SVRMGR> connect internal
• SVRMGR> alter database backup controlfile to trace ;
• edit the just created tracefile in USER_DUMP_DEST till you get something like this (so delete everything else) and save as a sql script:

STARTUP NOMOUNT CREATE CONTROLFILE SET DATABASE "<NEW DB NAME>" RESETLOGS NOARCHIVELOG

       MAXLOGFILES <VALUE>
       MAXLOGMEMBERS <VALUE>
       MAXDATAFILES <VALUE>
       MAXINSTANCES <VALUE>
       MAXLOGHISTORY <VALUE>
   LOGFILE
     GROUP 1 '<LOGFILE>'  SIZE <SIZE>,
     GROUP 2 '<LOGFILE>'  SIZE <SIZE>,
     GROUP 3 '<LOGFILE>'  SIZE <SIZE>
     DATAFILE
     '<DATAFILE>' SIZE <SIZE>,
     '<DATAFILE>' SIZE <SIZE>,
     '<DATAFILE>' SIZE <SIZE>,
     '<DATAFILE>' SIZE <SIZE>
     ;
   # Recovery is required if any of the datafiles are restored backups,
   # or if the last shutdown was not normal or immediate.

   #RECOVER DATABASE
   # Database can now be opened normally.    ALTER DATABASE OPEN RESETLOGS;

• shutdown database
• where necessary edit its init.ora and/or config.ora
• delete or rename old control files
• again start Server manager and connect internal
• SVRMGR>_at_<RENAME_SCRIPT>.sql

This should do it

William,

Atb.

Leonid Grinchak <leonidgrinchak_at_freemail.ru> schreef in berichtnieuws 965903089.665829_at_iq...

> Hi All!
> I need to rename a database.
> How do it whithout Oracle technical support.
> Best regards
> Leon.
>
>

Received on Thu Aug 10 2000 - 00:00:00 CEST