Data Protection Software

 View Only
  • 1.  Command to see all the backup version of specific file

    Posted Wed February 06, 2019 07:31 AM
    Hi All,

    I am trying all the way but not getting results while querying backup of specific file, i am looking for a query from which i should get all the active and inactive version of specific file from date so that i can choose specific pit date to restore the file.

    q ba "/usr/lib/libssl.a*" this command i am using and getting result of the latest date backup file only. please advise.

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

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


  • 2.  RE: Command to see all the backup version of specific file

    IBM Champion
    Posted Wed February 06, 2019 08:06 AM
    Hi Prem,

    The easiest way to do this is to use the BA GUI client, select the file you wish to restore and select the option to show active & inactive versions.

    The CLI option, can take a long time to run due to the amount of data in the backup table. You can use the "inactive" option:

    e.g. dsmc query backup –inactive "filename"

    Regards
    Darren

    ------------------------------
    Darren Sanders
    Principal Consultant
    Celerity Ltd

    http://www.celerity-uk.com
    #ibmchampion storage
    ------------------------------



  • 3.  RE: Command to see all the backup version of specific file

    Posted Wed February 06, 2019 09:06 AM
    Thanks Darren for the quick help always I don't have option of gui because Java package is not installed on Unix client and not allowed to install for unknown reason and from command I am not able to see to list down all version of backup from single command I tried that command which you have provided but unfortunately it's not providing desired output. I have a 30 days retention for file system backup I can query the backup of specific file but only the latest one I am expecting if I wanted to check a specific. File of last day backup or all the backup version of one file it is not giving me that option.

    Thanks 
    Prem 





  • 4.  RE: Command to see all the backup version of specific file

    Posted Tue April 16, 2019 09:32 AM

    Hello Prem,
    the parameter Darren mentioned is correct.
    Example:
    1. q backup without -ina parameter:

    2. q backup with -ina parameter:

    As you can see, all the inactive versions are shown. OK, in this case only one inactive version is present :-)

    I think you are looking for the restore command with the parameters -ina and -pick. With this you are able to select out of the list of backup versions of a file to restore.

    In this list you can select a version with 1 or 2 and restore the selection with O afterwards.




    ------------------------------
    Jochen Meixner
    Principal Consultant Storage & Backup Solutions
    ACT Gruppe
    Germany
    ------------------------------



  • 5.  RE: Command to see all the backup version of specific file

    Posted Thu April 18, 2019 01:37 AM
    Hi Jochen,

    Thank you for the response when i will attempt to restore that time i can pick that is fine I am looking for a query where i can query a specific date backup or a file from specific date backup.

    -q backup -ina will reflect all active and inactive version
    -q backup without -ina will reflect only active version 

    but my purpose is to query a specific date or specific file on that.


    --
    Regards
    Prem 






  • 6.  RE: Command to see all the backup version of specific file

    Posted Tue April 23, 2019 08:33 AM
    Hello Prem,
    ok, I think I understand now what you mean.

    Try the -fromdate and -todate parameters with the query backup command. Then you get the info from one day. When there are more backups on one day use the -fromtime and -totime parameters additionally.
    With the -detail parameter you get some more information about the file.
    q backup with parameter

    Best regards,
    Jochen

    ------------------------------
    Jochen Meixner
    Principal Consultant Storage & Backup Solutions
    ACT Gruppe
    Duesseldorf, Germany
    ------------------------------



  • 7.  RE: Command to see all the backup version of specific file

    Posted Wed April 24, 2019 08:48 AM
    You can also use the restore command with the pick option. This allows you to pick from a list of all of backups, active and inactive, for the restore.

    ------------------------------
    Mary Bourgeois
    Senior Technical Enablement Specialist
    IBM
    Austin TX
    ------------------------------



  • 8.  RE: Command to see all the backup version of specific file

    Posted Wed April 24, 2019 03:13 PM
    Hi Mary,
    yes, this was my first idea, too.
    But this seems not to be Prem's problem, he wants to query one backup object out of versions he has backed up.

    Best regards,
    Jochen

    ------------------------------
    Jochen Meixner
    Principal Consultant Storage & Backup Solutions
    ACT Gruppe
    Duesseldorf, Germany
    ------------------------------



  • 9.  RE: Command to see all the backup version of specific file

    Posted Wed April 24, 2019 11:06 PM
    Hi,

    Thanks you are right I wanted to query the backup only, thanks for the information, I wanted to know anyone of you aware about roadmap when  IBM will bring the restoration and backup function from TSM centralize console.

    Thanks 
    Prem