1、备份全库和spfile backup as compressed backupset database plus archivelog; expdp dbank/dbank directory=dmp_dir dumpfile=dbank_2015623.dmp logfile=dbank.log parallel=5 SCHEMAS=DBANK Create pfile from spfile;
2、收集数据库信息
$DB_HOME/bin/srvctl config database -d
$DB_HOME/bin/srvctl config service -d
3、创建一个新的pfile
Create pfile from spfile;
4、关闭所有节点 crsctl stop cluster -all
5、重命名或编辑实例名称和其他参数使用实例名称。
For example: instance_name, service_names
6、创建新的实例之一Sid名字节点新密码文件。复制密码文件到其他节点和重命名它与相应的新的SID的名字。
If Data guard is in use, copy the password file from the primary $ORACLE_HOMEs to the standby server and rename it with the corresponding standby SID name.
7、Startup the database with new pfile file and create a spfile using new pfile.
8、Remove the old instance name and add a new instance name using srvctl command. ( Follow below for all instances whose names are changed )
$ srvctl remove instance -d
$ srvctl add instance -d
Configure the services back (if necessary)
$ srvctl modify service -d
Start the database
$ srvctl start database -d
SQL> select instance_name,status from gv$instance
9、Check tnsnames.ora, if INSTANCE_NAME is used, rename it accordingly.
For example:
net_service_name=
(DESCRIPTION=
(ADDRESS=…)
(ADDRESS=…)
(CONNECT_DATA=
(SERVICE_NAME=sales.us.example.com)
(INSTANCE_NAME=sales1)))
长按二维码关注公众号
原文链接: http://mp.weixin.qq.com/s?__biz=MjM5NTk0MTM1Mw==&mid=2650630280&idx=3&sn=9b7c6e18a05148fcb2ce371bc2026aab&chksm=bef9160e898e9f18c4b30a504e929afb55d7950260919e8de93128455e40960a17fefa961f8a&scene=21#wechat_redirect