1,first you must have a full backup of database before;
RMAN> backup database;
2,SQL> shutdown immediate
3,sql> startup nomount;
4,RMAN> restore controlfile from '/data/ora10g/0tma6r4d_1_1'; --restore controlfile;
5,RMAN> shutdown immediate
6,RMAN> startup mount
7,RMAN> restore database;
8,RMAN> run{
sql 'alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"';
set until time '2011-04-19 21:56:27';
recover database;
}
9, RMAN> alter database open RESETLOGS;
10, RMAN> backup database; --quickly
转载于:https://blog.51cto.com/itbull/1048423