ARCHLOGUSEDTHRESHOLD
The ARCHLOGUSEDTHRESHOLD option specifies when to start an automatic database backup in relation to the percentage of archive log file space used. The default is 80 percent.
The ARCHLOGUSEDTHRESHOLD option prevents frequent automatic backups. For example, if the archive log file directory resides on a file system or drive that is 400 GB, a database backup is triggered if there is less than 80 GB of free space. Repeated database backups might cause the server to use an excessive amount of scratch tapes.
Syntax
Parameters
- value
- The percentage of archive log file space used before an automatic backup starts.
Specify to start an automatic backup when 90 percent of archive log file space is used.
archlogusedthreshold 90