Oracle Study之--Oracle RAC重建控制文件 - 数据库编程

L> alter system set cluster_database =false scope=spfile;
System altered.
SQL> startup nomount
ORACLE instance started.
Total System Global Area? 612368384 bytes
Fixed Size? ? ? ? ? ? ? ? ? 2022832 bytes
Variable Size? ? ? ? ? ? 184549968 bytes
Database Buffers? ? ? ? ? 423624704 bytes
Redo Buffers? ? ? ? ? ? ? ? 2170880 bytes
?
SQL> show parameter cluster
NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE
------------------------------------ ----------- ------------------------------
cluster_database? ? ? ? ? ? ? ? ? ? boolean? ? FALSE
cluster_database_instances? ? ? ? ? integer? ? 1
cluster_interconnects? ? ? ? ? ? ? ? string
?
SQL> @/home/oracle/cr_ctr.sql
Control file created.
?
告警日志：
alter.log:
Mon Mar 23 16:41:00 2015
CREATE CONTROLFILE REUSE DATABASE "PROD" NORESETLOGS? NOARCHIVELOG
? ? MAXLOGFILES 192
? ? MAXLOGMEMBERS 3
? ? MAXDATAFILES 1024
? ? MAXINSTANCES 32
? ? MAXLOGHISTORY 292
LOGFILE
? 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 LOGFILE

DATAFILE
? '/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
Mon Mar 23 16:41:00 2015
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
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/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 1
Mon Mar 23 16:41:05 2015
Successful mount of redo thread 1, with mount id 286981148
Mon Mar 23 16:41:05 2015
Completed: CREATE CONTROLFILE REUSE DATABASE "PROD" NORESETLOGS? NOARCHIVELOG
? ? MAXLOGFILES 192
? ? MAXLOGMEMBERS 3
? ? MAXDATAFILES 1024
? ? MAXINSTANCES 32
? ? MAXLOGHISTORY 292
LOGFILE
? 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/ora

Oracle Study之--Oracle RAC重建控制文件(二)