1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

DBBACKUP using only one thread

Discussion in 'Backup / Archive Discussion' started by illllm, Feb 2, 2018.

  1. illllm

    illllm Active Newcomer

    Joined:
    Jan 9, 2018
    Messages:
    21
    Likes Received:
    1
    Name Line Number Command
    DBBACKUP 10 backup db devc=DBBACK_FILEDEV type=full numstreams=12 wait=yes
    20 if(error) goto done
    30 backup volhist
    40 backup devconf
    50 delete volhist todate=today-30 type=all
    60 delete volhist todate=today-6 type=dbb
    70 prepare source=dbb planp=/var/log/SpectrumProtect/RPF/
    80 done:exit

    this is my script.....

    it used to work before, but now DBBACKUP is using only one thread. We ran the backup manually. Any ideas or suggestions as to why this could be happening ?

    Many thanks!
     
  2.  
  3. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,714
    Likes Received:
    376
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
  4. illllm

    illllm Active Newcomer

    Joined:
    Jan 9, 2018
    Messages:
    21
    Likes Received:
    1
    Thanks Marclant, yes that seems to be the issue. The DB backup starts with 8 sessions, then fails and then single session starts. I am trying to cancel the session/process but it keeps opening a new session.
     
  5. illllm

    illllm Active Newcomer

    Joined:
    Jan 9, 2018
    Messages:
    21
    Likes Received:
    1
    ok it turns out that the archive log space must have 20% free. This is why the backups were failing .
     
  6. illllm

    illllm Active Newcomer

    Joined:
    Jan 9, 2018
    Messages:
    21
    Likes Received:
    1
    well now there is 55% free and its still failing
     

Share This Page