How to add one or more control files
When we have one control file, now want to add one or more control files, there is many method to do it,but the better way is:
1. Shut down the database with NORMAL or IMMEDIATE options.
2. Copy the single control file to its new location. Rename it if you want or need to.
3. Modify your INIT.ORA paramter file. Change the CONTROL_FILES parameter to point to both control files.
4. Startup the database.
It is so simplely,but I think the best way is to hava more controle files that is in difficult folder.
Usually I have three control files for every database.
本文介绍了一种简单有效的方法来为数据库增加一个或多个控制文件。首先正常或立即关闭数据库,然后复制现有的控制文件到新的位置并按需重命名。接下来修改INIT.ORA参数文件中的CONTROL_FILES参数指向所有的控制文件。最后启动数据库。
5万+

被折叠的 条评论
为什么被折叠?



