Oracle Lesson #4: Implement Stored 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_strategy2\]:
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\all_scripts.rcv]:
@@connect.rcv
replace script whole_inc0 {
allocate channel d1 type disk;
backup incremental level = 0
database
format 'D:\u02\backup_strategy2\backups\db_%d_%s_%p_%t'
tag = 'WHOLE_INC0';
release channel d1;
}
replace script whole_inc1 {
allocate channel d1 type disk;
backup incremental level = 1 cumulative
database
format 'D:\u02\backup_strategy2\backups\db_%d_%s_%p_%t'
tag = 'WHOLE_INC1';
release channel d1;
}
replace script whole_inc2 {
allocate channel d1 type disk;
backup incremental level = 2 cumulative
database
format 'D:\u02\backup_strategy2\backups\db_%d_%s_%p_%t'
tag = 'WHOLE_INC2';
release channel d1;
}
replace script archive_log_current {
sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
}
replace script archive_2days {
allocate channel d1 type disk;
execute script archive_log_current;
backup archivelog from time 'SYSDATE-2'
format 'D:\u02\backup_strategy2\backups\ar_%d_%s_%p_%t';
release channel d1;
}
replace script archive_delete3 {
allocate channel d1 type disk;
execute script archive_log_current;
backup archivelog from time 'SYSDATE-3' until time 'SYSDATE-2'
format 'D:\u02\backup_strategy2\backups\ar_%d_%s_%p_%t'
delete input;
execute script archive_log_current;
}
exit;
[rcv\sunday.rcv]:
@@connect.rcv
run {
execute script whole_inc0;
execute script archive_2days;
execute script archive_delete3;
}
exit;
[rcv\monday.rcv]:
@@connect.rcv
run {
execute script whole_inc2;
execute script archive_2days;
execute script archive_delete3;
}
exit;
[rcv\tuesday.rcv]:
@@connect.rcv
run {
execute script whole_inc2;
execute script archive_2days;
execute script archive_delete3;
}
exit;
[rcv\wednesday.rcv]:
@@connect.rcv
run {
execute script whole_inc2;
execute script archive_2days;
execute script archive_delete3;
}
exit;
[rcv\thursday.rcv]:
@@connect.rcv
run {
execute script whole_inc1;
execute script archive_2days;
execute script archive_delete3;
}
exit;
[rcv\friday.rcv]:
@@connect.rcv
run {
execute script whole_inc2;
execute script archive_2days;
execute script archive_delete3;
}
exit;
[rcv\saturday.rcv]:
@@connect.rcv
run {
execute script whole_inc2;
execute script archive_2days;
execute script archive_delete3;
}
exit;
--------------------------
Task #3: Create OS Scripts
--------------------------
[cmd\all_scripts.cmd]:
%ORACLE_HOME%\bin\rman.exe
cmdfile="D:\u02\backup_strategy2\rcv\all_scripts.rcv"
log="D:\u02\backup_strategy2\log\all_scripts.log"
[cmd\sunday.cmd]:
%ORACLE_HOME%\bin\rman.exe
cmdfile="D:\u02\backup_strategy2\rcv\sunday.rcv"
log="D:\u02\backup_strategy2\log\sunday.log"
[cmd\monday.cmd]:
%ORACLE_HOME%\bin\rman.exe
cmdfile="D:\u02\backup_strategy2\rcv\monday.rcv"
log="D:\u02\backup_strategy2\log\monday.log"
[cmd\tuesday.cmd]:
%ORACLE_HOME%\bin\rman.exe
cmdfile="D:\u02\backup_strategy2\rcv\tuesday.rcv"
log="D:\u02\backup_strategy2\log\tuesday.log"
[cmd\wednesday.cmd]:
%ORACLE_HOME%\bin\rman.exe
cmdfile="D:\u02\backup_strategy2\rcv\wednesday.rcv"
log="D:\u02\backup_strategy2\log\wednesday.log"
[cmd\thursday.cmd]:
%ORACLE_HOME%\bin\rman.exe
cmdfile="D:\u02\backup_strategy2\rcv\thursday.rcv"
log="D:\u02\backup_strategy2\log\thursday.log"
[cmd\friday.cmd]:
%ORACLE_HOME%\bin\rman.exe
cmdfile="D:\u02\backup_strategy2\rcv\friday.rcv"
log="D:\u02\backup_strategy2\log\friday.log"
[cmd\saturday.cmd]:
%ORACLE_HOME%\bin\rman.exe
cmdfile="D:\u02\backup_strategy2\rcv\saturday.rcv"
log="D:\u02\backup_strategy2\log\saturday.log"
----------------------
Task #4: Setup OS Jobs
----------------------
[setup\setup.cmd]:
D:\u02\backup_strategy2\cmd\all_scripts.cmd
at 1:00 /every: Sunday cmd /c D:\u02\backup_strategy2\cmd\sunday.cmd
at 1:00 /every: Monday cmd /c D:\u02\backup_strategy2\cmd\monday.cmd
at 1:00 /every: Tueday cmd /c D:\u02\backup_strategy2\cmd\tuesday.cmd
at 1:00 /every: Wednesday cmd /c D:\u02\backup_strategy2\cmd\wednesday.cmd
at 1:00 /every: Thursday cmd /c D:\u02\backup_strategy2\cmd\thursday.cmd
at 1:00 /every: Friday cmd /c D:\u02\backup_strategy2\cmd\friday.cmd
at 1:00 /every: Saturday cmd /c D:\u02\backup_strategy2\cmd\saturday.cmd
|
%%
No comments:
Post a Comment