Forum Stats

  • 3,825,999 Users
  • 2,260,586 Discussions
  • 7,896,761 Comments

Discussions

Speed Up Recover Copy Tablespace

Kamaludin
Kamaludin Member Posts: 3 Red Ribbon
edited Apr 17, 2020 10:23AM in Recovery Manager (RMAN)

Hi,

My database is growth up, i have backup tablespace Level 0. and use incremental backup Level 1 and recover copy to update image backup by scheduler cronjob.

recover copy take time more so overlap next job,

so i want to know if there any tuning to speed up recover copy process?

below time cronjob :

Cronjob :

00 00,02,06,15,16,17,18,19,20,21,22,23 * * * /oracle/mlpt/scripts/JOB_L1.sh  > /dev/null

30 10,13 * * * /oracle/mlpt/scripts/JOB_L1.sh  > /dev/null

Below sample scripts for backup and recover copy.

run

{

allocate channel c1 type disk  format='/nfsv4_mlpt1/TEST/inc/K1_i_%U';

allocate channel c2 type disk  format='/nfsv4_mlpt2/TEST/inc/K1_i_%U';

allocate channel c3 type disk  format='/nfsv4_mlpt3/TEST/inc/K1_i_%U';

allocate channel c4 type disk  format='/nfsv4_mlpt4/TEST/inc/K1_i_%U';

allocate channel c5 type disk  format='/nfsv4_mlpt5/TEST/inc/K1_i_%U';

allocate channel c6 type disk  format='/nfsv4_mlpt6/TEST/inc/K1_i_%U';

allocate channel c7 type disk  format='/nfsv4_mlpt7/TEST/inc/K1_i_%U';

allocate channel c8 type disk  format='/nfsv4_mlpt8/TEST/inc/K1_i_%U';

allocate channel c9 type disk  format='/nfsv4_mlpt9/TEST/inc/K1_i_%U';

allocate channel c10 type disk  format='/nfsv4_mlpt10/TEST/inc/K1_i_%U';

allocate channel c11 type disk  format='/nfsv4_mlpt1/TEST/inc/K1_i_%U';

allocate channel c12 type disk  format='/nfsv4_mlpt2/TEST/inc/K1_i_%U';

allocate channel c13 type disk  format='/nfsv4_mlpt3/TEST/inc/K1_i_%U';

backup incremental level 1 for recover of copy with tag 'TAG_IMAGECOPY_TEST_GOLIVE'

tablespace USERS1,USERS2;

release channel c1;

release channel c2;

release channel c3;

release channel c4;

release channel c5;

release channel c6;

release channel c7;

release channel c8;

release channel c9;

release channel c10;

release channel c11;

release channel c12;

release channel c13;

}

RUN{

allocate channel c1 type disk  format='/nfsv4_mlpt1/TEST/inc/K1_i_%U';

allocate channel c2 type disk  format='/nfsv4_mlpt2/TEST/inc/K1_i_%U';

allocate channel c3 type disk  format='/nfsv4_mlpt3/TEST/inc/K1_i_%U';

allocate channel c4 type disk  format='/nfsv4_mlpt4/TEST/inc/K1_i_%U';

allocate channel c5 type disk  format='/nfsv4_mlpt5/TEST/inc/K1_i_%U';

allocate channel c6 type disk  format='/nfsv4_mlpt6/TEST/inc/K1_i_%U';

allocate channel c7 type disk  format='/nfsv4_mlpt7/TEST/inc/K1_i_%U';

allocate channel c8 type disk  format='/nfsv4_mlpt8/TEST/inc/K1_i_%U';

allocate channel c9 type disk  format='/nfsv4_mlpt9/TEST/inc/K1_i_%U';

allocate channel c10 type disk  format='/nfsv4_mlpt10/TEST/inc/K1_i_%U';

allocate channel c11 type disk  format='/nfsv4_mlpt1/TEST/inc/K1_i_%U';

allocate channel c12 type disk  format='/nfsv4_mlpt2/TEST/inc/K1_i_%U';

allocate channel c13 type disk  format='/nfsv4_mlpt3/TEST/inc/K1_i_%U';

recover copy of tablespace

USERS1,USERS2

with tag 'TAG_IMAGECOPY_TEST_GOLIVE';

release channel c1;

release channel c2;

release channel c3;

release channel c4;

release channel c5;

release channel c6;

release channel c7;

release channel c8;

release channel c9;

release channel c10;

release channel c11;

release channel c12;

release channel c13;

}

exit;

Tagged:

Answers

  • Sunny kichloo
    Sunny kichloo Member Posts: 2,459 Gold Trophy
    edited Apr 17, 2020 1:55AM

    Currently are you facing any performance issue when you are running this script?

    And if so could you crosscheck what is your memory consumption of OS during that time?

  • Dude!
    Dude! Member Posts: 22,829 Black Diamond
    edited Apr 17, 2020 2:43AM

    The more data you have the longer it will take to backup. There is nothing to tune unless you know there is a performance bottleneck and your system or hardware can do better. There is no universal way to improve performance and it all depends. Looking at your script without knowing anything about your database or system, you could try to reduce the number of channels to avoid possible process race conditions. Other than that, if you have Enterprise Edition, you can try to enable BCT, which can speedup incremental backups quite drastically, but again it depends.

  • Mustafa_KALAYCI
    Mustafa_KALAYCI Member Posts: 3,383 Bronze Crown
    edited Apr 17, 2020 10:23AM

    in addition to others said, why don't you do recover and backup in the same script? that way they won't overlapped too.

    run

    {

    allocate channel c1 type disk  format='/nfsv4_mlpt1/TEST/inc/K1_i_%U';

    allocate channel c2 type disk  format='/nfsv4_mlpt2/TEST/inc/K1_i_%U';

    allocate channel c3 type disk  format='/nfsv4_mlpt3/TEST/inc/K1_i_%U';

    allocate channel c4 type disk  format='/nfsv4_mlpt4/TEST/inc/K1_i_%U';

    allocate channel c5 type disk  format='/nfsv4_mlpt5/TEST/inc/K1_i_%U';

    allocate channel c6 type disk  format='/nfsv4_mlpt6/TEST/inc/K1_i_%U';

    allocate channel c7 type disk  format='/nfsv4_mlpt7/TEST/inc/K1_i_%U';

    allocate channel c8 type disk  format='/nfsv4_mlpt8/TEST/inc/K1_i_%U';

    allocate channel c9 type disk  format='/nfsv4_mlpt9/TEST/inc/K1_i_%U';

    allocate channel c10 type disk  format='/nfsv4_mlpt10/TEST/inc/K1_i_%U';

    allocate channel c11 type disk  format='/nfsv4_mlpt1/TEST/inc/K1_i_%U';

    allocate channel c12 type disk  format='/nfsv4_mlpt2/TEST/inc/K1_i_%U';

    allocate channel c13 type disk  format='/nfsv4_mlpt3/TEST/inc/K1_i_%U';

    recover copy of tablespace

    USERS1,USERS2

    with tag 'TAG_IMAGECOPY_TEST_GOLIVE';

    backup incremental level 1 for recover of copy with tag 'TAG_IMAGECOPY_TEST_GOLIVE'

    tablespace USERS1,USERS2;

    release channel c1;

    release channel c2;

    release channel c3;

    release channel c4;

    release channel c5;

    release channel c6;

    release channel c7;

    release channel c8;

    release channel c9;

    release channel c10;

    release channel c11;

    release channel c12;

    release channel c13;

    }

    also I am curious, how big is this db? do you need that much channel? and does your disk can handle that much data?