oracle asm 复制文件,oracle asm下的控制文件的复制

在asm管理下的oracle数据库，当进行数据库的控制文件增添时，如何进行控制文件的复制。

SQL> show parameter control_files

NAME                                 TYPE                  VALUE

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

control_files                        string      +PP/peng/control01.ctl, +PP/peng/control02.ctl

增加控制文件个数：

SQL> alter system set control_files='+PP/peng/control01.ctl','+PP/peng/control02.ctl','+PP/peng/control03.ctl' scope=spfile;

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  2083368 bytes

Variable Size             104859096 bytes

Database Buffers          171966464 bytes

Redo Buffers                6303744 bytes

Database mounted.

启动的mount状态后，用备份命令进行控制文件的复制。

SQL> alter database backup controlfile to '+PP/peng/control03.ctl';

Database altered.

复制完成后进行控制文件的增添：

SQL> alter system set control_files='+PP/peng/control01.ctl','+PP/peng/control02.ctl','+PP/peng/control03.ctl' scope=spfile;

System altered.

最后进行数据库的启动。

SQL> startup force

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  2083368 bytes

Variable Size             104859096 bytes

Database Buffers          171966464 bytes

Redo Buffers                6303744 bytes

Database mounted.

查看结果：

SQL> show parameter control_files

NAME                                 TYPE        VALUE

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

control_files                        string      +PP/peng/control01.ctl, +PP/pe

ng/control02.ctl, +PP/peng/con

trol03.ctl

Database opened.