Re: RMAN backups - EBS database 19c

Posted by ErmanArslansOracleBlog on Feb 07, 2023; 7:57am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-backups-EBS-database-19c-tp11562p11566.html

What do you mean "by output truncates?"
Did you check those database views to see if your rman backup was successful or not. ->  some examples:

SELECT SESSION_KEY, INPUT_TYPE, STATUS,
       TO_CHAR(START_TIME,'mm/dd/yy hh24:mi') start_time,
       TO_CHAR(END_TIME,'mm/dd/yy hh24:mi')   end_time,
       ELAPSED_SECONDS/3600                   hrs
FROM V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;

SELECT SESSION_KEY,
       OPTIMIZED,
       COMPRESSION_RATIO,
       INPUT_BYTES_PER_SEC_DISPLAY in_sec,
       OUTPUT_BYTES_PER_SEC_DISPLAY out_sec,
       TIME_TAKEN_DISPLAY
FROM   V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;

SELECT SESSION_KEY,
       INPUT_TYPE,
       COMPRESSION_RATIO,
       INPUT_BYTES_DISPLAY in_size,
       OUTPUT_BYTES_DISPLAY out_size
FROM   V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;

Here is an example script for EBS 19C backup: (just an example.. Those delete and backup command depends on your environment's backup and retention (and storage) policies.

. /erp/oracle/R12ERMAN/db/tech_st/19.0.0/R12PRODC_erpr12db.env

rman target /
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE - 3';
BACKUP AS COMPRESSED BACKUPSET incremental level 0 section size 500g tag '$TAG_CTEXT' (database format '$BACKUP_FOLDER/%d_L0_%s_%U');
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL NOT BACKED UP 1 TIMES FORMAT '$BACKUP_FOLDER/%d_ARC_BCK_%U_%s_%T' tag='$TAG_TEXT';
backup tag '$TAG_TEXT' (current controlfile format '$BACKUP_FOLDER/%d_ctl_%s_%U');
DELETE NOPROMPT FORCE OBSOLETE;
DELETE NOPROMPT OBSOLETE;
delete noprompt backup of ARCHIVELOG UNTIL TIME='sysdate-10' BACKED UP 1 TIMES TO DISK;