To make sure the data from a logical-log backup with ON-Archive can be used quickly and effectively to restore the database, perform the tasks described in this section.

You have checked the logical-log backup result and checked the tape.

1. Use the SAPDBA recovery report (not available with ontape )

SAP recommend that you have the SAPDBA recovery report produced after your logical-log backups. This report can be automatically produced and reduces the time taken to perform a restore by listing the volumes required. For more information, see Recovery Report with SAPDBA.

2. Copy logical-log backup volumes and store copies offsite

Since your backups are vital to restore your database in the event of failure, you should consider copying the volumes and storing the copies at a different physical location.

For example, to copy the volume set LOGTAP (created with request ID 68), enter the following command:

$ onarchive ‘COPY/VSET=LOGTAP/DESTINATION=LOGTAP_BKP/REQUEST=68’

3. Physically label your tapes

Write the following information on your tapes to simplify the restore process:

– Save set ID

– Date and time of backup

– Volume set and volume names

– Logical-log file numbers

4. If you are using automatic logical-log backup, use SAPDBA to display the status of the logical logs. Refer to System Information. If necessary, you might need to increase the frequency of the backup.

Checking Logical-Log Backup Result with Message Log