Oracle怎么增加控制文件副本

这篇文章主要介绍"Oracle怎么增加控制文件副本"，在日常操作中，相信很多人在Oracle怎么增加控制文件副本问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答"Oracle怎么增加控制文件副本"的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

1.文档目标

新建的数据库只有一个控制文件副本，希望增加控制文件副本到不同位置，防止控制文件发生损坏。

2.修改control_files参数

# 如果使用了OMF则可以在修改参数时只指定路径，无需指定绝对路径，是否使用OMF即是否设置了db_create_file_dest 参数。SYS@honor1 > show parameter control_files;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------control_files                        string      +DATADG/honor/controlfile/current.260.984508003control_management_pack_access       string      DIAGNOSTIC+TUNINGSYS@honor1 > alter system set control_files='+DATADG/honor/controlfile/current.260.984508003','+datadg' scope=spfile sid='*';System altered.Elapsed: 00:00:00.01SYS@honor1 > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.10:16:35 SYS@honor1 > exit

3.使用RMAN利用现有controlfile创建副本

（1）创建控制文件副本[oracle@db-oracle-node1 ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Mon Dec 9 10:17:27 2019Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database (not started)RMAN> startup nomount;Oracle instance startedTotal System Global Area     521936896 bytesFixed Size                     2254824 bytesVariable Size                440403992 bytesDatabase Buffers              75497472 bytesRedo Buffers                   3780608 bytesRMAN> restore controlfile from '+DATADG/honor/controlfile/current.260.984508003';Starting restore at 09-DEC-19allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=34 instance=honor1 device type=DISKchannel ORA_DISK_1: copied control file copyoutput file name=+DATADG/honor/controlfile/current.260.984508003output file name=+DATADG/honor/controlfile/current.294.1026555549Finished restore at 09-DEC-19RMAN> alter database mount;database mountedreleased channel: ORA_DISK_1RMAN> alter database open;database openedRMAN> exitRecovery Manager complete.（2）查看control_files参数[oracle@db-oracle-node1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 9 10:41:18 2019Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsSYS@honor1 > show parameter control_files;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------control_files                        string      +DATADG/honor/controlfile/curr                                                 ent.260.984508003, +DATADG/hon                                                 or/controlfile/current.294.102                                                 6555549

到此，关于"Oracle怎么增加控制文件副本"的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注网站，小编会继续努力为大家带来更多实用的文章！