Dear all,
10gr2p4 on solaris 10
Am on the process of recovering a DB until time
SQL> RECOVER DATABASE until time '2010-01-15:20:00:00' using backup controlfile;
ORA-00279: change 4834006073 generated at 01/14/2010 01:50:12 needed for thread
1
ORA-00289: suggestion : /u07/aux/arch/ICON1_212667_661522334.arc
ORA-00280: change 4834006073 for thread 1 is in sequence #212667
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u07/aux/arch/ICON1_212668_661522334.arc
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: '/u07/aux/arch/ICON1_212668_661522334.arc'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 2 needs more recovery to be consistent
ORA-01110: data file 2: '/u01/aux/data/undotbs01.dbf'
SQL> RECOVER DATABASE until time '2010-01-15:20:00:00' using backup controlfile;
ORA-00279: change 4834006073 generated at 01/14/2010 01:50:12 needed for thread
1
ORA-00289: suggestion : /u07/aux/arch/ICON1_212667_661522334.arc
ORA-00280: change 4834006073 for thread 1 is in sequence #212667
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
how to overcome this error :
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: '/u07/aux/arch/ICON1_212668_661522334.arc'
I tried restoring the file again from tape , but same error occured again. ?. Please advise how to proceed with this ?
Ka