Home Oracle Commands

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 Commands:
CROSSCHECK - Check whether backup items still exist.
RESTORE - Restore files from an RMAN backup (or copy)



Back to the Top

Simon Sheppard
SS64.com