Oracle Lesson #1: RMAN Backup (Oracle 8.1.7 @wintel32)Contents:1) RMAN Whole Image Backup (Manual)
2) RMAN Whole Image Backup (Auto)
3) RMAN Whole Icremental Backup (Level = 0)
4) RMAN Whole Icremental Backup (Level = 1)
5) RMAN Whole Icremental Backup (Level = 2)
-----------------------------------------
Task #1: RMAN Whole Image Backup (Manual)
-----------------------------------------
[commands.sql]:
rman
connect catalog rman817@rcat
connect target sys@practice
report schema;
@D:\home\task07_rman_backup\whole_image\whole_image.rcv
list copy;
list copy of controlfile;
exit;
[whole_image.rcv]:
run {
allocate channel d1 type disk;
copy
datafile 1 to 'D:\u02\oradata\practice\backup\whole_image\SYSTEM01.DBF',
datafile 2 to 'D:\u02\oradata\practice\backup\whole_image\RBS01.DBF',
datafile 3 to 'D:\u02\oradata\practice\backup\whole_image\USERS01.DBF',
datafile 4 to 'D:\u02\oradata\practice\backup\whole_image\TEMP01.DBF',
datafile 5 to 'D:\u02\oradata\practice\backup\whole_image\TOOLS01.DBF',
datafile 6 to 'D:\u02\oradata\practice\backup\whole_image\INDX01.DBF',
datafile 7 to 'D:\u02\oradata\practice\backup\whole_image\USER02.DBF',
datafile 8 to 'D:\u02\oradata\practice\backup\whole_image\USER03.DBF',
current controlfile to 'D:\u02\oradata\practice\backup\whole_image\CONTROL.CTL';
}
---------------------------------------
Task #2: RMAN Whole Image Backup (Auto)
---------------------------------------
[commands.sql]:
sqlplus system@practice
@D:\home\task07_rman_backup\whole_image_auto\whole_image_auto.sql
exit
rman
connect catalog rman817@rcat
connect target sys@practice
@D:\home\task07_rman_backup\whole_image_auto\whole_image_auto.rcv
list copy;
list copy of controlfile;
exit;
[whole_image_auto.rcv]:
set feedback off heading off verify off
set pagesize 0 linesize 100 trimspool on
define dir = 'D:\u02\oradata\practice\backup\whole_image_auto\'
define fil = 'D:\home\task07_rman_backup\whole_image_auto\whole_image_auto.rcv'
define div = '\'
spool &fil
prompt run {
prompt allocate channel d1 type disk;;
prompt copy
select 'datafile '
|| file#
|| ' to '
|| '''&dir.'
|| substr(name,(instr(name,'&div.',-1)+1))
|| ''','
from v$datafile;
prompt current controlfile to '&dir.CONTROL.CTL';;
prompt }
spool off
[whole_image_auto.rcv]:
run {
allocate channel d1 type disk;
copy
datafile 1 to 'D:\u02\oradata\practice\backup\whole_image_auto\SYSTEM01.DBF',
datafile 2 to 'D:\u02\oradata\practice\backup\whole_image_auto\RBS01.DBF',
datafile 3 to 'D:\u02\oradata\practice\backup\whole_image_auto\USERS01.DBF',
datafile 4 to 'D:\u02\oradata\practice\backup\whole_image_auto\TEMP01.DBF',
datafile 5 to 'D:\u02\oradata\practice\backup\whole_image_auto\TOOLS01.DBF',
datafile 6 to 'D:\u02\oradata\practice\backup\whole_image_auto\INDX01.DBF',
datafile 7 to 'D:\u02\oradata\practice\backup\whole_image_auto\USER02.DBF',
datafile 8 to 'D:\u02\oradata\practice\backup\whole_image_auto\USER03.DBF',
current controlfile to 'D:\u02\oradata\practice\backup\whole_image_auto\CONTROL.CTL';
}
-------------------------------------------------
Task #3: RMAN Whole Icremental Backup (Level = 0)
-------------------------------------------------
[commands.sql]:
rman
connect catalog rman817@rcat
connect target sys@practice
@D:\home\task07_rman_backup\whole_inc0\whole_inc0.rcv
list backup;
exit;
[whole_inc0.rcv]:
run {
allocate channel d1 type disk;
backup incremental level = 0
database
format 'D:\u02\oradata\practice\backup\whole_inc0\db_%d_%s_%p_%t'
tag = 'WHOLE_INC0';
}
-------------------------------------------------
Task #4: RMAN Whole Icremental Backup (Level = 1)
-------------------------------------------------
[commands.sql]:
rman
connect catalog rman817@rcat
connect target sys@practice
@D:\home\task07_rman_backup\whole_inc1\whole_inc1.rcv
list backup;
exit;
[whole_inc1.rcv]:
run {
allocate channel d1 type disk;
backup incremental level = 1 cumulative
database
format 'D:\u02\oradata\practice\backup\whole_inc1\db_%d_%s_%p_%t'
tag = 'WHOLE_INC1';
}
-------------------------------------------------
Task #5: RMAN Whole Icremental Backup (Level = 2)
-------------------------------------------------
[commands.sql]:
rman
connect catalog rman817@rcat
connect target sys@practice
@D:\home\task07_rman_backup\whole_inc2\whole_inc2.rcv
list backup;
exit;
[whole_inc2.rcv]:
run {
allocate channel d1 type disk;
backup incremental level = 2 cumulative
database
format 'D:\u02\oradata\practice\backup\whole_inc2\db_%d_%s_%p_%t'
tag = 'WHOLE_INC2';
}
|
%%
No comments:
Post a Comment