SQL AND Oracle Policy

[H_Sharma]

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.

[Marianne · Accepted solution]

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.)