Oracle RMAN Pocket Reference

Name

archivelogRecordSpecifier

Synopsis

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

Syntax

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]
}

Keywords

ALL

Specifies that all logs should be included in the specified operation

LIKE 'string_pattern'

Includes those logs that match the specified pattern

archlogRange

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

THREAD integer

Specifies a redo thread and is used only with Oracle Real Application Clusters