How to manage DB Mirroring for ASM Controlfile

Because ASM-managed DB contains controlfile that cannot be copied directly, the DB mirroring controlfile for ASM Management cannot copy control files after shutdown db. The following rebuilds the Controlfile to add controlfile mirroring to ASM-managed DB

The steps are as follows:

1, sql> show parameter SPFile

NAME TYPE VALUE

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

SPFile string e:oracleproduct10.2.0db_1

Databasespfiletest. ORA

Open Spfiletest.ora with its parameters as follows:

test.__java_pool_size=4194304

test.__large_pool_size=4194304

test.__shared_pool_size=54525952

Test.__streams_pool_size=0

*._awr_flush_threshold_metrics=true

*.audit_trail= ' db_extended '

*.control_files= ' +dg1/test/control01.ctl ', ' +dg1/test/control02.ctl ', ' +dg1/test/control03.ctl '

*.dispatchers= ' (protocol=tcp) (dispatchers=5) '

*.nls_date_format= ' Yyyy/mm/dd hh24:mi:ss '

*.resource_manager_plan= ' Olap_plan '

*.shared_servers=0

*.undo_retention=0

*. Spfile= ' +dg1/test/spfiletest.ora '

--====================================

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

From the parameter spfile learned that this DB uses the real spfile is actually +dg1/test/spfiletest.ora

By modifying the parameter control_files to add a mirror can be modified successfully, you can find the final modified

It's e:oracleproduct10.2.0db_1databasespfiletest. The parameter Control_files in the Ora,

But spfile= ' +dg1/test/spfiletest.ora inside the parameter control_files but always cannot modify,

So I thought of a way to first create a pfile

2.sql> create Pfile from spfile= ' +dg1/test/spfiletest.ora ';

The file has been created.

Then manually edit the Pfile file, adding Control_files's Mirror: ' +dg1/test/control04.ctl '

3. Temporarily hide e:oracleproduct10.2.0db_1databasespfiletest. ORA

Use E:oracleproduct10.2.0db_1databaseinittest. Ora to start db to Nomount

4. After the reconstruction of the Controlfile, Mirror was added

5.sql> create spfile= ' +dg1/test/spfiletest.ora ' from pfile;

The file has been created.

6. Restore E:oracleproduct10.2.0db_1databasespfiletest. ORA

Finally mirror Controlfile success, feel a little trouble, do not know whether there is a simpler way.

Author:51cto Blog Oracle Little Bastard