Warm Standby Requirements and Restrictions

There are several requirements and restrictions that apply to all Replication Server warm standby applications.

You must use a data server such as Adaptive Server, that supports warm standby applications.
One Replication Server manages both the active and standby databases. Both the active and standby databases must be Adaptive Server databases. See Replication Server Heterogeneous Guide > Heterogeneous Warm Standby for Oracle for detailed information on how to set up and configure a warm standby application between two Oracle databases.
You cannot create a standby database for the RSSD. You can create a standby database for the master database only if the Adaptive Server supports master database replication, such as Adaptive Server 15.0 ESD #2 and later.
Replication Server does not switch client applications to the standby database.
You should run Adaptive Server for the active and standby databases on different machines. Putting the active and standby databases on the same data server or hardware resources undermines the benefits of the warm standby feature.
Although Adaptive Server allows tables that contain duplicate rows, tables in the active and standby databases should have unique values for the primary key columns in each row.
The commands and procedures for abstract plans are replicated, except for:
- The and set @plan_id clause of create plan is not replicated. For example, this command is not replicated as shown.
```
create plan "select avg(price)
from titles" "(t_scan titles)
into dev_plans and set @plan_id
```
  Rather, it is replicated as:
```
create plan "select avg(price) 
from titles" "(t_scan titles)
into dev_plans
```
- The abstract plan procedures that take a plan ID as an argument (sp_drop_qplan, sp_copy_qplan, sp_set_qplan) are not replicated.
- The set plan command is not replicated.
Failover support is not a substitute for warm standby. While warm standby keeps a copy of a database, Sybase Failover accesses the same database from a different machine. Failover support works the same for connections from Replication Server to warm standby databases.

See Using Sybase Failover in a High Availability System in the Adaptive Server Enterprise documentation set.
You cannot use the dump and enable marker on the active database and then use cross-platform dump and load to rebuild the standby database. The Replication Agent must send the dump marker to the standby database you are rebuilding. During the cross-platform dump and load, the active database must be in single-user mode when you obtain the dump from the active database.