Forum Discussion

H_Sharma's avatar
H_Sharma
Level 6
10 years ago
Solved

SQL AND Oracle Policy

Hello Experts,

We have some SQLdatabase (Windows) and oracle(Windows & Linux)  Policies.

We are taking backups of the SQL databases and Oralce databases through scripts that are stored on the clients.

We need to know what databases are backing up though these scripts(SQL & Oracle) without login into these systems.

Pls help how can we do it as we have almost 160+ databases(SQL & Oracle) policies

Thanks.

7.6
Backing Up
Backup and Recovery
NetBackup
Reporting
Windows Server (2003-2008)
  • Marianne's avatar
    Marianne
    10 years ago

    With great difficulty...

    Well, not possible for Oracle because of the 'format string' in the script.

    All you will get on NBU master for Oracle is something like this:

    bplist -C <client-name> -t 4 -s <start-date> -e <end-date> -R /
    /exb_n2bm5bco_1_1392342936
    /exb_mabm02ko_1_1392170136

    For MS-SQL, the bplist output will have db name as part of the output:

    bplist -C <client-name> -t 15 -s <start-date> -e <end-date> -R /
    juneberry.MSSQL7.JUNEBERRY.db.pubs.~.7.001of003.20140920101716..C:\ 

     

    (Example output was copied from NBU manuals.)

1 Reply

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    With great difficulty...

    Well, not possible for Oracle because of the 'format string' in the script.

    All you will get on NBU master for Oracle is something like this:

    bplist -C <client-name> -t 4 -s <start-date> -e <end-date> -R /
    /exb_n2bm5bco_1_1392342936
    /exb_mabm02ko_1_1392170136

    For MS-SQL, the bplist output will have db name as part of the output:

    bplist -C <client-name> -t 15 -s <start-date> -e <end-date> -R /
    juneberry.MSSQL7.JUNEBERRY.db.pubs.~.7.001of003.20140920101716..C:\ 

     

    (Example output was copied from NBU manuals.)