在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.