oracle study之--oracle rac重建控制文件
系统环境：
操作系统： aix5.3
cluster： oracle 10gr2 crs
oracle： oracle 10gr2
在rac环境下重建控制文件和在单实例上类似，只是有些步骤需要注意：
[oracle@aix211 ~]$cat mkln.sh ln -s /dev/rsystem /u01/app/oracle/oradata/prod/system01.dbfln -s /dev/rsysaux /u01/app/oracle/oradata/prod/sysaux01.dbfln -s /dev/rusers /u01/app/oracle/oradata/prod/users01.dbfln -s /dev/rundotbs1 /u01/app/oracle/oradata/prod/undotbs01.dbf ln -s /dev/rundotbs2 /u01/app/oracle/oradata/prod/undotbs02.dbfln -s /dev/rtemp /u01/app/oracle/oradata/prod/temp01.dbfln -s /dev/rcontrol1_1 /u01/app/oracle/oradata/prod/control01.ctlln -s /dev/rcontrol2_2 /u01/app/oracle/oradata/prod/control02.ctlln -s /dev/rcontrol3_3 /u01/app/oracle/oradata/prod/control03.ctlln -s /dev/rredo1_1 /u01/app/oracle/oradata/prod/log11.logln -s /dev/rredo1_2 /u01/app/oracle/oradata/prod/log12.logln -s /dev/rredo2_1 /u01/app/oracle/oradata/prod/log21.logln -s /dev/rredo2_2 /u01/app/oracle/oradata/prod/log22.logln -s /dev/rindex /u01/app/oracle/oradata/prod/index01.dbfln -s /dev/rspfile /u01/app/oracle/oradata/prod/spfile01ln -s /dev/rexample /u01/app/oracle/oradata/prod/example01.dbf
database存储在在raw上。
1、首先在一个节点备份controlfile
[oracle@aix201 ~]$sqlplus '/as sysdba'sql*plus: release 10.2.0.1.0 - production on mon mar 23 16:16:07 2015copyright (c) 1982, 2005, oracle. all rights reserved.connected to:oracle database 10g enterprise edition release 10.2.0.1.0 - 64bit productionwith the partitioning, real application clusters, olap and data mining optionssql> select status from v$instance;status------------opensql> alter database backup controlfile to trace;database altered.
2、查看控制文件的trace备份（udump）
create controlfile reuse database prod noresetlogs noarchivelog maxlogfiles 192 maxlogmembers 3 maxdatafiles 1024 maxinstances 32 maxloghistory 292logfile group 1 '/u01/app/oracle/oradata/prod/log11.log' size 50m, group 2 '/u01/app/oracle/oradata/prod/log12.log' size 50m, group 3 '/u01/app/oracle/oradata/prod/log21.log' size 50m, group 4 '/u01/app/oracle/oradata/prod/log22.log' size 50m-- standby logfiledatafile '/u01/app/oracle/oradata/prod/system01.dbf', '/u01/app/oracle/oradata/prod/undotbs01.dbf', '/u01/app/oracle/oradata/prod/sysaux01.dbf', '/u01/app/oracle/oradata/prod/users01.dbf', '/u01/app/oracle/oradata/prod/example01.dbf', '/u01/app/oracle/oradata/prod/undotbs02.dbf'character set zhs16gbk;
3、关闭database，启动其中一个instance到弄mount
sql> startup nomount;oracle instance started.total system global area 612368384 bytesfixed size 2022832 bytesvariable size 184549968 bytesdatabase buffers 423624704 bytesredo buffers 2170880 bytessql> @/home/oracle/cr_ctr.sqlcreate controlfile reuse database prod noresetlogs noarchivelog*error at line 1:ora-01503: create controlfile failedora-12720: operation requires database is in exclusive modesql> show parameter clustername type value------------------------------------ ----------- ------------------------------cluster_database boolean truecluster_database_instances integer 2cluster_interconnects string---创建失败，原因是在rac下控制文件时处于共享（share）模式，需启动到独立（exclusive）模式，才能重建；修改cluster_database 为false，然后重建
重新建立控制文件：
sql> alter system set cluster_database =false scope=spfile;system altered.sql> startup nomountoracle instance started.total system global area 612368384 bytesfixed size 2022832 bytesvariable size 184549968 bytesdatabase buffers 423624704 bytesredo buffers 2170880 bytessql> show parameter clustername type value------------------------------------ ----------- ------------------------------cluster_database boolean falsecluster_database_instances integer 1cluster_interconnects stringsql> @/home/oracle/cr_ctr.sqlcontrol file created.告警日志：alter.log:mon mar 23 16:41:00 2015create controlfile reuse database prod noresetlogs noarchivelog maxlogfiles 192 maxlogmembers 3 maxdatafiles 1024 maxinstances 32 maxloghistory 292logfile group 1 '/u01/app/oracle/oradata/prod/log11.log' size 50m, group 2 '/u01/app/oracle/oradata/prod/log12.log' size 50m, group 3 '/u01/app/oracle/oradata/prod/log21.log' size 50m, group 4 '/u01/app/oracle/oradata/prod/log22.log' size 50m-- standby logfiledatafile '/u01/app/oracle/oradata/prod/system01.dbf', '/u01/app/oracle/oradata/prod/undotbs01.dbf', '/u01/app/oracle/oradata/prod/sysaux01.dbf', '/u01/app/oracle/oradata/prod/users01.dbf', '/u01/app/oracle/oradata/prod/example01.dbf', '/u01/app/oracle/oradata/prod/undotbs02.dbf'character set zhs16gbkmon mar 23 16:41:00 2015warning: default temporary tablespace not specified in create database commanddefault temporary tablespace will be necessary for a locally managed database in future releasewarning: you are creating/reusing datafile /u01/app/oracle/oradata/prod/control01.ctl.warning: oracle recommends creating new datafiles on devices with zero offset. the command /usr/sbin/mklv -y lvname -t o -w n -s n -r n vgname numpps can be used. please contact oracle customer support for more details.warning: you are creating/reusing datafile /u01/app/oracle/oradata/prod/control01.ctl.warning: oracle recommends creating new datafiles on devices with zero offset. the command /usr/sbin/mklv -y lvname -t o -w n -s n -r n vgname numpps can be used. please contact oracle customer support for more details.warning: you are creating/reusing datafile /u01/app/oracle/oradata/prod/control02.ctl.warning: oracle recommends creating new datafiles on devices with zero offset. the command /usr/sbin/mklv -y lvname -t o -w n -s n -r n vgname numpps can be used. please contact oracle customer support for more details.warning: you are creating/reusing datafile /u01/app/oracle/oradata/prod/control02.ctl.warning: oracle recommends creating new datafiles on devices with zero offset. the command /usr/sbin/mklv -y lvname -t o -w n -s n -r n vgname numpps can be used. please contact oracle customer support for more details.setting recovery target incarnation to 1mon mar 23 16:41:05 2015successful mount of redo thread 1, with mount id 286981148mon mar 23 16:41:05 2015completed: create controlfile reuse database prod noresetlogs noarchivelog maxlogfiles 192 maxlogmembers 3 maxdatafiles 1024 maxinstances 32 maxloghistory 292logfile group 1 '/u01/app/oracle/oradata/prod/log11.log' size 50m, group 2 '/u01/app/oracle/oradata/prod/log12.log' size 50m, group 3 '/u01/app/oracle/oradata/prod/log21.log' size 50m, group 4 '/u01/app/oracle/oradata/prod/log22.log' size 50m-- standby logfiledatafile '/u01/app/oracle/oradata/prod/system01.dbf', '/u01/app/oracle/oradata/prod/undotbs01.dbf', '/u01/app/oracle/oradata/prod/sysaux01.dbf', '/u01/app/oracle/oradata/prod/users01.dbf', '/u01/app/oracle/oradata/prod/example01.dbf', '/u01/app/oracle/oradata/prod/undotbs02.dbf'character set zhs16gbk
4、重建成功，启动到open
sql> select status from v$instance;status------------mountedsql> alter database open;database altered.添加临时表空间数据文件：sql> select name from v$tempfile;no rows selectedsql> select tablespace_name from dba_tablespaces;tablespace_name------------------------------systemundotbs1sysauxtempusersundotbs2example7 rows selected.sql> alter tablespace temp add 2 tempfile '/u01/app/oracle/oradata/prod/temp01.dbf' size 100m reuse;tablespace altered.sql> select name from v$tempfile;name--------------------------------------------------------------------------------/u01/app/oracle/oradata/prod/temp01.dbf
5、修改cluster_database参数，启动所有instance
sql> alter system set cluster_database =true scope=spfile;system altered.
启动所有instance，如果所有instance启动成功，则controlfile重建成功。