Name

archivelogRecordSpecifier Clause

Synopsis

ARCHIVELOG

   { ALL 
   | LIKE 'string_pattern' 
   | archlogRange 
                             [LIKE 'string_pattern' [THREAD [=] integer]] 
   }

archlogRange for Oracle9i := 
{ { { UNTIL TIME | FROM TIME } [=] 'date_string'
  | { TIME BETWEEN 'date_string' AND 
    | FROM TIME [=] 'date_string' UNTIL TIME [=]
    } 
    'date_string' 
  | UNTIL SCN [=] integer 
  | SCN BETWEEN integer AND integer 
  | FROM SCN [=] integer [UNTIL SCN [=] integer]
  }
  [THREAD [=] integer]
  | { UNTIL SEQUENCE [=] integer
                          | FROM SEQUENCE [=] integer [UNTIL SEQUENCE [=] integer] 
  | SEQUENCE [BETWEEN integer AND] integer
                          }
  [THREAD [=] integer]
}

archlogRange for Oracle8i := 
{ { UNTIL TIME | FROM TIME } [=]'date_string'
  | FROM TIME [=]'date_string' UNTIL TIME [=]'date_string'
  | UNTIL SCN [=]integer
                          | FROM SCN [=] integer [UNTIL SCN [=] integer]
  | UNTIL LOGSEQ [=] integer [THREAD [=] integer]
  | FROM LOGSEQ [=] integer [UNTIL LOGSEQ [=] integer]
    [THREAD [=] integer]
}

Provides flexibility in specifying the archived redo log files that will be included in backup, restore, and maintenance operations.

Keywords

ALL

Specifies that all logs should be included in the specified operation.

LIKE 'string_pattern'

Includes logs that match the specified pattern.

archlogRange

Includes logs that match specified criteria for time, SCN, or sequence number.

THREAD integer

Specifies a redo thread and is used only with Oracle Parallel Server or Real Application Clusters.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.