RE: Cant bring up cold backup

I have little or no experience with recovering noarchivelog databases. (Even seems a bit of an oxymoron to me, but maybe that's my problem.)

How exactly is using a created or backup controlfile preventing complete recovery? I understand if he had wrapped online logs there would be no source of the all the change deltas, but if the shutdown was clean that should not be a problem. Possibly there is a definitional problem of what is meant by "clean." And since this is recovery, not backup, you've brought in the online logs from the former location before that former database was restarted, right?

It appears from the email that indeed "recovery complete" was reached and the error is "host def does not exist." To me that sounds like a problem unrelated to an incomplete recovery. Any ORA error identifiers on the actual message?

So two questions:

1. Is it correct that created controlfiles will not work for complete recovery of relocated cold backups of noarchivelog databases?
2. Is there some other problem with this startup?

At the very least, that is one heckuva misleading error message (if it is accurately transcribed and it is indeed related to recovery).

Now true, it is probably more simple if you're relocating a cold backup to include everything. Although the whole create tracefile thing was a bell or whistle added to avoid folks having to get the rename datafile syntax right and in the exactly right sequence in the recovery startup, so that would actually surprise me if it is not supported. I think it would even vary from what the fine manuals suggest. Then again, I have little or no experience with recovering noarchivelog databases.

Regards,

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mark Bole Sent: Saturday, June 04, 2005 11:33 AM
Cc: oracle-l_at_freelists.org
Subject: Re: Cant bring up cold backup

Step 3 is the problem. Doing this means you must perform incomplete recovery, which is probably not what you want.

After your database is shutdown cleanly, include the controlfiles in your cold backup, you should then be able to bring it up on another machine using those controlfiles.

-Mark Bole

Bob wrote:

> All,
> Oracle 10.1.0.3.0 on windows xp pro, noarchivelog database was shutdown
> cleanly
>
> I am trying to bring up a database from a cold backup, Using the same
> dbname
>
> 1 - I create the service using oradim -new -sid somename -pfile ....
> 2 - edit the init.ora file to point to the new file locations
> 3 - use a alter database backup control file to trace, edit to point to
the
> new datafiles
> 4 - startup nomount, create control file as.... controlfile created
> 5 - alter database open
> 6 - file 1 needs recovery, (recover file 1, media recovery complete)
repeat
> files 1- 7
>
> 7 ERROR--> alter database open, host def does not exist disconnection
forced
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l