Recover after rman restore asks for a VERY OLD archive log

  • From: "Schauss, Peter" <peter.schauss@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 8 Oct 2007 10:21:33 -0500

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


Other related posts: