Yes. It worked.. Thanks a lot
regards b s pradhan --------------------------- On Wed, 03 Dec 2003 Tanel Poder wrote : >Try archive log stop; and archive log start; after setting the parameters.. > >Tanel. > > > Hi All, > > > > When I set log_archive_dest_2 to a valid local destination > > Dynamically on 8.1.7.0 it is not generating the archive files.. > > It is generating the archive files on on log_archive_dest_1 > > > > I even tried with the following settings .. > > 1] both log_archive_dest_1 and log_archive_dest_2 made MANDATORY > > 2] log_archive_min_succed_dest = 2 > > 2] log_archive_process = 10 > > > > Still it is not creating archives in the second location. > > > > Am i missing something? > > > > Thanks and Regards > > B S Pradhan > > > > > > > > > > > > > >
