1、rman恢复
准备:
a.用rman全备数据库
RMAN> backup database format 'E:/oracle/rmanbak/orclrman_%U';
b.执行归档
RMAN> sql 'alter system archive log current';
c.0级备份同时备份归档文件
RMAN> backup incremental level 0 database format 'e:/oracle/rmanbak/all_%U';
d.在表T中增加一条记录
e.1级备份
f.删除数据文件
1.启动数据库到mount状态
2.执行RMAN> restore database;
3.执行RMAN> recover database;
4.执行RMAN> alter database open;
5.验证
当文件所在磁盘损坏的情况下,可重新设定路径
RMAN > run{
set newname for datafile 7 to 'e:/oralce/app.dbf'; ---更改路径
restore database;
switch datafile all; ---更新控制文件
recover database;
alter database on;
}
2.恢复表空间
run{
sql 'alter tablespace app offline immediate;
restore tablespace app;
recover tablespace app;
sql 'alter tablespace app online';
}
2.RMAN不完全恢复
RMAN > RUN{
allocate channel c1 type disk;
allocate channel c2 type disk;
set until time = "to_date('2010-09-05:17:29:00','yyyy-mm-dd:hh24:mi:ss')";
restore database;
recover database;
alter database open resetlogs;
}