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