RMAN Point in Time Recovery: ORA-01194: file 1 needs more recovery to be consistent

[kgb]

trace.txtHi,
I am restring database to a point in time. I have all backup files, however I keep getting error:

Command:

run{
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;
ALLOCATE CHANNEL c3 DEVICE TYPE disk;
ALLOCATE CHANNEL c4 DEVICE TYPE disk;
set until time "to_date('01/01/2014 05:00:00' , 'dd/mm/yyyy hh24:mi:ss')";
RESTORE DATAFILE 1;
recover database SKIP TABLESPACE WORKBENCH_DATA;
}

Output:

………
Executing: alter database datafile 4 offline
Executing: alter database datafile 72 offline
Executing: alter database datafile 73 offline
Executing: alter database datafile 38 offline
Executing: alter database datafile 74 offline
Executing: alter database datafile 75 offline
starting media recovery

archived log for thread 1 with sequence 1813 is already on disk as file /u10/FPESSP01_SITE2/datafile/1_1813_829250679.arch
archived log for thread 1 with sequence 1814 is already on disk as file /u10/FPESSP01_SITE2/datafile/1_1814_829250679.arch
archived log file name=/u10/FPESSP01_SITE2/datafile/1_1813_829250679.arch thread=1 sequence=1813
archived log file name=/u10/FPESSP01_SITE2/datafile/1_1814_829250679.arch thread=1 sequence=1814
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u10/FPESSP01_SITE2/datafile/1.dbf'

media recovery complete, elapsed time: 00:00:10
Finished recover at 02-JAN-14
released channel: c1
released channel: c2
released channel: c3
released channel: c4

RMAN>

Directory has the following ARCH files, but it does not use them:


oracle@chzrhkorap04:/u10/FPESSP01_SITE2/datafile/ [SPHPRD1] ls *.arch
1_1808_829250679.arch 1_1812_829250679.arch 1_1816_829250679.arch 1_1820_829250679.arch 1_1824_829250679.arch
1_1809_829250679.arch 1_1813_829250679.arch 1_1817_829250679.arch 1_1821_829250679.arch 1_1825_829250679.arch
1_1810_829250679.arch 1_1814_829250679.arch 1_1818_829250679.arch 1_1822_829250679.arch 1_1826_829250679.arch
1_1811_829250679.arch 1_1815_829250679.arch 1_1819_829250679.arch 1_1823_829250679.arch


The following arch file is not corrupted:

RMAN> catalog start with '/u10/FPESSP01_SITE2/datafile/temp/';

searching for all files that match the pattern /u10/FPESSP01_SITE2/datafile/temp/

List of Files Unknown to the Database
=====================================
File Name: /u10/FPESSP01_SITE2/datafile/temp/1_1815_829250679.arch

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u10/FPESSP01_SITE2/datafile/temp/1_1815_829250679.arch



Attached file has an some errors.
Any advice will be very much appreciated.