Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SOS : error when recover datafile : ORA-00279

Re: SOS : error when recover datafile : ORA-00279

From: michael ngong <mngong_at_yahoo.com>
Date: 25 Sep 2002 08:09:13 -0700
Message-ID: <ecf365d5.0209250709.ad7b9b2@posting.google.com>


violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote in message news:<d22954a4.0209250301.edb14a8_at_posting.google.com>...
> Hello,
>
> Sorry for cross posting , since it's urgent for me.
> Our PROD database has one datafile needed recovery.
>
> SQL> select * from v$recover_file;
>
> FILE# ONLINE ERROR CHANGE# TIME
> --------- -------------- ------------------------------ --------- ---------
> 297 OFFLINE 5.965E+12 23-SEP-02
>
> SQL> select name , status from v$datafile where file# = 297;
>
> NAME STATUS
> ------------------------------ --------------
> /u03/proddata/itgx01.dbf RECOVER
>
> SQL>
> SQL> select min(SEQUENCE#) , max(SEQUENCE#) from v$recovery_log;
>
> MIN(SEQUENCE#) MAX(SEQUENCE#)
> -------------- --------------
> 6977 7016
>
> SQL> select * from v$recovery_log;
>
> THREAD# SEQUENCE# TIME ARCHIVE_NAME
> ---------- ---------- --------------- ------------------------------
> 1 6977 23-SEP-02 /u03/prodarch/prod6977.arc
> 1 6978 23-SEP-02 /u03/prodarch/prod6978.arc
> 1 6979 23-SEP-02 /u03/prodarch/prod6979.arc
> 1 6980 23-SEP-02 /u03/prodarch/prod6980.arc
> 1 6981 23-SEP-02 /u03/prodarch/prod6981.arc
> 1 6982 23-SEP-02 /u03/prodarch/prod6982.arc
> 1 6983 23-SEP-02 /u03/prodarch/prod6983.arc
> 1 6984 23-SEP-02 /u03/prodarch/prod6984.arc
> 1 6985 23-SEP-02 /u03/prodarch/prod6985.arc
> 1 6986 23-SEP-02 /u03/prodarch/prod6986.arc
> 1 6987 23-SEP-02 /u03/prodarch/prod6987.arc
>
> THREAD# SEQUENCE# TIME ARCHIVE_NAME
> ---------- ---------- --------------- ------------------------------
> 1 6988 23-SEP-02 /u03/prodarch/prod6988.arc
> 1 6989 23-SEP-02 /u03/prodarch/prod6989.arc
> 1 6990 23-SEP-02 /u03/prodarch/prod6990.arc
> 1 6991 23-SEP-02 /u03/prodarch/prod6991.arc
> 1 6992 23-SEP-02 /u03/prodarch/prod6992.arc
> 1 6993 23-SEP-02 /u03/prodarch/prod6993.arc
> 1 6994 23-SEP-02 /u03/prodarch/prod6994.arc
> 1 6995 23-SEP-02 /u03/prodarch/prod6995.arc
> 1 6996 23-SEP-02 /u03/prodarch/prod6996.arc
> 1 6997 23-SEP-02 /u03/prodarch/prod6997.arc
> 1 6998 23-SEP-02 /u03/prodarch/prod6998.arc
>
> THREAD# SEQUENCE# TIME ARCHIVE_NAME
> ---------- ---------- --------------- ------------------------------
> 1 6999 23-SEP-02 /u03/prodarch/prod6999.arc
> 1 7000 23-SEP-02 /u03/prodarch/prod7000.arc
> 1 7001 23-SEP-02 /u03/prodarch/prod7001.arc
> 1 7002 23-SEP-02 /u03/prodarch/prod7002.arc
> 1 7003 23-SEP-02 /u03/prodarch/prod7003.arc
> 1 7004 23-SEP-02 /u03/prodarch/prod7004.arc
> 1 7005 23-SEP-02 /u03/prodarch/prod7005.arc
> 1 7006 23-SEP-02 /u03/prodarch/prod7006.arc
> 1 7007 23-SEP-02 /u03/prodarch/prod7007.arc
> 1 7008 23-SEP-02 /u03/prodarch/prod7008.arc
> 1 7009 23-SEP-02 /u03/prodarch/prod7009.arc
>
> THREAD# SEQUENCE# TIME ARCHIVE_NAME
> ---------- ---------- --------------- ------------------------------
> 1 7010 23-SEP-02 /u03/prodarch/prod7010.arc
> 1 7011 23-SEP-02 /u03/prodarch/prod7011.arc
> 1 7012 23-SEP-02 /u03/prodarch/prod7012.arc
> 1 7013 23-SEP-02 /u03/prodarch/prod7013.arc
> 1 7014 23-SEP-02 /u03/prodarch/prod7014.arc
> 1 7015 23-SEP-02 /u03/prodarch/prod7015.arc
> 1 7016 23-SEP-02 /u03/prodarch/prod7016.arc
>
> 40 rows selected.
>
> SQL>
>
> I tried to shutdown db and restore 23-SEP online backup of itgx01.dbf
> and startup mount for recover :
>
> # sqlplus internal
> SQL> startup mount
> SQL> alter database recover datafile '/u03/proddata/itgx01.dbf';
> alter database recover datafile '/u03/proddata/itgx01.dbf'
> *
> ERROR at line 1:
> ORA-00279: change 5965070658351 generated at 09/23/2002 01:54:48 needed for
> thread 1
> ORA-00289: suggestion : /u03/prodarch/prod6977.arc
> ORA-00280: change 5965070658351 for thread 1 is in sequence #6977
>
>
> SQL>
>
> BUT WHY? I had all archived logfiles in /u03/prodarch
>
> gbm2:/u03/prodarch #ls *697*
> prod6970.arc.gz prod6972.arc.gz prod6974.arc.gz prod6976.arc.gz prod6978.arc
> prod6971.arc.gz prod6973.arc.gz prod6975.arc.gz prod6977.arc prod6979.arc
> gbm2:/u03/prodarch #ls *698*
> prod6980.arc prod6982.arc prod6984.arc prod6986.arc prod6988.arc
> prod6981.arc prod6983.arc prod6985.arc prod6987.arc prod6989.arc
>
> Could somebody help me? It happened at our production site ,
> Appreciate for any helps & thanks billion.
>
> Violin.
> violin.hsiao_at_mail.pouchen.com.tw

Voilin
 set autorecovery on
/*before recover datafile */and see how it goes Mike Received on Wed Sep 25 2002 - 10:09:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US