Oracle study Case-controlfile diversity on Raw

Oracle study Case-controlfile diversity on Raw

System environment:

Operating system: AIX 5300-08

Database: Oracle 10.2.0.1

After building the library through DBCA, there are two control files, and then add a control file

[[email protected]:/home/oracle] $sqlplus   '/AS SYSDBA ' sql*plus: release 10.2.0.1.0  - Production on Wed Nov 19 11:15:45 2014Copyright  (c)  1982,  2005, oracle.  all rights reserved. connected to:oracle database 10g enterprise edition release 10.2.0.1.0  - 64bit productionwith the partitioning, olap and data mining  optionsSQL> show parameter controlNAME                                   TYPE         VALUE------------------------------------ ----------- ------------------------------Control_file_ Record_keep_time        integer     7control_files                         string      / u01/app/oracle/oradata/prod/c                                                    ontrol01.ctl, /u01/app/oracle/                                                    oradata/prod/control02.ctl

2. Add a new control file

the file store uses raw, creating symbolic link files that are easy to manage.

[[Email protected]:/home/oracle] $ls  -l /u01/app/oracle/oradata/prodtotal 0lrwxrwxrwx     1 oracle   oinstall          16 Nov 18 16:14 control01.ctl -> /dev/rcontrol1_1lrwxrwxrwx     1 oracle   oinstall         16  Nov 18 16:14 control02.ctl -> /dev/rcontrol2_2lrwxrwxrwx     1 oracle   oinstall         16 nov  18 16:14 control03.ctl -> /dev/rcontrol3_3lrwxrwxrwx    1  oracle   oinstall         13 Nov  18 16:14 example01.dbf -> /dev/rexamplelrwxrwxrwx    1 oracle    oinstall         11 nov 18 16:14 index01.dbf - > /dev/rindexlrwxrwxrwx    1 oracle   oinstall          13 nov 18 16:14 log11.log -> /dev/ rredo1_1lrwxrwxrwx    1 oracle   oinstall          13 nov 18 16:14 log12.log -> /dev/rredo1_ 2lrwxrwxrwx    1 oracle   oinstall          12 Nov 18 16:14 spfile01 -> /dev/rspfilelrwxrwxrwx     1 oracle   oinstall          12 Nov 18 16:14 sysaux01.dbf -> /dev/rsysauxlrwxrwxrwx     1 oracle   oinstall         12 nov 18 16:14  system01.dbf -> /dev/rsystemlrwxrwxrwx    1 oracle    Oinstall         10 nov 18 16:14 temp01.dbf  -> /dev/rtemplrwxrwxrwx    1 oracle   oinstall          14 Nov 18 16:14 undotbs01.dbf ->  /dev/rundotbs1lrwxrwxrwx    1 oracle   oinstall          11 nov 18 16:14 users01.dbf -> /dev /rusers

sql> show parameter spfile;name                                   TYPE         VALUE------------------------------------ ----------- ------------------------------spfile                                 string       /u01/app/oracle/oradata/prod/s                                                    pfile01sql> alter system set control_files=  2   '/u01/app/oracle/oradata/prod/control01.ctl ', '/u01/app/oracle/ Oradata/prod/control02.ctl ', '/u01/app/oracle/oradata/prod/control03.ctl '  scope=spfile; System altered. Sql> startup force nomount;oracle instance started. total system global area  977272832 bytesfixed size                   2025592 bytesvariable  Size             255854472  Bytesdatabase buffers          713031680 bytesredo  Buffers                 6361088 bytessql> show parameter controlname                 &Nbsp;                type         value------------------------------------ -----------  ------------------------------control_file_record_keep_time         integer     7control_files                         string       /u01/app/oracle/oradata/prod/c                                                    ontrol01.ctl, /u01/app/oracle/                                                    oradata/prod/control02.ctl, /u                                                    01/app/oracle/oradata/prod/con                                                    trol03.ctl                                                   SQL> alter database mount; Alter database mount*error at line 1:ora-00205: error in identifying  control file, check alert log for more info View the alarm log, unable to identify the Control03.ctl file!

3. Copy Raw (Controlfile)

sql> shutdown abort;oracle instance shut down. [[Email protected]:/home/oracle] $DD if=/dev/rcontrol1_1 of=/dev/rcontrol3_3 bs=1024k64+0 Records in64+0 Records out

4. Restart the database

[[email protected]:/home/oracle] $sqlplus   '/AS SYSDBA ' sql*plus: release 10.2.0.1.0  - Production on Wed Nov 19 11:26:21 2014Copyright  (c)  1982,  2005, oracle.  all rights reserved. Connected to an idle instance. Sql> startup mount;oracle instance started. total system global area  977272832 bytesfixed size                   2025592 bytesvariable  Size             255854472  Bytesdatabase buffers          713031680 bytesredo  Buffers                 6361088 bytesdatabase mounted. sql> select name from v$controlfile; NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/ Prod/control01.ctl/u01/app/oracle/oradata/prod/control02.ctl/u01/app/oracle/oradata/prod/control03.ctlsql>  alter database open;database altered.

@ Now, Contolfile diversified success!

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1579463

Oracle study Case-controlfile diversity on Raw