Making a copy of a database

From: Jay Collins <jcollin_at_exis.net>
Date: Thu, 25 Apr 2002 12:29:14 -0400
Message-ID: <Pine.LNX.4.33.0204251228320.24190-100000@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> @/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 - 11:29:14 CDT