Oracle Lesson #3: Implement Backup Strategy (Oracle 8.1.7 @wintel32)

Contents:

1) Create Directory Structure
2) Create RMAN Scripts
3) Create OS Scripts
4) Setup OS Jobs

----------------------------------- Task #1: Create Directory Structure ----------------------------------- [D:\u02\backup_strategy\]: mkdir backups mkdir cmd mkdir log mkdir rcv mkdir setup ---------------------------- Task #2: Create RMAN Scripts ---------------------------- [rcv\connect.rcv]: connect catalog rman817/rman@rcat connect target sys/change_on_install@practice [rcv\whole_inc_0.rcv]: @@connect.rcv run { allocate channel d1 type disk; backup incremental level = 0 database format 'D:\u02\backup_strategy\backups\db_%d_%s_%p_%t' tag = 'WHOLE_INC0'; } exit; [rcv\whole_inc_1.rcv]: @@connect.rcv run { allocate channel d1 type disk; backup incremental level = 1 cumulative database format 'D:\u02\backup_strategy\backups\db_%d_%s_%p_%t' tag = 'WHOLE_INC1'; } exit; [rcv\whole_inc_2.rcv]: @@connect.rcv run { allocate channel d1 type disk; backup incremental level = 2 cumulative database format 'D:\u02\backup_strategy\backups\db_%d_%s_%p_%t' tag = 'WHOLE_INC2'; } exit; [rcv\archive_2days.rcv]: @@connect.rcv run { allocate channel d1 type disk; sql "ALTER SYSTEM ARCHIVE LOG CURRENT"; backup archivelog from time 'SYSDATE-2' format 'D:\u02\backup_strategy\backups\ar_%d_%s_%p_%t'; } exit; [rcv\archive_delete3.rcv]: @@connect.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\backup_strategy\backups\ar_%d_%s_%p_%t' delete input; } exit; -------------------------- Task #3: Create OS Scripts -------------------------- [cmd\sunday.cmd]: %ORACLE_HOME%\bin\rman.exe cmdfile="D:\u02\backup_strategy\rcv\whole_inc_0.rcv" log="D:\u02\backup_strategy\log\sunday.log" [cmd\monday.cmd]: %ORACLE_HOME%\bin\rman.exe cmdfile="D:\u02\backup_strategy\rcv\whole_inc_2.rcv" log="D:\u02\backup_strategy\log\monday.log" [cmd\tuesday.cmd]: %ORACLE_HOME%\bin\rman.exe cmdfile="D:\u02\backup_strategy\rcv\whole_inc_2.rcv" log="D:\u02\backup_strategy\log\tuesday.log" [cmd\wednesday.cmd]: %ORACLE_HOME%\bin\rman.exe cmdfile="D:\u02\backup_strategy\rcv\whole_inc_2.rcv" log="D:\u02\backup_strategy\log\wednesday.log" [cmd\thursday.cmd]: %ORACLE_HOME%\bin\rman.exe cmdfile="D:\u02\backup_strategy\rcv\whole_inc_1.rcv" log="D:\u02\backup_strategy\log\thursday.log" [cmd\friday.cmd]: %ORACLE_HOME%\bin\rman.exe cmdfile="D:\u02\backup_strategy\rcv\whole_inc_2.rcv" log="D:\u02\backup_strategy\log\friday.log" [cmd\saturday.cmd]: %ORACLE_HOME%\bin\rman.exe cmdfile="D:\u02\backup_strategy\rcv\whole_inc_2.rcv" log="D:\u02\backup_strategy\log\saturday.log" [cmd\daily_1.cmd]: %ORACLE_HOME%\bin\rman.exe cmdfile="D:\u02\backup_strategy\rcv\archive_2days.rcv" log="D:\u02\backup_strategy\log\daily_1.log" [cmd\daily_2.cmd]: %ORACLE_HOME%\bin\rman.exe cmdfile="D:\u02\backup_strategy\rcv\archive_delete3.rcv" log="D:\u02\backup_strategy\log\daily_2.log" ---------------------- Task #4: Setup OS Jobs ---------------------- [setup\setup.cmd]: at 1:00 /every: Sunday cmd /c D:\u02\backup_strategy\cmd\sunday.cmd at 1:00 /every: Monday cmd /c D:\u02\backup_strategy\cmd\monday.cmd at 1:00 /every: Tueday cmd /c D:\u02\backup_strategy\cmd\tuesday.cmd at 1:00 /every: Wednesday cmd /c D:\u02\backup_strategy\cmd\wednesday.cmd at 1:00 /every: Thursday cmd /c D:\u02\backup_strategy\cmd\thursday.cmd at 1:00 /every: Friday cmd /c D:\u02\backup_strategy\cmd\friday.cmd at 1:00 /every: Saturday cmd /c D:\u02\backup_strategy\cmd\saturday.cmd at 2:00 cmd /c D:\u02\backup_strategy\cmd\daily_1.cmd at 2:30 cmd /c D:\u02\backup_strategy\cmd\daily_2.cmd

%%