Well, I'm the SQL Server DBA here, and we have a Oracle Senior Dba that manages Oracle Databases and users. I'm curious about how he is handling these servers/users.
What is the best approach, when running oracle, to make backups?
If I'm not mistaken, dumps are not backups. right?
What he does here is:
1)A script create a dynamic query with EXPDP for ALL users and sent it to a TXT file:
SELECT 'EXPDP parfile=export_options.par dumpfile='
|| to_char(sysdate, 'YYYYMMDD_')
|| username
|| '_ServerName.dmp log='
|| to_char(sysdate, 'YYYYMMDD_')
|| username
|| '_ServerName.log schemas='
|| USERNAME
|| ' directory=dumpdir compression=ALL schemas=' || USERNAME
FROM dba_users
where created > '01/01/2005' and username not in (Some users)
order by created desc
2)then it creates a lot of EXPDPs inside a txt file:
EXPDP parfile=export_options.par dumpfile=20190221_USER_SERVER.dmp log=20190221_USER_SERVER.log schemas=USERdirectory=dumpdir compression=ALL schemas=USER
EXPDP parfile=export_options.par dumpfile=20190221_USER_SERVER.dmp log=20190221_USER_SERVER.log schemas=USERdirectory=dumpdir compression=ALL schemas=USER
EXPDP parfile=export_options.par dumpfile=20190221_USER_SERVER.dmp log=20190221_USER_SERVER.log schemas=USERdirectory=dumpdir compression=ALL schemas=USER
3)a WINDOWS TASK SCHEDULER runs this TXT running EXPDP on all users and sending them do a folder.
Is this something that you guys normally do on Oracle? I would like to now if this is something I could use as a best pratice.
Thanks.