Re: Problems cloning a database/database instance

"Howard J. Rogers" wrote:
>
> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> news:40cd53ac$0$11521$afc38c87_at_news.optusnet.com.au...
> >
> > "ohaya" <ohaya_at_cox.net> wrote in message news:40CD4736.F213987C_at_cox.net...
> > > Hi,
> > >
> > > I'm running Oracle 9i on a Win2K Server, and I've been trying to follow
> > > a procedure for cloning a database ("TEST") as shown here:
> > >
> > > http://www.sap-img.com/oracle-database/cloning-a-oracle-database.htm
> > >
>
> Actually, upon a little further investigation, that site is apparently
> nothing very much but unattributed rip-offs of all my old material.
>
> I should know better, but it is depressing to realise that that which one
> gave away free to start with is nevertheless capable of being stolen. Now
> there's a paradox for the age we live in.
>
> Regards
> HJR
HJR, Sorry to hear about that :(. If the procedures are yours, do you have something on the web that's better, possibly more up-to-date? Any ideas about the questions that I posed?

I think that I've now mucked things up, to the point that I can no longer even startup the database instance :(! In OEM, when I try to startup the database, I get a popup that says "The database needs to be opened with RESETLOGS". Then I get another popup with an ORA-01113 and an ORA-01110, saying "data file 1: 'E:\CLONED\SYSTEM01.DBF'". When I'm done with that, the instance goes back to the "Mounted" state, but not "Open".

Thanks... Received on Mon Jun 14 2004 - 08:06:45 CDT