4 Replies Latest reply: Jun 10, 2014 7:09 AM by sweetritz RSS

    How to backup archive logs to disk which are not backed up 1 time?

    sweetritz

      Hi DBAs,

       

      I have a filesystem in which archive logs are stored and not backed up since 1 month as its a pre prod environment 10.2.0.5 . But the problem is now the filesystem is 98% fill and i need to backup all the archive logs since may 15 to june 9 to a specific disk location. is the following command correct?

       

      run {

      allocate channel ch01 type disk  maxpiecesize 7000M;

      allocate channel ch02 type disk  maxpiecesize 7000M;

       

      BACKUP tag ArchLogAll FILESPERSET 20 FORMAT '/oracledb/oradata/DBOEM/ORAFL/DBOEM/DBOEM/backupset/2014_06_09/%d/d_%d_s_%s_p_%p_t_%t.bkp' ARCHIVELOG ALL not backed up 1 times;

      delete noprompt archivelog all backed up 1 times to DEVICE TYPE disk;

       

      RELEASE CHANNEL ch01;

      RELEASE CHANNEL ch02;

       

      }

       

      Regards,

      Ritu