恢复后更改数据库名称控制文件? [英] change database name controlfiles after restore?

问题描述

我已将名称为DB的数据库还原到另一个名为DB01的数据库

它处于STARTED状态(未挂载)，如果未挂载，似乎无法更改名称，并且由于名称而无法挂载，请问如何解决此问题?

我从当前服务器上的数据库获得了RMAN的完整备份，该服务器托管了数据库DB01，initdb01.ora已准备就绪，并已使用DB01进行了配置

下一步我该怎么做

尼德没有帮助！它要求挂载数据库！我无法挂载它

ORA-01103:控制文件中的数据库名称'DB'不是'DB01'

解决方案

因此，此处将db_name设置为DB，一旦数据库打开，就开始还原，您可以使用nid实用程序更改数据库名称.

SQL > ALTER SYSTEM SET DB_NAME=DB SCOPE=spfile;

请参考链接: 更改10G中的oracle数据库名称

I have restored database with the name DB to another database called DB01

it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it because of the name, how to solve this issue if possible?

I have RMAN full backup from DB on my current server which hosting the database DB01 the initdb01.ora is ready and configured with DB01

what can I do next

nid did not help! it asks for the database to be mounted! which i can not mount it

ORA-01103: database name 'DB' in control file is not 'DB01'

解决方案

So here set db_name as DB, start restore once database opened, you can change database name using nid utility.

SQL > ALTER SYSTEM SET DB_NAME=DB SCOPE=spfile;

Please refer the link: Changing oracle db name in 10G

这篇关于恢复后更改数据库名称控制文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！