Database Software

Hi

I use old backup set in tape and restore all datafile completed but I cannot recover that show below errror in RMAN

---------------------------------------------------------------------------------------------------------------------------------------------------------------------
RMAN> recover database;

Starting recover at 08-SEP-09
using channel ORA_DISK_1

starting media recovery

unable to find archive log
archive log thread=1 sequence=29166
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/08/2009 21:49:36
RMAN-06054: media recovery requesting unknown log: thread 1 seq 29166 lowscn 1648727512

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

But in backup set and include archive log already that don't have seq 29166 that have last seg is 29165 when I tyr recover in sqlplus that show below error

---------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL> recover database using backup controlfile;
ORA-00279: change 1648727512 generated at 09/05/2009 00:02:07 needed for thread
1
ORA-00289: suggestion : /oradata/archive/hrprd/1_29166_671345511.arc
ORA-00280: change 1648727512 for thread 1 is in sequence #29166


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/oradata/archive/hrprd/1_29166_671345511.arc'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
---------------------------------------------------------------------------------------------------------------------------------------------------------------------

And I tried to open with reset log that show below error

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oradata/data/hrprd/system01.dbf'

---------------------------------------------------------------------------------------------------------------------------------------------------------------------


How can I do to open database?


Taohiko.