Applying archive redo log to a cold backup database

From: <yew.poo.choon_at_mbf.com.my>
Date: Fri, 23 Apr 1999 08:45:45 GMT
Message-ID: <7fpbvo$bkf$1@nnrp1.dejanews.com>

Hi, doest anyone know how to recover a database up to just before the currupted point with a cold backup of the archive log mode database ?

I have try to restore all the backup data file to the apppropriate directory. I keep the current online redo log.

I then startup the database in mount mode and issue a command : SVRMGR> alter database recover automatic; I get the following error :

alter database recover automatic * ORA-00279: Change 9354 generated at 04/23/99 11:59:35 needed for thread 1 ORA-00289: Suggestion : /mbf/ypc/archive_redo/log_82.rdo ORA-00280: Change 9354 for thread 1 is in sequence #82 ORA-00278: Logfile '/mbf/ypc/archive_redo/log_82.rdo' no longer needed for this recovery ORA-00328: archived log ends at change 9353, need later change 9354 ORA-00334: archived log: '/mbf/ypc/archive_redo/log_82.rdo'

How to solve this problem ? Please advise ...

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 23 1999 - 03:45:45 CDT