11、RMAN不能备份online redo log。online redo log不需要备份

RMAN是不备份online redo log的。这个问题一直比较困惑,难道online redo log不需要备份?确实是的

[@more@]

看下面这段

Avoiding the Backup of Online Redo Logs

Although it may seem that you should back up online redo logs along with the datafiles and control file, this technique is dangerous. You should not back up online redo logs for the following reasons:

* The best method for protecting the online logs against media failure is by multiplexing them, that is, having multiple log members in each group, on different disks and disk controllers.
* If your database is in ARCHIVELOG mode, then the archiver is already archiving the filled redo logs.
* If your database is in NOARCHIVELOG mode, then the only type of backups that you should perform are closed, consistent, whole database backups. The files in this type of backup are all consistent and do not need recovery, so the online logs are not needed.
* You may accidentally restore backups of online redo logs while not intending to, thereby corrupting the database.

A number of situations are possible in which restoring the online logs cause significant problems to the database. The following sections describe scenarios that illustrate how restoring backed up online logs severely compromises recovery.


ARCHIVELOG mode时,rman backup中会发出alter system switch logfile 的命令,并备份archivelog ,等同于备份了online redo
而noARCHIVELOG mode时,不能online backup,所以,redo log是没有用的.

另外,如果你备份online redo log,并在恢复时使用,覆盖现有的online redo log,可能会引起数据丢失

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

转载于:http://blog.itpub.net/248644/viewspace-930327/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值