RDF System Management Manual

Maintaining the Databases
HP NonStop RDF System Management Manual—524388-003
6-4
Backing Up Altered Database Structures
Figure 6-5 shows unsynchronized databases. In this figure, T5 and T6 (transactions 5
and 6) have not been transmitted to the backup system because of a physical disaster,
such as fire or flood, or because the primary or backup systems have failed. The
databases are unsynchronized because transactions were committed or aborted on
the primary system before an unexpected shutdown, and the extractor cannot transmit
the commit or abort status records for those transactions (T5 and T6) to the backup
system.
Backing Up Altered Database Structures
When you change the structure of a database on the primary system, you also need to
change the structure on the backup system.
NonStop SQL/MP or NonStop SQL/MX Databases
For NonStop SQL/MP or NonStop SQL/MX databases, changes you need to perform
on the backup system include:
•
Catalog changes
•
Results of DDL operations, including creating or altering tables and views
•
Partition key changes
•
Table purges
Figure 6-5. Unsynchronized Databases
MAT
Image File
Database Database
\PRIMARY \BACKUP
T1
T2
T3
T4
T5
T6
T1
T2
T3
T4
T4
Updater
T1
T2
T3
T4
T5
T6
X