Oracle 12c database second restore job fails with error 'RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time'

book

Article ID: 100014100

calendar_today

Updated On:

Description

Error Message

"RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time"

 

Cause

RMAN displays this error when you try to perform a PITR of the database to a time before the database was last opened with RESETLOGS.

Resolution

Perform either of the following:

• Clear up your FRA between restores.

• Unset the FRA during restore using the following steps: 
 

  1. Check the parameter db_recovery_file_dest using the following command:

          SQL> show parameter db_recovery_file_dest;

  1. Unset the recovery dest using the following command:

          SQL> alter system set db_recovery_file_dest='' scope=both;

   3. Run restore/recover job.

   4. Set the recovery destination to prior location.
 


Applies To

Oracle database configured with FRA (Flash Recovery Area) and that has control file autobackup set to ON.

Issue/Introduction

Oracle 12c database second restore job fails with error. If FRA is configured and control file autobackup is ON (by default, this option is ON in Oracle 12c), then during RMAN restore, FRA crosschecking and cataloging is done. Because of this, the restored control file gets information about the previous restore which caused a RESETLOGs and new incarnation of the database. Hence, RMAN displays this error message.
Powered by Wolken Software