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
connect / as sysdba
it then says connected to and idle instance. It is supposed to startup automatically.
so i then run
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
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!