Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: a oracle restore question?
Your files are out of sync,
return to a previous backup
or
STARTUP NOMOUNT
ALTER DATABASE OPEN RESETLOGS
Greetz,
Steven Brangers.
chengyaojin <cyaojin_at_yahoo.com> schreef in berichtnieuws
96fap5$goq$1_at_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 Fri Feb 23 2001 - 12:51:03 CST