Multiplexed Control Files (68)

本文介绍了Oracle数据库中控制文件的最佳实践,包括使用多重控制文件、将它们存储在不同的物理磁盘上以及使用操作系统镜像等策略来提高数据库的可靠性。

As with redo log files, Oracle enables multiple, identical control files to be open
concurrently and written for the same database. By storing multiple control files for a
single database on different disks, you can safeguard against a single point of failure
with respect to control files. If a single disk that contained a control file crashes, then
the current instance fails when Oracle attempts to access the damaged control file.
However, when other copies of the current control file are available on different disks,
an instance can be restarted without the need for database recovery.
If all control files of a database are permanently lost during operation, then the
instance is aborted and media recovery is required. Media recovery is not
straightforward if an older backup of a control file must be used because a current
copy is not available. It is strongly recommended that you adhere to the following:
■ Use multiplexed control files with each database
■ Store each copy on a different physical disk
■ Use operating system mirroring
■ Monitor backups

1. 使用多个同一的控制文件
2. 多个控制文件放在不同的物理磁盘上
3. 镜像 , 备份

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-977141/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-977141/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值