Re: Recover from cold backup + archive logs question

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 21 Feb 2008 21:27:51 GMT
Message-ID: <r1mvj.33$0G7.14@newsfe10.phx>


"mpokress_at_gmail.com" <mpokress_at_gmail.com> wrote in news:4915ffe3-bb10-4602- 87a2-41946a301789_at_k2g2000hse.googlegroups.com:

> I have a new 10.2 DB setup on Linux. I had an issue on 2/16 that
> requires a recovery. RMAN is not set up and working properly (yet).
> That is job one once I get this sorted out.
>
> I have a cold backup from 2/9 + a weeks worth of archive log files. I
> have copied the data files and control files from the cold backup into
> the proper location. I have left the archive log files in place,
> assuming that the DB will look for them in the correct location.
>
> In sqlplus I do
>
> startup mount
>
> recover database
>
> ORA-00283: recovery session canceled due to errors
> ORA-00264: no recovery required
>
> How do I get my cold backup to process all the archive logs? They are
> in the default location under the flash_recovery_area/

Note:271916.1 Received on Thu Feb 21 2008 - 15:27:51 CST

Original text of this message