Restoring database

From: Jay Collins <jcollin_at_exis.net>
Date: Thu, 25 Apr 2002 08:06:50 -0400
Message-ID: <Pine.LNX.4.33.0204250800250.22006-100000_at_tarpon.exis.net>


Hello,

 I'm trying to restore a cold copy of my database and I've run into a problem (which I'm sure is easy to fix.. I hope). All the guides I read on doing this show the archive log's automaticly applying or have a prompt
(sugguested, auto, etc). What command do I need to do to make it apply my
log? I don't have an auto/suggested promp and hitting enter does nothing.

(which is what he guide I read suggested... hit enter until you can
cancele). if I do alter database recover cancel, it says :

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent ORA-01110: data file 1: '/u03/oradata/gold/system01.dbf'

Not sure what to do at this point.

I'll past my session below:

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> _at_/test.ctl

ORACLE instance started.

Total System Global Area                        123354640 bytes
Fixed Size                                          48656 bytes
Variable Size                                    44482560 bytes
Database Buffers                                 78643200 bytes
Redo Buffers                                       180224 bytes
Statement processed.
SVRMGR> SVRMGR> alter database recover database until cancel using backup controlfile;
alter database recover database until cancel using backup controlfile *
ORA-00279: change 17960182 generated at 04/23/02 21:01:21 needed for thread 1
ORA-00289: suggestion : /u06/oracle/admin/gold/arch13729_1.dbf ORA-00280: change 17960182 for thread 1 is in sequence #13729 SVRMGR> Received on Thu Apr 25 2002 - 14:06:50 CEST

Original text of this message