Oracle 数据库在archivelog模式下文件丢失的恢复

step1
在联机时做备份(基于恢复目录的备份，做了控制文件的自动备份)，包括所有数据文件及归档的日志文件：
rman>run{
backup format 'c:\bak\test_full_%u' database;
sql 'alter system archive log current';
backup format 'c:\bak\test_log_%u' archivelog all delete input;
}
step2
sql>insert into lsf.aa values('a','b');
sql>commit;
sql>alter system switch logfile;
rman>shutdown immediate;
手动删除所有文件(控制文件、数据文件、联机日志文件)
step3
RMAN> startup nomount;
RMAN> restore controlfile from autobackup;
RMAN> alter database mount;
step4
RMAN> list backup of archivelog from time='sysdate-2';