ezeke 发表于 2018-9-10 08:26:13

Oracle Study之--Oracle RAC重建控制文件

SQL> alter system set cluster_database =false scope=spfile;  
System altered.
  
SQL> startup nomount
  
ORACLE instance started.
  
Total System Global Area612368384 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" NORESETLOGSNOARCHIVELOG
  
    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" NORESETLOGSNOARCHIVELOG
  
    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


页: [1]
查看完整版本: Oracle Study之--Oracle RAC重建控制文件