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

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Mon, 8 Oct 2007 09:23:32 -0700 (PDT)
Message-ID: <397091.87113.qm@web38904.mail.mud.yahoo.com>

>> I put the control files, int.ora, and password
files
>> where the database expected them to be and used the

>> following script to restore

It would be so helpful if you could include all your restore steps that you have done. The control file is a bit critical, so I'm wondering what you did to restore it. Also the actual RMAN restore output might be helpful.

• "Schauss, Peter" <peter.schauss_at_ngc.com> wrote:

> 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
>
>
>

Robert G. Freeman
Author:
Now Available for Pre-Sales on Amazon.com!!!!

---

Oracle Database 11g New Features (Oracle Press)

---

Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

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

Received on Mon Oct 08 2007 - 11:23:32 CDT