Database Experts

  SOURCE (SourceDB - HOST - DBHOST01) TARGET (TargetDB - HOST - DBHOST02) STEP 1 ON SOURCE Take a full backup of source database Rman target / run { CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so,ENV=(STORAGE_UNIT=t1-OracleDB01,BACKUP_HOST=DBHOST01,RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent/)' FORMAT './%d/daily/%T_%d_Full_Daily_%s_%U'; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO './%d/daily/%T_%d_Control_%F'; BACKUP KEEP UNTIL TIME 'SYSDATE+8' RESTORE POINT 'MANUAL_FULL_03142023' FORCE NOEXCLUDE AS BACKUPSET TAG 'MANUAL_FULL_03142023' DATABASE; BACKUP AS BACKUPSET TAG '%TAG' ARCHIVELOG ALL NOT BACKED UP 2 TIMES FORMAT './%d/daily/%T_%d_arch_%s_%U'; CROSSCHECK BACKUP; DELETE NOPROMPT EXPIRED BACKUPSET; DELETE NOPROMPT OBSOLETE DEVICE TYPE 'SBT_TAPE'; DELETE NOPROMPT BACKUP OF ARCHIVELOG ...

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=221156612954064&id=2081655.1&_adf.ctrl-state=wze2k6dq0_53 Skip to content   Accessibility Preferences purgeLogs: Archive & Cleanup traces, logs in one command (Doc ID 2081655.1) To Bottom In this Document Abstract History Details   Manual cleanup, what is needed to do?   purgeLogs - Onebutton automation script   purgeLogs - Verbs   purgeLogs - Usage   Archive function   Cleanup function   Encapass function   How to Install purgelogs   PurgeLogs Usage Examples   purgeLogs - GI/RDBMS cleanup   purgeLogs - OSWatcher/ExaWatcher archive & OAK/DCS cleanup (on ODA - Oracle Database Appliance)   purgeLogs - Files from "extra" given folders   purgeLogs - GI/RDBMS, TFA, OSWatcher & OAK cleanup   purgeLogs - Cleanup listener logs   Setting up purgeLogs as crontab job   PurgeLogs Considerations   PurgeLogs inside TFA References...