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

    Backup files being missed when log seq # from and until specified

    sweetritz

      Hi DBAs,

       

      I backed up my archive logs from my pre prod DB 10.2.0.5 because my mount point was full.

       

      but when i gave the below script:

      run {

      allocate channel ch01 type disk  maxpiecesize 7000M;

      allocate channel ch02 type disk  maxpiecesize 7000M;

      allocate channel ch03 type disk  maxpiecesize 7000M;

      allocate channel ch04 type disk  maxpiecesize 7000M;

       

       

      BACKUP tag ArchLogAll FILESPERSET 20 FORMAT '/oracledb/oradata/DBOEM/backupset/2014_06_09/%d_s_%s_p_%p_t_%t.bkp' ARCHIVELOG

      FROM SEQUENCE 4410 UNTIL SEQUENCE 4513 THREAD 1 DELETE INPUT;

       

       

      RELEASE CHANNEL ch01;

      RELEASE CHANNEL ch02;

      RELEASE CHANNEL ch03;

      RELEASE CHANNEL ch04;

      }

       

      The script ran successfully which means the archived logs were supposed to be backed up and deleted as mentioned in the script from seq. 4410 to 4513.

      But when i again went over the mount point location to verify whether they have been deleted after backup.... i was shocked to see that it has backed up and deleted seq. from random numbers and many have not backed up and not deleted. For example seq. 4462,4492,4511 etc were not backed up.

       

      Any issue with my script or any thing else wrong?

       

      Regards,

      Ritu