Solaris 10下迁移10G RAC (七)

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

7 后续工作

7.1修改db_name

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

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.

SQL> alter database open resetlogs;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/231499/viewspace-63868/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/231499/viewspace-63868/