creating datafile fno= 1  name=F:\ORADATA\ххх\SYSTEM01.DBF
released channel: c1
RMAN- 00571 : ===========================================================
RMAN- 00569 : =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN- 00571 : ===========================================================
RMAN- 03002 : failure of restore command at  10 / 28 / 2011   12 : 49 : 34 
ORA- 01180 : can not create datafile  1 
ORA- 01110 : data file  1 : 'F:\ORADATA\ххх\SYSTEM01.DBF'

crosscheck backup database;
delete expired backup database;
catalog start with 'каталог с бэкапом';

Oracle Error:
ORA- 01547 : warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA- 01152 : file  1  was not restored from a sufficiently old backup
ORA- 01110 : data file  1 : 'F:\ORADATA\ххх\SYSTEM01.DBF'

ORA- 01547 : warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA- 01152 : file  1  was not restored from a sufficiently old backup
ORA- 01110 : data file  1 : 'F:\ORADATA\SPASG2\SYSTEM01.DBF'

Oracle Error:
ORA- 01547 : warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA- 01152 : file  1  was not restored from a sufficiently old backup
ORA- 01110 : data file  1 : 'F:\ORADATA\xxx\SYSTEM01.DBF'

released channel: c1
RMAN- 00571 : ===========================================================
RMAN- 00569 : =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN- 00571 : ===========================================================
RMAN- 03002 : failure of recover command at  10 / 28 / 2011   18 : 03 : 50 
RMAN- 06053 : unable to perform media recovery because of missing log
RMAN- 06025 : no backup of log thread  1  seq  43036  lowscn  1128764343  found to restore
RMAN- 06025 : no backup of log thread  1  seq  43035  lowscn  1128757259  found to restore
RMAN- 06025 : no backup of log thread  1  seq  43034  lowscn  1128742652  found to restore
RMAN- 06025 : no backup of log thread  1  seq  43033  lowscn  1128727322  found to restore
RMAN- 06025 : no backup of log thread  1  seq  43032  lowscn  1128711970  found to restore

run
{
  allocate channel c1 DEVICE TYPE DISK FORMAT 'C:\oracle\fl_rec\ora_df%t_s%s_s%p';
  allocate channel c2 DEVICE TYPE DISK FORMAT 'G:\fl_rec\ora_df%t_s%s_s%p';

  change archivelog all crosscheck;

  BACKUP AS COMPRESSED BACKUPSET DATABASE FILESPERSET  5  include current controlfile;

  sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
  backup filesperset  100  archivelog all format 'f:\archlog\arc__%p%d.%s' delete input;

  release channel c1;
  release channel c2;
}

include current controlfile

Fri Oct  28   04 : 57 : 24   2011 
Starting control autobackup
Control autobackup written to DISK device
	handle 'C:\ORACLE\PRODUCT\10\DATABASE\C-4184186565-20111028-00'
Fri Oct  28   04 : 57 : 26   2011 
ALTER SYSTEM ARCHIVE LOG
Fri Oct  28   04 : 57 : 26   2011 
Thread  1  advanced to log sequence  43036  (LGWR switch)
  Current log#  23  seq#  43036  mem#  0 : D:\ORADATA\SPASG2\REDO23D.LOG
  Current log#  23  seq#  43036  mem#  1 : G:\ORADATA\SPASG2\REDO23G.LOG
Fri Oct  28   04 : 57 : 27   2011 
ALTER SYSTEM ARCHIVE LOG
Fri Oct  28   04 : 57 : 27   2011 
Thread  1  advanced to log sequence  43037  (LGWR switch)
  Current log#  24  seq#  43037  mem#  0 : D:\ORADATA\SPASG2\REDO24D.LOG
  Current log#  24  seq#  43037  mem#  1 : G:\ORADATA\SPASG2\REDO24G.LOG
Fri Oct  28   04 : 58 : 37   2011 
Starting control autobackup
Control autobackup written to DISK device
	handle 'C:\ORACLE\PRODUCT\10\DATABASE\C-4184186565-20111028-01'
Fri Oct  28   08 : 27 : 01   2011 

RUN { allocate channel c1 device type disk;
      allocate channel c2 device type disk;

SET NEWNAME FOR DATAFILE 'E:\xxx\xxx.DBF' to 'G:\xxx\xxx.DBF';
...........
SET NEWNAME FOR DATAFILE 'H:\xxx\zzz.DBF' to 'F:\xxx\zzz.DBF'; 

RESTORE DATABASE ;
SWITCH DATAFILE ALL;
RECOVER DATABASE ;
alter database open resetlogs;
}

RMAN> restore controlfile from autobackup;

Starting restore at  31 -OCT- 11 
using channel ORA_DISK_1

recovery area destination: C:\oracle\flash_recovery_area
database name (or database unique name) used for search: SPASG2
channel ORA_DISK_1: no autobackups found in the recovery area
channel ORA_DISK_1: looking for autobackup on day:  20111031 
channel ORA_DISK_1: looking for autobackup on day:  20111030 
channel ORA_DISK_1: looking for autobackup on day:  20111029 
channel ORA_DISK_1: looking for autobackup on day:  20111028 
channel ORA_DISK_1: looking for autobackup on day:  20111027 
channel ORA_DISK_1: looking for autobackup on day:  20111026 
channel ORA_DISK_1: looking for autobackup on day:  20111025 
channel ORA_DISK_1: no autobackup in  7  days found
RMAN- 00571 : ===========================================================
RMAN- 00569 : =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN- 00571 : ===========================================================
RMAN- 03002 : failure of restore command at  10 / 31 / 2011   11 : 16 : 35 
RMAN- 06172 : no autobackup found or specified handle is not a valid copy or piece

RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
 1         1        SPASG2    4184186565        CURRENT  1            06 -NOV- 10 

RMAN- 06053 : unable to perform media recovery because of missing log
RMAN- 06025 : no backup of log thread  1  seq  43036  lowscn  1128764343  found to restore
RMAN- 06025 : no backup of log thread  1  seq  43035  lowscn  1128757259  found to restore
RMAN- 06025 : no backup of log thread  1  seq  43034  lowscn  1128742652  found to restore
RMAN- 06025 : no backup of log thread  1  seq  43033  lowscn  1128727322  found to restore
RMAN- 06025 : no backup of log thread  1  seq  43032  lowscn  1128711970  found to restore

RMAN- 03002 : failure of restore command at  11 / 07 / 2011   11 : 39 : 19 
ORA- 01180 : can not create datafile  1 
ORA- 01110 : data file  1 : 'F:\хх\SYSTEM01.DBF'