<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
设置保留最近的7次备份<br style="background-color:inherit;" />
RMAN> configure retention policy to redundancy 3; 保留三分备份
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
RMAN> configure retention policy to recovery window of 7 days; 备份策略保留7天内的备份
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
查看过期的RMAN备份
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
RMAN> report obsolete;
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
<br />
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
遍历检索备份集
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
RMAN> crosscheck backup;
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
<br />
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
查看所有RMAN备份<br style="background-color:inherit;" />
RMAN> list backup;
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
删除过期RMAN备份<br style="background-color:inherit;" />
RMAN> delete obsolete;
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
<br />
</p>
<p style="background-color:#FAFAFC;color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;">
删除介质中不存在的备份信息
</p>
RMAN> delete expired backup；
<div>
<br />
</div>
<div>
遍历检索归档信息
</div>
<div>
<div>
crosscheck archivelog all；
</div>
<div>
<br />
</div>
<div>
删除作废的备份信息
</div>
<div>
delete expired archivelog all；
</div>
</div>
<div>
<br />
</div>
<div>
删除7天前的归档
</div>
<div>
delete archivelog all completed before 'sysdate-7';
</div>
<div>
删除1小时前的归档
</div>
<div>
delete archivelog all completed before 'sysdate-1/24'
</div>
<div>
<br />
</div>
<div>
<br />
</div>
<div>
<br />
</div>
<div>
<span style="background-color:#FAFAFA;font-size:1em;line-height:1.5;white-space:normal;font-family:Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace;"> </span><br style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;" />
<p style="background-color:#FAFAFC;font-size:14px;line-height:21px;white-space:normal;color:#333333;font-family:tahoma, 宋体;text-align:justify;">
<span style="background-color:#FFFFFF;color:#FF0000;font-family:宋体, 'Arial Narrow', arial, serif;text-align:start;"></span>
</p>
</div>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29108856/viewspace-2146117/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
