Primary Storage

  • 1.  Space are not reclaiming of TDP Oracle nodes

    Posted Fri February 28, 2020 09:36 AM
    Hi All,

    I am in a strange situation wherein I have open a PMR with IBM from last 10 days. But things are not moving faster. I though let's try this platform once. I have 2 SP server total disk solution. wherein we have capacity crunch on both the SP server for DB Stgpool. we have dedicated DB pool all Oracle backup are going into that.
    RMAN pretension is 30 days. in copy group i have 1,0,0,0 which is IBM recommendation.  I am trying to run tdposync it's failing I will attach the log at the last, however my point is why i should run anything expiration should work automatically. Both the SP server replicate data to each other.IBM has suggested to put one more syntax on oracle backup script.I have highlighted at the end. it is using control file. I need to know 3 things.

    1. Any suggestion how to figure out why expiration is not happening for those oracle nodes.
    2. what will be the connect string if it's using control file instead of catalogue. 
    3. Any quick workaround to reclaim the space immediately. 

    Oracle  full backup run once a week, rest day incremental and archive backup jobs. all are from cron.

    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE BACKUP OPTIMIZATION ON;
    run
    {
    allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_dataq.opt)';
    allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_dataq.opt)';
    allocate channel t3 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_dataq.opt)';
    allocate channel t4 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_dataq.opt)';
    backup as backupset format 'df_%d_%s_%p'
    skip inaccessible
    tag db_bk_full
    incremental level 0 database;
    sql 'alter system archive log current';
    BACKUP as BACKUPSET FORMAT 'ar_%d_%s_%p' ARCHIVELOG ALL not backed up 1 times;
    BACKUP as BACKUPSET FORMAT 'cf_rm_%d_%s_%p' current controlfile;
    crosscheck backup;

    release channel t1;
    release channel t2;
    release channel t3;
    release channel t4;

    }

    allocate channel for maintenance device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.dataq.opt)';
    delete noprompt obsolete;
    delete noprompt expired backup;

    EOF

    TDPOSYNC error-


    ------------------------------
    Prem Singh

    ------------------------------

    #StorageManagementandReporting
    #Storage
    #PrimaryStorage


  • 2.  RE: Space are not reclaiming of TDP Oracle nodes

    Posted Sat February 29, 2020 10:49 PM

    Guys,

    any quick suggestion for the problem.
    --






  • 3.  RE: Space are not reclaiming of TDP Oracle nodes

    Posted Mon March 02, 2020 09:19 AM
    Hi Prem,
    not TSM does the expiration of these oracle backups, Oracle has to expire them.
    With the suggested command in the backup script the objects which are older than 30 days will be expired.

    Best regards,
    Jochen

    ------------------------------
    Jochen Meixner
    Principal Consultant Storage & Backup Solutions
    CONET Services GmbH
    Duesseldorf, Germany
    ------------------------------



  • 4.  RE: Space are not reclaiming of TDP Oracle nodes

    Posted Mon March 02, 2020 09:39 AM
    Hi Jochen,

    Thanks for the update however in my case expiration is not happening.when we run tdposync then it release the space. According to my understanding once rman retention policy crossed it expires the data from rman catalogue and once this process finished it reports to TSM database and expiration cycle complete on TSM and space reclaimed. But it's not working in my case.





  • 5.  RE: Space are not reclaiming of TDP Oracle nodes

    Posted Tue March 03, 2020 02:16 PM
    Hi All,

    Any suggestion please can anyone help me to know the process to identify what needs to be mentioned in connect string when it has control file no catalogue server I checked all the possibility but failing to launch tdposync. I tried connect string to grep pmon and put the name which i can see on process and tried with database name as sysdba. but no luck.

    Gathering Catalog information...Please wait

    SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 3 21:04:51 2020

    Copyright (c) 1982, 2013, Oracle.  All rights reserved.

    ERROR:
    ORA-12154: TNS:could not resolve the connect identifier specified


    SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

    ANU2533E SQLPLUS error

    --






  • 6.  RE: Space are not reclaiming of TDP Oracle nodes

    Posted Tue March 03, 2020 04:25 PM
    Hi Prem, 

    Try to deactivate all the data under the Oracle node using deactivate node command with option fromdate=today-30.It will make all the data as inactive older than 30 days.once u run expiration , data will be deleted from tsm.

    In future make sure,Oracle team expires the data daily through the script.

    Regards,
    Vignesh Ponnaiah
    Mob: +91 99948-38581 (Whatsapp Only)





  • 7.  RE: Space are not reclaiming of TDP Oracle nodes

    Posted Wed March 04, 2020 07:43 AM
    Hi Vignesh,

    You can't achieve this from below command while you are using several retention on single node at rman level.

    Thanks
    Prem