SQWareProduction:oracle:etc:sqwora CreDb Jobs.cfg: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 8: | Line 8: | ||
IndicDba:$gvsqw_OraBin/sqwora_GatherIndicators.ksh -I <ORACLE_SID> | IndicDba:$gvsqw_OraBin/sqwora_GatherIndicators.ksh -I <ORACLE_SID> | ||
#RmanFull: Backup level 0 (full) | #RmanFull: Backup level 0 (full) with RMAN | ||
RmanFull:$gvsqw_OraBin/sqwora_RmanBackup.ksh -I <ORACLE_SID> -T i0 -Exec | RmanFull:$gvsqw_OraBin/sqwora_RmanBackup.ksh -I <ORACLE_SID> -T i0 -Exec | ||
#RmanInc: Backup level | #RmanInc: Backup level 1 (incremental) with RMAN | ||
RmanInc:$gvsqw_OraBin/sqwora_RmanBackup.ksh -I <ORACLE_SID> -T | RmanInc:$gvsqw_OraBin/sqwora_RmanBackup.ksh -I <ORACLE_SID> -T i1 -Exec | ||
#PurgeAlert: Purge log/trace files | #PurgeAlert: Purge log/trace files | ||
| Line 23: | Line 23: | ||
ExpFull:$gvsqw_OraBin/sqwora_Export.ksh -I <ORACLE_SID> -T full -H 2 -Exec | ExpFull:$gvsqw_OraBin/sqwora_Export.ksh -I <ORACLE_SID> -T full -H 2 -Exec | ||
# | #ExpdpFull: export full of database (expdp) | ||
ExpdpFull:$gvsqw_OraBin/sqwora_Expdp.ksh -I <ORACLE_SID> -T full -H 2 -Exec | |||
#ExpdpAllSchemas: export AllSchemas of database (expdp) + Structure | |||
ExpdpAllSchemas:$gvsqw_OraBin/sqwora_ExpdpAllSchemas.ksh -I <ORACLE_SID> -H 2 -Exec | |||
#ExpdpAllPDB: export AllPDB of database (expdp) | |||
ExpdpAllPDB:$gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -I <ORACLE_SID> -H 2 -Exec | |||
#NetBackup: run user backup command | |||
NetBackup:$gvsqw_OraBin/sqwora_NetBackup.ksh -I <ORACLE_SID> -Policy <Policy> -Schedule <Schedule> -Exec | |||
#RsyncBackup: run rsync command | |||
RsyncBackup:$gvsqw_OraBin/sqwora_RsyncBackup.ksh -I <ORACLE_SID> -Exec | |||
</pre> | </pre> | ||
<br> | <br> | ||
Latest revision as of 08:58, 18 December 2023
Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Jobs.cfg:
File content:
#IndicDba: Gather indicators DBAs IndicDba:$gvsqw_OraBin/sqwora_GatherIndicators.ksh -I <ORACLE_SID> #RmanFull: Backup level 0 (full) with RMAN RmanFull:$gvsqw_OraBin/sqwora_RmanBackup.ksh -I <ORACLE_SID> -T i0 -Exec #RmanInc: Backup level 1 (incremental) with RMAN RmanInc:$gvsqw_OraBin/sqwora_RmanBackup.ksh -I <ORACLE_SID> -T i1 -Exec #PurgeAlert: Purge log/trace files PurgeAlert:$gvsqw_OraBin/sqwora_PurgeAlert.ksh -I <ORACLE_SID> #GenAwr: Generate AWR reports GenAwr:$gvsqw_OraBin/sqwora_GenerateAwr.ksh -I <ORACLE_SID> #ExpFull: export full of database ExpFull:$gvsqw_OraBin/sqwora_Export.ksh -I <ORACLE_SID> -T full -H 2 -Exec #ExpdpFull: export full of database (expdp) ExpdpFull:$gvsqw_OraBin/sqwora_Expdp.ksh -I <ORACLE_SID> -T full -H 2 -Exec #ExpdpAllSchemas: export AllSchemas of database (expdp) + Structure ExpdpAllSchemas:$gvsqw_OraBin/sqwora_ExpdpAllSchemas.ksh -I <ORACLE_SID> -H 2 -Exec #ExpdpAllPDB: export AllPDB of database (expdp) ExpdpAllPDB:$gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -I <ORACLE_SID> -H 2 -Exec #NetBackup: run user backup command NetBackup:$gvsqw_OraBin/sqwora_NetBackup.ksh -I <ORACLE_SID> -Policy <Policy> -Schedule <Schedule> -Exec #RsyncBackup: run rsync command RsyncBackup:$gvsqw_OraBin/sqwora_RsyncBackup.ksh -I <ORACLE_SID> -Exec