Where did you source your control file from? How did you recover it? RF Robert G. Freeman Oracle Consultant/DBA/Author Principal Engineer/Team Manager The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One, Author of various geeky computer titles from Osborne/McGraw Hill (Oracle Press) Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com! BLOG: http://robertgfreeman.blogspot.com/ Sig V1.2 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Schauss, Peter Sent: Monday, October 08, 2007 10:57 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Recover after rman restore asks for a VERY OLD archive log Thanks for all of the suggestions. My original recovery script was: export ORACLE_SID=dbname export NLS_DATE_FORMAT='DD-MON-YYYY hh24:mi:ss' export NLS_LANG='american_america.WE8MSWIN1252' rman target $1/$2 nocatalog <<EOF startup mount; run{ set until time='24-APR-2007 22:55:00'; allocate channel ch1 type disk; allocate channel ch2 type disk; allocate channel ch3 type disk; allocate channel ch4 type disk; allocate channel ch5 type disk; allocate channel ch6 type disk; restore database; } exit EOF For whatever reason, this script worked for my 8.1.7.4 databases. I removed the NLS_DATE_FORMAT, NLS_LANG, and "set until time" statements and the "recover database..." command asked for the archive log that I was expecting. The database is up and running. Thanks again for the quick responses. Peter Schauss -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Schauss, Peter Sent: Monday, October 08, 2007 11:22 AM To: oracle-l@xxxxxxxxxxxxx Subject: Recover after rman restore asks for a VERY OLD archive log This is Oracle 10.2.0.2 on HP-UX B.11.23. I have an rman backup which was done in "nocatalog mode" and am attempting to restore this database on another server. The backup was done three days ago. I put the control files, int.ora, and password files where the database expected them to be and used the following script to restore: #!/bin/ksh # export ORACLE_SID=peregrine rman target sys/password nocatalog <<EOF startup mount pfile='/opt/oracle/admin/dbname/pfile/initdbname.ora'; run{ allocate channel ch1 type disk; allocate channel ch2 type disk; allocate channel ch3 type disk; allocate channel ch4 type disk; allocate channel ch5 type disk; allocate channel ch6 type disk; restore database; } exit EOF The script runs without errors, but when I give the command: > recover database until cancel using backup controlfile; It asks me for an archive log which was created back in March when I first created the database. What is going on here? Thanks, Peter Schauss -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l