Re: Making a copy of a database

"Jay Collins" <jcollin_at_exis.net> wrote in message 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>
>
>
>

I would have used
recover database using backup controlfile until cancel I know from experience this *does* prompt for each file and typing CANCEL is sufficient to get out and perform alter database open resetlogs

Don't know why the alter database command doesn't work the same.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address