With 9i, it should. Just be sure that you have all the ones you think you need. On 8.0.6.3 you had to restore them separately before applying them with a restore archivelog all or restore archivelog from logseq xxx until logseq yyy thread N. Ruth -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Paula_Stankus@xxxxxxxxxxxxxxx Sent: Wednesday, March 10, 2004 3:09 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: restore/recovery I don't think that is quite true. If your system admin. blows the box away and you are doing a restore - so no online redo - then without using recover database you don't get the archivelog files restored for recovery unless you restore the archivelog files separate - right? My thought was that recover database in this cause would restore necessary archive files. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DENNIS WILLIAMS Sent: Wednesday, March 10, 2004 2:57 PM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: restore/recovery Paula - If RMAN recovery encounters problems, I exit RMAN and just log into Oracle (svrmgrl in 8i, sqlplus in 9i) and perform the recovery there. I believe that for recovery RMAN is just issuing the same commands to the RDBMS. Dennis Williams DBA Lifetouch, Inc. dwilliams@xxxxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Paula_Stankus@xxxxxxxxxxxxxxx Sent: Wednesday, March 10, 2004 1:16 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: restore/recovery -Solaris 2.8 -Oracle 8.0.6 Restoring - restore says it is complete but recovery keeps failing or hanging: connect target $TARGET@$DBNAME run { execute script alloc_all_tapes; restore controlfile to '/data/oradata/CSTAT/ctrl/control01.ctl'; allocate channel d1 type disk; replicate controlfile from '/data/oradata/CSTAT/ctrl/control01.ctl'; sql 'alter database mount'; restore database until time "to_date('JAN 27 2004 12:00:00','MON DD YYYY HH24:MI:SS')"; sql 'alter database open resetlogs'; execute script rel_all_tapes; } EOD ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------