RE: Recover after rman restore asks for a VERY OLD archive log

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Mon, 8 Oct 2007 11:57:13 -0500
Message-ID: <CD9150D80CFCFB42BC73C40791C1E019993C46@XMBIL112.northgrum.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: Monday, October 08, 2007 11:22 AM
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 08 2007 - 11:57:13 CDT