OraFAQ Forum: Server Administration » cloning a database.prob:Pl. see scenario.

Home » RDBMS Server » Server Administration » cloning a database.prob:Pl. see scenario.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cloning a database.prob:Pl. see scenario. [message #64355]

Sun, 16 January 2005 19:50

BhavinShah
Messages: 105
Registered: February 2004

Senior Member

Dear frends,

I have a prob to clone to db.

My scenario : My db_server1 has got some problem on friday and it has shutdown abortly.we found that prob. with motherboard..so we have given them to vendor to repair ..but it will take 10 days..but gracefully we got a data in our hard-disk..now i want to clone this file in my new server db_server2.. i have copied my all files..controlfiles,logfiles,dbfiles with same name..i have also recreate a controlfile for new path of my logfile and datafile..i am able to mount a database with those files..but when i am going to open a database.. i got an error datafile "c:/oracle/oradata/system1.dbf" is inconsistent. Is this error bec's db was not shutdown proparly..?? now i want to ask..is there any way to restore a file of database which has not proparly shutdown..means abortlly shutdown..Pl.let me know the answer whether it is yes or no..

WE are using oracle9.2 on windows2k server.

Report message to a moderator

Re: cloning a database.prob:Pl. see scenario. [message #64358 is a reply to message #64355]

Sun, 16 January 2005 23:03

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

You can try the following from sqlplus, if you are lucky, it may just work:

connect sys as sysdba
recover database;
alter database open;

Next time, do not SHUTDOWN ABORT!

Best regards.

Frank

Report message to a moderator

Previous Topic:	Packages
Next Topic:	Install 32-bit Oracle on 64-bit hardware

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 03:18:40 CST 2025