What is the UNTIL clause?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the UNTIL clause?
Rating:
The UNTIL clause specifies a time, system change number (SCN), or log sequence number as the upper limit for various RMAN operations such as restore, recover, etc.
| UNTIL TIME = 'date_string' | Specifies a time as an upper limit. RMAN selects only files that can be used to recover up to (but not including) the specified time. For example, LIST BACKUP UNTIL TIME 'SYSDATE-7' lists all backups that could be used to recover to a point one week ago. |
| UNTIL SCN = integer | Specifies an SCN as an upper limit. RMAN selects only files that can be used to recover up to (but not including) the specified SCN. For example, RESTORE DATABASE UNTIL SCN 500 restores only backups that could be used to recover up to the system change number 500. |
| UNTIL SEQUENCE = integer THREAD = integer | Specifies a log sequence number and thread number as an upper limit. RMAN selects only files that can be used to recover up to (but not including) the specified log sequence number. For example, RECOVER DATABASE UNTIL SEQUENCE 6000 THREAD 1 recovers the database up to the log sequence number 5999. |
Rating:
Was this information helpful?
Other articles
- What is instance recovery?
- What is a stored script?
- What is the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?
- How are the archived redo log files' names determined when automatic archiving is enabled?
- What is the RESETLOGS option?
