BrokeDBA

Backup recover of copy example

Jun 21st, 2020
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.66 KB | None | 0 0
  1. RUN {
  2. CONFIGURE DEFAULT DEVICE TYPE TO DISK FORMAT '$BACKUP_DIR/$today_date/F_%d_%T_%U';' ; # default
  3. ALLOCATE CHANNEL C1 DEVICE TYPE DISK;
  4. SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$BACKUP_DIR/$today_date/%F.ctl';
  5. RECOVER COPY OF DATABASE WITH TAG 'INC_BACKUP' UNTIL TIME 'SYSDATE-7';
  6. BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY DATAFILECOPY FORMAT '$BACKUP_DIR/$today_date/F_%d_%T_%U' WITH TAG 'INC_BACKUP' FORMAT '$BACKUP_DIR/$today_date/F_%d_%T_%U' DATABASE PLUS ARCHIVELOG FORMAT '$BACKUP_DIR/$today_date/arc_%d_%s_%T.bak' tag 'INC_BACKUP';
  7. DELETE NOPROMPT OBSOLETE DEVICE TYPE DISK ;
  8. RELEASE CHANNEL C1;
  9. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  10. }
Add Comment
Please, Sign In to add comment