Forum Discussion

Vinayak_Chennur's avatar
9 years ago

RMAN FLAT FILE BACKUP size 3TB to be taken on tape failed with error code 13.

Hi Friends,

I am taking a RMAN flat file backup of 3TB DB.

While taking it the backup get failed with error code 13 after completed almost 1 TB .

again i have to resume it manually & backup get starts same thing repeat till it complete 3TB.

also its take time to compelete around 10 to 15 hrs.

Kindly suggest me what is the best method to take 3TB Rman Flat file database backup on tape.

kindly find the logs:

 

nfo nbjm (pid=19007) starting backup job (jobid=87437) for client Client name, policy Policy name, schedule Daily-Diff 01/16/2017 12:38:21 - Info nbjm (pid=19007) requesting STANDARD_RESOURCE resources from RB for backup job (jobid=87437, request id:{9099BA2E-DBBA-11E6-8DC2-D60DBD1D772A}) 01/16/2017 12:38:21 - requesting resource STRG_GROUP 01/16/2017 12:38:21 - requesting resource Master_server.NBU_CLIENT.MAXJOBS.Client name 01/16/2017 12:38:21 - requesting resource Master_server.NBU_POLICY.MAXJOBS.Policy name 01/16/2017 12:38:21 - Waiting for scan drive stop HPMSLD2, Media server: Media server 01/16/2017 12:38:22 - granted resource Master_server.NBU_CLIENT.MAXJOBS.Client name 01/16/2017 12:38:22 - granted resource Master_server.NBU_POLICY.MAXJOBS.Policy name 01/16/2017 12:38:22 - granted resource 111111 01/16/2017 12:38:22 - granted resource HPMSLD2 01/16/2017 12:38:22 - granted resource Media server-hcart3-robot-tld-0 01/16/2017 12:38:22 - estimated 0 kbytes needed 01/16/2017 12:38:22 - Info nbjm (pid=19007) resumed backup (backupid=Client name_1484530211) job for client Client name, policy Policy name, schedule Daily-Diff on storage unit Media server-hcart3-robot-tld-0 01/16/2017 12:38:22 - started process bpbrm (pid=86677) 01/16/2017 12:38:23 - connecting 01/16/2017 12:38:23 - mounting 111111 01/16/2017 12:38:23 - Info bpbrm (pid=86677) start bpbkar on client 01/16/2017 12:38:23 - Info bpbkar (pid=45657) Backup started 01/16/2017 12:38:23 - Info bpbrm (pid=86677) Sending the file list to the client 01/16/2017 12:38:23 - connected; connect time: 0:00:00 01/16/2017 12:39:25 - Info bptm (pid=86679) media id 111111 mounted on drive index 0, drivepath /dev/nst1, drivename HPMSLD2, copy 1 01/16/2017 12:39:26 - mounted 111111; mount time: 0:01:03 01/16/2017 12:39:26 - positioning 111111 to file 2 01/16/2017 12:40:27 - positioned 111111; position time: 0:01:01 01/16/2017 12:40:27 - begin writing 01/16/2017 14:19:02 - end writing; write time: 1:38:35 file read failed (13)

  • Marianne's avatar
    Marianne
    9 years ago

    If you had NBU 7.7.x or later with NetBackup Appliance, I could suggest Oracle Copilot.

    I have no other advice since your current method is not considered best practice. 

    Just wishing you good luck! 

  • Rman backup to disk and then flat file backup to tape is not best practice.

    Rather purchase Database and Application agent and use rman to backup directly to tape.

    There are lots of Oracle documetation on how to performance tune rman backups using backup application agent (e.g. NetBackup).

    • Vinayak_Chennur's avatar
      Vinayak_Chennur
      Level 4

      Hi Marianne,

       

      I have already suggested to the management about this. But they are like the rman backup which they dump its take hardly some time and its complete quickly later we can take on tape..On tape the time take more due to which they are not ready for rman backup to tape.

       

      Can you help me what is the other way of taking this backup.

       

      regards,

      Vinayak Chennuri

      • Marianne's avatar
        Marianne
        Level 6

        If you had NBU 7.7.x or later with NetBackup Appliance, I could suggest Oracle Copilot.

        I have no other advice since your current method is not considered best practice. 

        Just wishing you good luck!