The case of Oracle Study-- controlfile diversification on RAW
The case of Oracle Study-- controlfile diversification 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 another control file is added.
1. View controlfile information
[oracle@aix227:/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 new control files
File storage uses raw, the establishment of symbolic link files, easy to manage.
[oracle@aix227:/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/rusersSQL > show parameter spfile NAME TYPE VALUE-- spfile string / u01/app/oracle/oradata/prod/s pfile01SQL > alter system set control_files= 2'/ u01According to an oracle control 01.ctl' '/ u01ApplicationoracleUniplicateoradata scope=spfile prodandcontrol 02.ctljurisdiction 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 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 check the alarm log and cannot recognize the control03.ctl file!
3. Copy RAW (controlfile)
SQL > shutdown abort;ORACLE instance shut down. [oracle@aix227:/home/oracle] $dd if=/dev/rcontrol1_1 of=/dev/rcontrol3_3 bs=1024k64+0 records in64+0 records out
4. Restart the database
[oracle@aix227:/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.
@ so far, contolfile diversification has been successful!
