LOG_ARCHIVE_FORMAT

LOG_ARCHIVE_FORMAT is applicable only if you are using the redo log in ARCHIVELOG mode. Use a text string and variables to specify the default filename format when archiving redo log files. The string generated from this format is appended to the string specified in the LOG_ARCHIVE_DEST parameter.

The following variables can be used in the format:

  • %s log sequence number
  • %S log sequence number, zero filled
  • %tthread number
  • %Tthread number, zero filled
  • %a activation ID
  • %d database ID
  • %r resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database

At least %r%s%t is needed

posted @ 2013-08-07 12:12  ArcerZhang  阅读(428)  评论(0)  编辑  收藏  举报