SQWareProduction:oracle:etc:sqwora CreDb Jobs.cfg: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
m Updated by BatchUser  | 
				m Updated by BatchUser  | 
				||
| (One intermediate revision 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 1 (incremental)   | #RmanInc: Backup level 1 (incremental) with RMAN  | ||
RmanInc:$gvsqw_OraBin/sqwora_RmanBackup.ksh -I <ORACLE_SID> -T i1 -Exec    | RmanInc:$gvsqw_OraBin/sqwora_RmanBackup.ksh -I <ORACLE_SID> -T i1 -Exec    | ||
| Line 25: | Line 25: | ||
#ExpdpFull: export full of database (expdp)  | #ExpdpFull: export full of database (expdp)  | ||
ExpdpFull:$gvsqw_OraBin/sqwora_Expdp.ksh -I <ORACLE_SID> -T full -H 2 -Exec    | 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: run user backup command  | ||
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