Re: Can I change the database name after restoring the cold backup?

You'll also want to delete the stuff in the backup-to-trace about doing a recovery and not to reuse the original control files in the create-controlfile statement, as well as make the appropriate changes to db_name and db_domain in the init parm file, which also should be renamed.

One other svrmgrl/internal-sort of thing to do is rename the global_name (alter database rename global_name to newname). If you want to know what the current global name is, just select * from global_name.

In article <783866CAB183D211883F0090271F46C208B71F64_at_COW>, Andy Johnson <AJohnson_at_Armature.com> wrote:
>Hi Huy...
>
>If all the datafile are from the cold backup, you could restore them
>using a copy of a 'backup control file to trace' and modify the file
>accordingly, then just gointo server manager and re-run the
>control-file.
>
>regards
>
>andy
>
>-----Original Message-----
>From: Huy Vu [mailto:huyv_at_usa.net]
>Posted At: 22 October 2001 01:14
>Posted To: server
>Conversation: Can I change the database name after restoring the cold
>backup?
>Subject: Can I change the database name after restoring the cold backup?
>
>
>Hi all,
>
>Is it possible to change the Oracle database name after restoring the
>datafiles from cold backup?
>
>Thanks in advance for any advise.
>
>DH
>
>
Received on Mon Oct 22 2001 - 07:40:44 CDT