Backing Up and Recovering the Database › Recovery Procedures › Minimizing Non Archival Time

Minimizing Non Archival Time

Certain database recovery processes can take a considerable amount of time, depending on the size of the database. You can minimize non archival time during database recovery by restoring the database in phases. After the first phase (master index restore), you can resume archival.

If a SARDBASE RESTORE is required for a database, you can:

• Initially RESTORE only the master index (substantially less time than restoring all data)
• Use the TLOAD control statement of the SARTDR to restore the number of generations you require for production
• Resume operation of the CA View archival task, archiving to the newly‑restored database
• Use SARRSP to restore the rest of the corrupted database to the newly‑restored database

  This can be done during archival.