Re: renaming a database

Also, after

ALTER DATABASE OPEN RESETLOGS; I'd put:

alter database rename global_name to newname;

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3a5b7f1a_at_news.iprimus.com.au...
> Your reply is close, in that the key is to change the first line of the
> 'create controlfile' script, so that it reads 'set' instead of 'reuse'.
>
> Where I think you skipped over a rather nasty detail is in suggesting that
> you can retain the 'noresetlogs' part of that line: re-creating
 controlfiles
> requires a resetlogs, so that bit has to change as well.
>
> Further down in the 'backup to trace' script, there's usually a line that
> reads 'alter database open' -that will fail, unless you change it to read
> 'alter database open resetlogs' (and no, I have no idea why you have to
> specify resetlogs in two different places!).
>
> Some other nasties: any datafiles which are offline when you try this will
> be unrecoverable. Bring them all online first. And if you are in
> archivelog mode, by resetting your logs, you've just rendered all prior
> backups and all prior archives totally useless (except in exceptional,
> horrible and tricky circumstances)... it's therefore time to blow all
 those
> away, having first shut the newly-named database down, and performed a
> complete closed database backup.
>
> Regards
> HJR
Received on Fri Jan 12 2001 - 06:04:44 CST