My Oracle Support Banner

Unexpected Behavior During Resetlogs (Doc ID 1980350.1)

Last updated on SEPTEMBER 27, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
IBM z/OS on System z

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.