Recover from cold backup + archive logs question

From: <mpokress_at_gmail.com>
Date: Sun, 17 Feb 2008 16:58:34 -0800 (PST)
Message-ID: <4915ffe3-bb10-4602-87a2-41946a301789@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/ Received on Sun Feb 17 2008 - 18:58:34 CST

Original text of this message