RMAN archivelogRecordSpecifier

Subclause to specify a range of archived redo logs.

Syntax:

ARCHIVELOG 
     {   ALL 
       | LIKE 'string_pattern' 
       | archlogRange [LIKE 'string_pattern' [THREAD [=] integer]]
     }
 
   archlogRange::=
    {
      {  FROM TIME  [=] 'date_string'
       | UNTIL TIME  [=] 'date_string'
       | TIME BETWEEN 'date_string' AND 'date_string' 
       | 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]
   }

"We don't want to go back to tomorrow, we want to go forward" ~ Dan Quale

Related:

CROSSCHECK - Check whether backup items still exist.
RESTORE - Restore files from an RMAN backup (or copy)


© Copyright SS64.com 1999-2013
Some rights reserved