Hi all,

To practice recovery of a datafile, I created a tablespace test and in it a datafile test01.dbf. I changed the name of the datafile to test02.dbf and then tried to restore it from the backup using RMAN.
1. mv test01.dbf test02.dbf
2. rman target / catalog rman/[Email Address Removed] RMAN> sql "alter tablespace test offline immediate";
4. RMAN> restore datafile '/clar01/oradata/test01.dbf';
5. RMAN> recover datafile '/clar01/oradata/test01.dbf';

The restore worked fine, but for the recovery I got error ORA-279 in the alert logfile and the recovery is not proceeding. Can one of you experts help me.

Fri Jun 29 09:20:10 2007
Full restore complete of datafile 203 /clar01/oradata/test01.dbf
checkpoint is 163248975
Fri Jun 29 09:25:41 2007
alter database recover if needed
datafile 203
Fri Jun 29 09:25:41 2007
Media Recovery Datafile: 203
Media Recovery Start
Starting datafile 203 recovery in thread 1 sequence 121429
Datafile 203: '/clar01/oradata/test01.dbf'
Media Recovery Log
ORA-279 signalled during: alter database recover if needed
datafile 203
...

I have Oracle9i on a Unix platform.

Tony

Oracle LazyDBA home page