recovery method
From: Brian Yan <by2_at_gpu.srv.ualberta.ca>
Date: Tue, 08 Jun 1999 20:08:06 -0600
Message-ID: <375DCC86.61FA_at_gpu.srv.ualberta.ca>
[Quoted] [Quoted] Hi there, I just took over a very bad designed oracle database (7.1) on [Quoted] [Quoted] SCO unix box. There is only one physical disk. Everything (datafile, log, archived log, control file) is in one directory. Customer has no [Quoted] plan to upgrade the hard disk. The database is run under archivelog mode. It is O.K. to lose one day data. Currenly, we have all on-line datafile backup and archived log backed to tape every night. I am wondering in the case of disk failure, can I just copy all the datafile [Quoted] plus the archived logs to the same directory as before (assumed server [Quoted] directories have been restored to the image before crash)? then startup database, run the recover command? I am very new on oracle recovery. Any [Quoted] suggestion would be very much appreciated. Thank you in advance.
Date: Tue, 08 Jun 1999 20:08:06 -0600
Message-ID: <375DCC86.61FA_at_gpu.srv.ualberta.ca>
[Quoted] [Quoted] Hi there, I just took over a very bad designed oracle database (7.1) on [Quoted] [Quoted] SCO unix box. There is only one physical disk. Everything (datafile, log, archived log, control file) is in one directory. Customer has no [Quoted] plan to upgrade the hard disk. The database is run under archivelog mode. It is O.K. to lose one day data. Currenly, we have all on-line datafile backup and archived log backed to tape every night. I am wondering in the case of disk failure, can I just copy all the datafile [Quoted] plus the archived logs to the same directory as before (assumed server [Quoted] directories have been restored to the image before crash)? then startup database, run the recover command? I am very new on oracle recovery. Any [Quoted] suggestion would be very much appreciated. Thank you in advance.
Brian Yan Received on Wed Jun 09 1999 - 04:08:06 CEST