Can you explain in detail what you're trying to do? Restore a database from scratch, restore just a lost controlfile, or recover from a specific data loss situation? Cheers, Phil On Wed, Aug 22, 2012 at 12:14 PM, Nisha Mohan <NishaMohan_A@xxxxxxxxxxx>wrote: > Hi, > Oracle version :10.2.04 > I recovered control files . > RMAN> restore controlfile to '/oracle/ora10gr4/dbs/nis.ctl'; > > Starting restore at 21-AUG-12 > using channel ORA_DISK_1 > > channel ORA_DISK_1: starting datafile backupset restore > channel ORA_DISK_1: restoring control file > output filename=/oracle/ora10gr4/dbs/nis.ctl > channel ORA_DISK_1: reading from backup piece > /data_idx1/ORAMIG/OMIGTEST/cfc-260103938-20120821-03 > channel ORA_DISK_1: restored backup piece 1 > piece handle=/data_idx1/ORAMIG/OMIGTEST/cfc-260103938-20120821-03 > tag=TAG20120821T152259 > channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 > Finished restore at 21-AUG-12 > > > after this i got the below error when i tried to open DB. > SQL> alter database open resetlogs; > alter database open resetlogs > * > ERROR at line 1: > ORA-01152: file 1 was not restored from a sufficiently old backup > ORA-01110: data file 1: > '/data_idx1/ORAMIG/OMIGTEST/DATA_FILES/system_1_OMIGTEST.dbf' > > > -- //www.freelists.org/webpage/oracle-l