Difference between revisions of "SQWareProduction:oracle:etc:sqwora CreDb Jobs.cfg"
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 09: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
