Re: renaming a database

No, as I just posted, the problem ended up being that you need a SET in front of the DATABASE clause in create controlfile...

Thanks for your help,
Lee

On Tue, 13 Jun 2000 22:25:23 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
>You did use the reuse clause of the create controlfile?
>Are you by any chance using @ signs (shorthand for ORACLE_SID) in your
>filenames?
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>"Lee" <feigenb_at_is01.fas.harvard.edu> wrote in message
>news:slrn8kd40s.3ib.feigenb_at_is01.fas.harvard.edu...
>> Well, (if anyone's following along), I went ahead and entered the
>> 'CREATE CONTROLFILE..' command from the produced tracefile manually
>> in svrmgrl (pending figuring out how to have server manager read it
>> from a file), and I got the following error:
>>
>> ORA-01503: CREATE CONTROLFILE failed
>> ORA-01161: database name DC in file header does not match given name of
>> REGRESS
>> ORA-01110: data file 1: '/oracle02/oradata/regress/system01.dbf'
>>
>> DC is the old name of the database and REGRESS is the new name...
>>
>> So apparently it doesn't like that the information in the datafile doesn't
>> jive with the new name?
>>
>> can anyone help me out?
>>
>> thanks in advance,
>> Lee
>>
>> On 13 Jun 2000 18:55:59 GMT, Lee <feigenb_at_is01.fas.harvard.edu> wrote:
>> >Thanks, Sybrand...
>> >
>> >That's worked so far, but I still have a couple questions. If the
>> >answers to these are found in documentation online, please point me to
>> >it (I realize these are very elementary questions): [I'm running Oracle
>> >8.1.6 on Redhat Linux]
>> >
>> >-- How do I 'run' the trace file in sever manager?
>> >-- To delete a database, does deleting all the relevant datafiles and
>> > relevant files relating to the instance suffice?
>> >
>> >Thanks again,
>> >Lee
>> >
>> >On Tue, 13 Jun 2000 19:15:32 +0200, Sybrand Bakker
 <postbus_at_sybrandb.demon.nl> wrote:
>> >>The proper way to do it is
>> >>alter database backup controlfile to trace
>> >>The trace file will be in the directory pointed to by the user_dump_dest
>> >>parameter.
>> >>Now edit the file changing the database name
>> >>and run it using whatever version of server manager is appropiate for
 your
>> >>otherwise unknown platform.
>> >>The other command just does what it does: it renames the global name
 which
>> >>is composed of the db_name, and the db_domain parameter.
>> >>
>> >>Hth,
>> >>
>> >>Sybrand Bakker, Oracle DBA
>> >>
>> >>
>> >>"Lee" <feigenb_at_is01.fas.harvard.edu> wrote in message
>> >>news:slrn8kcq1k.jfh.feigenb_at_is01.fas.harvard.edu...
>> >>> I tried poking around this newsgroup archives and docs to see
>> >>> how to rename a database...
>> >>>
>> >>> I tried doing: alter database <name> rename global_name to <newname>
>> >>>
>> >>> which claimed to have succeeded but didn't seem to do anything...
>> >>>
>> >>> So I tried manually moving all the files and replacing all occurrences
>> >>> of <name> with <newname> but now when I startup the database I receive
>> >>> an ORA-01103 error that the database name doesn't match the database
>> >>> name in the control files.
>> >>>
>> >>> Is there a way to change the database name in the control files at the
>> >>> point i'm at? Otherwise if I go back and rename everything to the
 original
>> >>> database name and get that started-up, how do I correctly go about
>> >>> renaming the database?
>> >>>
>> >>> on a (slightly) related note, what's the 'proper' method for deleting
 a
>> >>> database and associated instance completely?
>> >>>
>> >>> Thanks in advance,
>> >>> Lee
>> >>>
>> >>
>> >>
>
>
Received on Tue Jun 13 2000 - 00:00:00 CDT