does anyone know where the %r (resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database ) value comes from in constructing archive log file name?? TIA Raj ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY';