a oracle restore question?

From: chengyaojin <cyaojin_at_yahoo.com>
Date: Thu, 15 Feb 2001 09:17:32 +0800
Message-ID: <96fap5$goq$1@mail.cn99.com>

I had done a Oracle backup test,process is: 1.backup datafile:jxj.dbf.bak
2.backup redo archive file

After much insert and delete operations,i delete the current datafile
'jxj.dbf'.

Now I begin restore operation:
1.restore datafile:mv jxj.dbf.bak jxj.dbf.because redo log is not deleted,i do nothing on redo log file.
2.In SQLplus I input
sql>recover datafile '/hdb/oracle/OraHome/oradata/demo/jxj.dbf'; ......
auto
¡­¡­
ORA-00279: change 325915 generated at 02/14/2001 15:10:30 needed for thread 1

ORA-00289: suggestion : /hdb/oracle/OraHome/admin/demo/arch/arch_1_208.arc
ORA-00280: change 325915 for thread 1 is in sequence #208
ORA-00278: log file '/hdb/oracle/OraHome/admin/demo/arch/arch_1_207.arc' no

longer needed for this recovery

Log applied.
Media recovery complete.
SQL>
SQL> archive log list

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /hdb/oracle/OraHome/admin/demo/arch
Oldest online log sequence     209
Next log sequence to archive   212
Current log sequence           212

Now I found a question,the datafile restore to #208 log,but the online log is
#212 or #211.
I found arch_1_209 , arch_1_210 and arch_1_211 in directory
'/hdb/oracle/OraHome/admin/demo/arch/',

no arch_1_211 file.

Do it mean that datafile had not been restored to the lastest status? Received on Wed Feb 14 2001 - 19:17:32 CST