常用的一些rman备份恢复命令(四)
ount
RMAN>set dbid=3286265633;
RMAN>restore controlfile from autobackup maxseq 6;
RMAN>alter database mount;
RMAN>run {
2>set until time=’2007-7-26 21:07:00’
3>restore database;
4>recover database;
5>sql ‘alter database open resetlogs’;
6>}
不完全恢复后建议删除早期的所有备份并重新备份
RMAN>run{
2>delete noprompt backup;
3>delete noprompt copy;
4>backup database format=’/opt/ora_bak/%d_%s.pdf’;
5>sql ‘alter system archive log current’;}