OraFAQ Forum: Server Administration » clone database in windows

Home » RDBMS Server » Server Administration » clone database in windows

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

clone database in windows [message #143023]

Tue, 18 October 2005 15:19

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

Has anyone successfully cloned an oracle database under Windows ??

I have successfully cloned databases in UNIX plenty of times ... but not under windows.

I am dealing with Oracle 9.2 here.

Cannot MOUNT the database before creating the CONTROL files... may be this is what I am not doing properly.

Any help is appreciated.
--
Sanjay

Report message to a moderator

Re: clone database in windows [message #143024 is a reply to message #143023]

Tue, 18 October 2005 15:23

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

using RMAN?

Report message to a moderator

Re: clone database in windows [message #143026 is a reply to message #143023]

Tue, 18 October 2005 15:28

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

NO COLD ...

Wow Mahesh, how are you.. coming to ORAFAQ after a long time and what a quick reply ...

Rock on. Site looks pretty nice also...
--
Sanjay

[Updated on: Tue, 18 October 2005 15:30]

Report message to a moderator

Re: clone database in windows [message #143030 is a reply to message #143026]

Tue, 18 October 2005 16:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Welcome Back~.
>> what a quick reply
Goodies of getting 'Subscribed'.

I havent done COLD method recently. should'nt this be the process?

shutdown normal
copy pfiles,controlfiles,log files , datafiles
set ORACLE_SID
startup mount

or

alter database backup controlfile to trace
add the TEMPFILE entries to generated CREATE CONTROLFILE
startup nomount pfile
Run create controlfile

[Updated on: Tue, 18 October 2005 16:25]

Report message to a moderator

Re: clone database in windows [message #143244 is a reply to message #143030]

Wed, 19 October 2005 10:37

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

>Welcome Back~.
>> what a quick reply
Thank you

>I havent done COLD method recently. should'nt this be the >process?

>shutdown normal
>copy pfiles,controlfiles,log files , datafiles
>set ORACLE_SID
>startup mount

This will work if doing a recovery (from tape ...) into the same location. Else the control file will complain... http://www.orafaq.com/forum/images/message_icons/icon8.gif

>or

this is the method I used in UNIX, always worked.

>alter database backup controlfile to trace

in fact I do "alter database backup controlfile to trace resetlogs"

>add the TEMPFILE entries to generated CREATE CONTROLFILE
TEMPFILE is already there in the trace file, is it not ?

>startup nomount pfile

Problem in Windows is "startup nomount pfile" which I cannot seem to make it work. What is the trick ?? You must have figured out by now, I am not an Oracle in Windows kind of person.

>Run create controlfile

Later.
--
Sanjay

Report message to a moderator

Re: clone database in windows [message #143251 is a reply to message #143244]

Wed, 19 October 2005 11:05

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>You must have figured out by now, I am not an Oracle in Windows kind of person
Neither am i.
Trying to reproduce ( installing 9i for windows right now and already hating it).

>>Problem in Windows is "startup nomount pfile" which I cannot seem to make it work.

Please post the session.

Edit:
And metalink note says to create a service using Oradim.

Make a copy of files.
Edit pfile to change the values.
Edit controlfile
create oracle service
set oracle_sid, startup nomount, execute create control file

[Updated on: Wed, 19 October 2005 11:09]

Report message to a moderator

Previous Topic:	How can I create a duplicate copy of a database?
Next Topic:	Oracle RDBMS version

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 11:34:52 CST 2025