restore database;修复数据库
restore database delete archivelogs skip tablespace temp;修复数据库的时删除恢复过程中的归档文件，并且跳过表空间

恢复表空间users

RMAN> SQL ' alter tablespace users offline';

sql 语句:  alter tablespace users offline

RMAN> restore tablespace users;
RMAN> recover  tablespace users;


恢复数据文件
sql 'alter database datafile 1 offline';
restore datafile 1 ;
recover datafile 1;

run{
set newname for datafile 3 format '地址';
restore datafile 3;
recover datafile 3;
}


恢复归档日志文件
restore archivelog sequence between 20 and 30;

run{
set archivelog destination to 'e:/app/rman/recover/archive';
restore archivelog sequence between 30 and 35;
}


以startup nomount 模式启动
restore controlfile from 'e:/app/orcl/autobackup';

restore controlfile to 'e:/app/orcl/control04.ctl' from autobackup;


设置 控制文件自动备份的路径
set controlfile autobackup format for device type disk to 'e:/app/rman/recover/recover_ctl';

restore spfile from autobackup;

restore spfile to 'destination' from autobackup;



归档情况下，无备份照样能恢复因为有重做日志文件
create tablespace test1 datafile 'e:/app/rman/test.dbf' size 10m;
create user test1 identified by test1 default tablespace test1 ;

grant connect,resource to test1;

create table test1(id number);
insert into test1 values(1);

del e:/app/rman/test.dbf

alter database create datafile 'e:/app/rman/test.dbf' as 'e:/app/rman/test.dbf';

recover datafile 11


归档情况下丢失控制文件
恢复的控制文件


归档情况下丢失非联机重做日志

alter database clear logfile group 1;

丢失联机重做日志

alter system set "_allow_resetlogs_corruption" = true scope=spfile

recover database until cancel;