OraFAQ Forum: Server Utilities » Copy a database to same machine

Home » RDBMS Server » Server Utilities » Copy a database to same machine

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

Copy a database to same machine [message #74152]

Mon, 20 September 2004 20:24

Amudan
Messages: 8
Registered: September 2004

Junior Member

Hello,

Please give me the steps for copying a database in the same machine. I am using oracle 9i Database .

�

Thanks

Amudan.

�

�

�

Report message to a moderator

Re: Copy a database to same machine [message #74154 is a reply to message #74152]

Tue, 21 September 2004 00:46

rammohan
Messages: 13
Registered: March 2002

Junior Member

usage: COPY FROM <db> TO <db> <opt>
{ (<cols>) } USING <sel>
<db> : database string, e.g., scott/tiger@d:chicago-mktg
<opt> : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE

: name of the destination table
<cols> : a comma-separated list of destination column aliases
<sel> : any valid SQL SELECT statement
A missing FROM or TO clause uses the current SQL*Plus connection.

EXAMPLE

OPY FROM USERNAME/PASSWORD@SERVICENAME(db1) TO USERNAME/PASSWORD@SERVICENAME(DB2) APPEND man_cell USING SELECT * FROM man_cell;

Report message to a moderator

Re: Copy a database to same machine [message #74155 is a reply to message #74154]

Tue, 21 September 2004 01:10

Amudan
Messages: 8
Registered: September 2004

Junior Member

Hi,

Thanks.

The issue is: Copying a entire database (using oracle9i in windows 2000) with all of its data and schema to another database in the same machine. I am in need of the procedures to execute the same in my machine.

Bye
Amudan.

Report message to a moderator

Re: Copy a database to same machine [message #74159 is a reply to message #74155]

Wed, 22 September 2004 03:49

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

Senior Member
Account Moderator

1. create the new database ( if it is not created before).
exp the source database.
precreate the tablespaces in target database like they are present in source database.
similiarly create the users in target db.
do the import.
comment-> Easiest method.

2. If dont have new database,
You can do a COLD copy clone.
create a backup control file( text version) of source dB.
shutdown the source database cleanly.
copy alll the files related to a new destination.
edit your init<newsid>.ora to reflect changes.
recreate the controlfile and Database with open resetlogs.

comment-> YOU HAVE TO VERY CAREFUL.
DONT do this unless, you know what you are doing.

3. RMAN hot clone ( duplicate).

Use RMAN to backup the SOURCE DB and duplicate it to
the target DB.
comment-> Takes a lot of time of setup this and understanding about
RMAN. If once it is set, it would be your angel.
YOu can duplicate ( or clone or copy source datbase to target database) POINT-IN-TIMe ( like as of a particular date), you can select the schemas you want to be cloned et.

Report message to a moderator

Re: Copy a database to same machine [message #74160 is a reply to message #74155]

Thu, 23 September 2004 11:28

croK
Messages: 170
Registered: April 2002

Senior Member

if you have installed oracle database configuration assistant, you can choose to create a template based on an existing database
then, you can create new database with that template. all from DBC.

Best luck.

Report message to a moderator

Previous Topic:	Exp73 full=yes
Next Topic:	unable to start the oracleorahome81agent service

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 01:47:35 CDT 2024