ITPub博客

首页 > Linux操作系统 > Linux操作系统 > standby database -- Compatibility and Operational Requirements

standby database -- Compatibility and Operational Requirements

原创 Linux操作系统 作者:tolywang 时间:2008-08-11 09:40:25 0 删除 编辑
Compatibility and Operational Requirements

Note the following requirements for maintaining a standby database:

The primary database must run in ARCHIVELOG mode.

A standby database in manual recovery mode operates only on Oracle release 7.3 or higher.

A standby database in managed recovery mode operates only on Oracle release 8.1 or higher.

A standby database in read-only mode operates only on Oracle release 8.1.5 or higher.

The redo logs that you apply to the standby database must be either archived or noncurrent online redo logs. Note that you can salvage the transactions in the current redo log by archiving it manually.

You must use the same version and release of the operating system on the primary and standby hosts. The standby host can, however, use a different directory structure.

You should use the same version, release, and patch of the Oracle RDBMS for the primary and standby databases so that failover operations are not compromised.

The primary database and standby database cannot share the same control file.

If you place your primary and standby databases on the same host, some operating systems will not allow you to mount two instances with the same database name on the same machine simultaneously. Workarounds for this situation exist for every platform.

You cannot activate a standby database and then return it to managed recovery mode; an activated standby database becomes a normal primary database.
 
Oracle8.1 或以下版本:  日志不能自动传过来,可通过脚本自动ftp 或 nfs 自动 apply 也不能.需要用脚本定时 apply
 
Oracle 8.1 或以上版本:  可以通过managed revery database 方式自动恢复data . 
 
 
 
 
 
 

 

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

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    14695831