Unexpected Behavior During Resetlogs

(Doc ID 1980350.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
All Platforms

Symptoms

After having done a recover database until time the open resetlogs is recreating the old archive logs while it should left them created.

 

After having run the recover command as follows
startup mount PFILE='//EMEASUP.ECS2.V10205P7.PARMLIB(INITORA)';
set autorecovery off;
recover database until time '2014-06-12:05:48:57' using backup controlfile;


In the alert.log the old archive logs recovered are deleted:
  DEL (EMEASUP.ECS2.ARCLOG1.T0001.S0000024.R0030450) CLUSTER          
 IDC0550I ENTRY (D) EMEASUP.ECS2.ARCLOG1.T0001.RY3M7A9Z DELETED      
 IDC0550I ENTRY (C) EMEASUP.ECS2.ARCLOG1.T0001.S0000024.R0030450 DELET
 IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 0            
                                                                      
 IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 0    
 IDCAMS  SYSTEM SERVICES                                           TIM
   PAGE      1                                                        
 MARGINS(1 256)                                                      
 IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 0            
                                                                      
  DEF CLUSTER( LINEAR NAME(EMEASUP.ECS2.ARCLOG1.T0001.S0000024.R003045
 SHR(1 3) KB(0000000556) STORCLAS(SUPSC   ) )                        
 IDC0508I DATA ALLOCATION STATUS FOR VOLUME SMSS02 IS 0              
 IDC0512I NAME GENERATED-(D) EMEASUP.ECS2.ARCLOG1.T0001.QGEAV7T4      
 IDC0181I STORAGECLASS USED IS SUPSC                                  
 IDC0181I MANAGEMENTCLASS USED IS SUPMC                              
 IDC0181I DATACLASS USED IS SUPDC  

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms