Re: Why would system datafile need recovery when restoring consistent(cold) backup?

GS apparently said,on my timestamp of 21/05/2005 7:57 AM:

>
> When I start up the database it tells me that the system tablespace is
> in need of recovery. Why?, should the database not just startup just as
> if I did a shutdown/startup? I ended up mimicking a incomplete recovery
> using recover database until cancel and open with resetlogs, but this
> should not have been neccesary, should it?

I don't suppose there is ANY chance you'd have not overwritten the control files with the backup copy? Only way I can think of this problem would surface. Some missed step with the control file naming in init.ora?

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam