我rman用的是nocatalog,这两天看043题目,发现nocatalog的时候,备份文件meatadata是在controlfile里面的,而control_file_record_keep_time参数决定controlfile里面备份元数据的保留时间。
rman脚本是:
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup format '/。。。/full%u_%s_%p' database include current controlfile;
sql 'alter system archive log current';
backup filesperset 3 format '。。。/arch%u_%s_%p'
archivelog all delete input;
release channel c1;
release channel c2;
release channel c3;
}
EOF
echo "`date` backup successful"
exit;
control_file_record_keep_time参数的值是:
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
我现在有疑问的是,我一直在备份近三个月的rman备份集,是不是只有7天内的备份集有效,其他的备份集已经不能用了呢?
[ 本帖最后由 vegas_lee 于 2009-8-21 15:01 编辑 ]
rman脚本是:
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup format '/。。。/full%u_%s_%p' database include current controlfile;
sql 'alter system archive log current';
backup filesperset 3 format '。。。/arch%u_%s_%p'
archivelog all delete input;
release channel c1;
release channel c2;
release channel c3;
}
EOF
echo "`date` backup successful"
exit;
control_file_record_keep_time参数的值是:
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
我现在有疑问的是,我一直在备份近三个月的rman备份集,是不是只有7天内的备份集有效,其他的备份集已经不能用了呢?
[ 本帖最后由 vegas_lee 于 2009-8-21 15:01 编辑 ]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17307809/viewspace-613496/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17307809/viewspace-613496/