3 Replies Latest reply: Dec 5, 2012 12:08 PM by P.Forstmann RSS

    control file retention archive log

    user143622
      Hello,

      Is there any default configuration that lets the controlfile store archivelog files path for a retention duration ?

      Is there any way to delete those archive logs still registered in the controlfile other than rman delete archivelog ?

      BR
        • 1. Re: control file retention archive log
          Osama_Mustafa
          Is there any default configuration that lets the controlfile store archivelog files path for a retention duration ?
          No
          Is there any way to delete those archive logs still registered in the controlfile other than rman delete archivelog ?
          why you don't use the RMAN simple command will do that
           RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
          • 2. Re: control file retention archive log
            P.Forstmann
            user1229166 wrote:
            Hello,

            Is there any default configuration that lets the controlfile store archivelog files path for a retention duration ?
            CONTROL_FILE_RECORD_KEEP_TIME instance parameter is close to this description:

            >
            This parameter applies only to records in the control file that are circularly reusable (such as archive log records and various backup records). It does not apply to records such as datafile, tablespace, and redo thread records, which are never reused unless the corresponding object is dropped from the tablespace.
            >

            Please read http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams036.htm#CHDDBCDB.
            • 3. Re: control file retention archive log
              EdStevens
              user1229166 wrote:
              Hello,

              Is there any default configuration that lets the controlfile store archivelog files path for a retention duration ?

              Is there any way to delete those archive logs still registered in the controlfile other than rman delete archivelog ?

              BR
              Perhaps if you explained the business problem you are trying to solve, instead of asking asking questions to help you implement some preconceived and unknown (to us) solution, you'd get far more useful answers.