一步一脚印

最近做了一个rac数据库的迁移，中间涉及到很多部分内容，包括rac环境的搭建、ASM的设置、数据库的迁移、升级等。
本文是这次迁移工作的第七部分：后续工作。

7 后续工作

7.1修改db_name

为了与正式系统区分，需要修改还原过来的数据库名称。在rac中修改db_name的步骤与单实例步骤差不多，主要是要修改一些与cluster相关的参数。

停止所有实例，然后把其中一个实例启动到mount状态下：
SQL> startup mount
ORACLE instance started.
Total System Global Area 1476395008 bytes
Fixed Size                  2030200 bytes
Variable Size             268436872 bytes
Database Buffers         1191182336 bytes
Redo Buffers               14745600 bytes
Database mounted.
SQL> alter system set cluster_database=false scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1476395008 bytes
Fixed Size                  2030200 bytes
Variable Size             268436872 bytes
Database Buffers         1191182336 bytes
Redo Buffers               14745600 bytes
Database mounted.
SQL> exit
bash-3.00$ nid target=sys/testpass dbname=pretrade logfile=~/nid2.log
重新把cluster_database设置为true，并把db_name参数修改为新的名称：
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on 星期四 9月 27 23:04:19 2007
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1476395008 bytes
Fixed Size                  2030200 bytes
Variable Size             268436872 bytes
Database Buffers         1191182336 bytes
Redo Buffers               14745600 bytes
ORA-01103: database name 'PRETRADE' in control file is not 'TRADEDB'
SQL> alter system set db_name=pretrade scope=spfile;
System altered.
SQL> alter system set cluster_database=true scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1476395008 bytes
Fixed Size                  2030200 bytes
Variable Size             268436872 bytes
Database Buffers         1191182336 bytes
Redo Buffers               14745600 bytes
Database mounted.
最后在打开的时候open resetlogs即可。
SQL> alter database open resetlogs;


分类:	(					Oracle技术
										) :: 评论 (0) :: 静态链接网址 :: 引用 (0)