Re: renaming a database

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