Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to increase the copy of control files in Oracle". In daily operation, I believe many people have doubts about how to increase copies of control files in Oracle. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how to increase copies of control files in Oracle". Next, please follow the editor to study!

1. Document goal

The newly created database has only one copy of the control file. You want to add a copy of the control file to a different location to prevent damage to the control file.

two。 Modify control_files parameter # if you use OMF, you can only specify the path when you modify the parameter, without specifying an absolute path, and whether to use OMF means whether the db_create_file_dest parameter is set. 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 > exit3. Use RMAN to create a replica of the existing controlfile (1) create a copy of the control file [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 controlfile 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) check the control_files parameters [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 to this The study on "how to add copies of control files in Oracle" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.