Oracle Lesson #2: RMAN Backup Archive Logs (Oracle 8.1.7 @wintel32)

Contents:

1) RMAN Backup Archive Logs (All)
2) RMAN Backup Archive Logs (1+2 days ago)
3) RMAN Backup Archive Logs (3 days ago with delete)

--------------------------------------- Task #1: RMAN Backup Archive Logs (All) --------------------------------------- [commands.sql]: rman connect catalog rman817@rcat connect target sys@practice @D:\home\lesson02\archive_all\archive_all.rcv list backup; exit; [archive_all.rcv]: run { allocate channel d1 type disk; sql "ALTER SYSTEM ARCHIVE LOG CURRENT"; backup archivelog all format 'D:\u02\oradata\practice\backup\archive_all\ar_%d_%s_%p_%t'; } ------------------------------------------------ Task #2: RMAN Backup Archive Logs (1+2 days ago) ------------------------------------------------ [commands.sql]: rman connect catalog rman817@rcat connect target sys@practice @D:\home\lesson02\archive_2days\archive_2days.rcv list backup; exit; [archive_2days.rcv]: run { allocate channel d1 type disk; sql "ALTER SYSTEM ARCHIVE LOG CURRENT"; backup archivelog from time 'SYSDATE-2' format 'D:\u02\oradata\practice\backup\archive_2days\ar_%d_%s_%p_%t'; } ---------------------------------------------------------- Task #3: RMAN Backup Archive Logs (3 days ago with delete) ---------------------------------------------------------- [commands.sql]: rman connect catalog rman817@rcat connect target sys@practice @D:\home\lesson02\archive_delete3\archive_delete3.rcv list backup; exit; [archive_delete3.rcv]: run { allocate channel d1 type disk; sql "ALTER SYSTEM ARCHIVE LOG CURRENT"; backup archivelog from time 'SYSDATE-3' until time 'SYSDATE-2' format 'D:\u02\oradata\practice\backup\archive_delete3\ar_%d_%s_%p_%t' delete input; }

%%