Re: Cant bring up cold backup
- From: Mark Bole <makbo@xxxxxxxxxxx>
- Date: Sat, 04 Jun 2005 08:33:09 -0700
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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
