Oracle 11g adds control files to the ASM Disk

Oracle uses ASM for storage. By default, there is only one control file for database creation. To add more control files, you must manually add them. The following are the specific steps:

1. view the current control file

[Oracle @ Oracle-LAB dbs] $ sqlplus/nolog

SQL> conn/assystem

SQL> conn/assysdba

SQL & gt; set line 200

SQL> column nameformat a50

SQL> select * from v $ controlfile;

Status name is _ BLOCK_SIZE FILE_SIZE_BLKS

------------------------------------------------------------------------

+ DATA/orcl/controlfile/current.259.833372337 NO 16384 594

 

2. Modify the control file parameters in spfile

SQL> alter system setcontrol_files = '+ DATA/orcl/controlfile/current.259.833372337', '+ data',' + fra' scope = spfile sid = '*';

System altered.

 

3. Start the database instance to the nomount status.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLEinstance shut down.

[Oracle @ Oracle-LAB/] $ rman target/

Recovery Manager: Release 11.2.0.3.0-Production on Thu Dec 5 11:49:47 2013

Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.

Connected to target database (not started)

RMAN> startup nomount

Oracle instancestarted

Total SystemGlobal Area 1653518336 bytes

Fixed Size 2228904 bytes

VariableSize 973081944 bytes

DatabaseBuffers 671088640 bytes

Redo Buffers 7118848 bytes

RMAN> restore controlfile from '+ DATA/orcl/controlfile/current.259.833372337 ';

Starting restore at 05-DEC-13

Using target database control fileinstead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID = 14 devicetype = DISK

 

Channel ORA_DISK_1: copied controlfile copy

Output filename = + DATA/orcl/controlfile/current.259.833372337

Output filename = + DATA/orcl/controlfile/current.261.833376309

Output filename = + FRA/orcl/controlfile/current.256.833376309

Finishedrestore at 05-DEC-13

 

4. Open the database

RMAN> SQL 'alter database mount ';

Sqlstatement: alter database mount

Released channel: ORA_DISK_1

RMAN> SQL 'alter database open ';

SQL statement: alter database open

 

5. Verify that the control file is successfully added.

SQL> select name from v $ controlfile;

NAME

--------------------------------------------------------------------------------

+ DATA/orcl/controlfile/current.259.833372337

+ DATA/orcl/controlfile/current.261.833376309

+ FRA/orcl/controlfile/current.256.833376309

 

6. Modify the parameters of the newly added control file in spfile.

SQL> alter system set control_files = '+ DATA/orcl/controlfile/current.261.833376309', '+ DATA/orcl/controlfile/current.259.833372337 ', '+ FRA/orcl/controlfile/current.256.833376309' scope = spfile sid = '*';

System altered.

 

7. Start the database with the new spfile

SQL> shutdown immediate

SQL> startup

SQL> select name, value fromV $ PARAMETER where name like '% control % ';

SQL> select * fromv $ controlfile;

 

Reference: metalink Document: How to duplicate a controlfilewhen ASM is involved [ID 345180.1]