Nortel Networks FP1 Manuale Utente Scaricare il pdf (Pagina 93)

Security and Administration 93

Nortel Networks Confidential

Resynchronizing databases

In the unlikely event that changes to the primary database are not

propagated to the secondary database, the two databases must be

manually resynchronized as follows:

In a telnet window

1 Login to the primary database as oracle.

2 Do the following:

cd /IMS/imssipdb/data/db_schema

resync_rep_db.sh

Note: This command removes all application-related information

from the secondary database and then resynchronizes the

secondary database with the data from the primary database.

Disk space management

Oracle uses indexes to quickly access frequently used data. However,

when records in a table are deleted, the associated indexes for the

deleted records are nulled, but not deleted.

Over time, the indexes of frequently added and deleted tables increase

in size, even though the number of records in the table stays relatively

the same. Periodic optimization improves index lookup time and

reduces disk usage.

The following procedure drops and recreates all the indexes in a

database. It also deallocates any unused space in a tablespace, thus

optimizing the space usage.

CAUTION

Resynchronizing databases is a lengthy process.

Allow 1-2 hours to complete the operation.

Only trained personnel should perform the following

task.

1 2 ... 88 89 90 91 92 93 94 95 96

Nessun commento

Nortel Networks FP1 Manuale Utente Pagina 93