Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page