oracle 不完全恢复

备份归档日志，指定恢复日志序列号：

##恢复归档日志，启动数据库

#备份并删除归档日志
export ORACLE_SID=hec
rman target /
backup archivelog all format '/ccibak/hec/arc/arc%U.bak' delete all input;
#thread=1 sequence=62132 RECID=62128


#注册备份文件，并执行不完全恢复
catalog start with '/ccibak/hec/arc/';
recover database until  sequence 62090xxxxx thread 1;
alter database open resetlogs;  



export ORACLE_SID=jyds
rman target /
backup archivelog all format '/ccibak/jyds/arc/arc%U.bak'delete all input;

catalog start with '/ccibak/jyds/arc/';
recover database until  sequence 176199xxxxx thread 1;
alter database open resetlogs;