Performing user-managed Database-18.5, Restoring Control Files

18.5. Restoring Control Files

18.5.1, Restore Lost Copy of a multiplexed Control File
18.5.1.1, Copying a multiplexed Control File to a nondefault location
Assuming that the disk that lost the control file and the file system are no longer associated, you must modify the Control_files initialization parameter to indicate the new location of the lost control file.
(1) database read or write control file directly shutdown
(2) Copy the correct control file to the specified location
(3) modifying Control_files initialization parameters
(4) Start, Mount,open database
Simulation 1, a block of disk media failed, lost control files, put the control file in a new location
(1)
Sql> select status from V$instance;

STATUS
------------
OPEN

$ RM-RF Control01.ctl

Sql> alter system checkpoint;

Sql> select dbid,name,log_mode,checkpoint_change# from V$database;

DBID NAME Log_mode checkpoint_change#
---------- ---------------------------------------- ------------ ------------------
1375601832 BOSS ARCHIVELOG 577511

Sql>
Alter Tablespace TESTTBS01
Add datafile '/oracle/oradata/boss/testtbs01_02.dbf ' size 10m;

Sql> Show parameter control_files;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Control_files string/oracle/oradata/boss/control01
. CTL,/oracle/oradata/boss/con
Trol02.ctl,/oracle/oradata/bo
Ss/control03.ctl
sql> shutdown immediate;

sql> startup Open;
Ora-00205:error in identifying control file, check alert log for more info

$ cd $ORACLE _base/admin/boss/bdump
$ VI Alert_boss.log
Wed June 4 16:11:38 2014
Starting up 1 Dispatcher (s) for network address ' (Address= (Partial=yes) (protocol=tcp)) ' ...
MMNL started with pid=12, OS id=17321
Wed June 4 16:11:38 2014
Starting up 1 Shared server (s) ...
Wed June 4 16:11:39 2014
ALTER DATABASE MOUNT
Wed June 4 16:11:39 2014
Ora-00202:control file: '/oracle/oradata/boss/control01.ctl '
Ora-27037:unable to obtain file status
Linux error:2: No such file or directory
Additional Information:3
Wed June 4 16:11:42 2014
ORA-205 signalled During:alter DATABASE MOUNT ...

(2)
$ cp-rf/oracle/oradata/boss/control02.ctl/oradata/boss/control01.ctl

(3)
Sql> create Pfile from SPFile;

$ cd $ORACLE _home/dbs
$ VI Initboss.ora
*.control_files= '/oradata/boss/control01.ctl ', '/oracle/oradata/boss/control02.ctl ', '/oracle/oradata/boss/ Control03.ctl '

(4)
Sql> create SPFile from Pfile;
Create SPFile from Pfile
*
ERROR at line 1:
Ora-32002:cannot Create SPFILE already being used by the instance

sql> shutdown immediate;

Sql> create SPFile from Pfile;

sql> startup Open;

Sql> select status from V$instance;

STATUS
------------
OPEN