run {
sql 'alter session set NLS_LANGUAGE = AMERICAN';
# sql 'alter session NLS_DATA_FORMAT='
allocate channel c1 type disk;
set command id to 'rman';
# setlimit channel c1 kbytes 2097150 maxopenfiles 32 readrate 200; # database backup
backup
# full
# skip offline
# skip readonly
skip inaccessible
tag back_db_full1
filesperset 10
format 'e:\oracle_rman1\postdata1.rman'
database;
# backup
# format 'e:\backup\ctl1orte.ora'
# (current controlfile);
release channel c1;
# archive log backup
allocate channel c2 type disk;
setlimit channel c2 kbytes 2097150 maxopenfiles 32 readrate 200;
sql 'alter system archive log current';
#sql 'alter system archive log all';
backup
filesperset 20
format 'f:\oracle_rman2\postlog2.rman'
archivelog from time 'SYSDATE-1' all
delete input;
# sql 'archive log stop';
# sql 'archive log start';
release channel c2;
}
大家能帮我把这个脚本解释一下吗?(能否依次解释下来,感激不尽)
另外,里面的一些备份脚本我能看懂一点,但好象还有一些别的语法,
是不是一定要学PL\SQL编程才行??
sql 'alter session set NLS_LANGUAGE = AMERICAN';
# sql 'alter session NLS_DATA_FORMAT='
allocate channel c1 type disk;
set command id to 'rman';
# setlimit channel c1 kbytes 2097150 maxopenfiles 32 readrate 200; # database backup
backup
# full
# skip offline
# skip readonly
skip inaccessible
tag back_db_full1
filesperset 10
format 'e:\oracle_rman1\postdata1.rman'
database;
# backup
# format 'e:\backup\ctl1orte.ora'
# (current controlfile);
release channel c1;
# archive log backup
allocate channel c2 type disk;
setlimit channel c2 kbytes 2097150 maxopenfiles 32 readrate 200;
sql 'alter system archive log current';
#sql 'alter system archive log all';
backup
filesperset 20
format 'f:\oracle_rman2\postlog2.rman'
archivelog from time 'SYSDATE-1' all
delete input;
# sql 'archive log stop';
# sql 'archive log start';
release channel c2;
}
大家能帮我把这个脚本解释一下吗?(能否依次解释下来,感激不尽)
另外,里面的一些备份脚本我能看懂一点,但好象还有一些别的语法,
是不是一定要学PL\SQL编程才行??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货