Hey all

Just a quick Question. I have cloned databases in the past with no problem at all. But I have cloned a DB in this instance and a problem as arisen.

When teh Machine starts up I enter command prompt and enter the follwoing

set oracle_sid=rrprod

sqlplus /nlog

connect / as sysdba

it then says connected to and idle instance. It is supposed to startup automatically.

so i then run

startup

and from here it takes about 5 min to come up with this

ORACLE instance started.

Total System Global Area 101785428 bytes
Fixed Size 454484 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.

and then another 8/9 minutes to actually open the database.
Its not a huge problem as i very rarely shut this machine down and once the database is open it runs fine.

Anyone know what could be the prolem here? If you have a solution or a suggection could you please explain to me exactly what to do as Im and Oracle Newbie!

Cheers

Graham