Re: Recovery Issue

imranserver_at_yahoo.com (Muhammad Imran) wrote in message news:<ed222491.0301202349.546da4b_at_posting.google.com>...
> Hello All!
>
> Can I restore and recover a cold backup taken from oracle 7 into
> oracle 8.1.7 database with follwing steps.
>
> 1-Shutdown the oracle 7 database.
> 2-Taking Complete cold backup of the oracle 7 databse.
> 3-deleleting orcale 7.
> 4-installing oracle 8.1.7.
> 5-creatting oracle 8.1.7 database.
> 6-shutdown 8.1.7 database.
> 7-deleting all the files of oracle 8.1.7 database.
> 8-resotoring and recoveruing oracle 7 database files.
>
> Thanks.

No. See the 8i Migration Guide for the steps required. The headers of the datafiles, the data dictionary, control files and rollback segments are all different.

It is possble to script the upgrade by playing with the results of alter database backup controlfile to trace, but that is probably only worthwhile if you are going to be running parallel for a long time. I would guess from your steps you have disk space issues?

jg

--
_at_home.com is bogus.  Like the film "Norwood," in which "an ex-Marine
(Glen Campbell) takes to the road with his service buddy (Joe Namath),
a midget, a girl from Greenwich Village, a shiftless brother-in-law, a
young girl and a dancing chicken."