Oracle in a Nutshell

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.