Re: Making a copy of a database

Just as a piece of general advice: every recover command has an 'alter database' equivalent. Hence 'recover database until cancel' can also be 'alter database recover database until cancel'. Or 'recover database using backup controlfile' can also be 'alter database recover database using backup controlfile'.

The difference is that the 'alter database' versions suppress most of the feedback you'd get were you to just supply the 'recover' version. You end up performing the recovery blind ...which is the last thing I'd be wanting to do.

Therefore, my strong recommendation is never use the 'alter database' version of any recovery command.

Regards
HJR "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>
>
>
>
Received on Fri Apr 26 2002 - 17:01:40 CDT