If you're restoring from a cold backup you shouldn't need to recover
anything. Did you restore all of your datafiles, controlfiles, and online
redo logs?
--
Chuck Hamilton
To reply remove _Xspam from my email address.
Jay Collins <jcollin_at_exis.net> wrote in
news:Pine.LNX.4.33.0204251228320.24190-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> @/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 - 13:17:36 CDT
