OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Copy database

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

Copy database [message #298746]

Thu, 07 February 2008 07:56

oracleoracle
Messages: 5
Registered: February 2008
Location: Sweden

Junior Member

Hi,

I wonder how to copy a database. I want to move the database from one destination to another. Am I able to copy the hole folder? Or just the database files? If so, where to find them, and which files?! Do I have to create a new tablespace at the new location, or can I move the hole tablespace?!

Report message to a moderator

Re: Copy database [message #298844 is a reply to message #298746]

Fri, 08 February 2008 00:20

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

Quote:

I wonder how to copy a database. I want to move the database from one destination to another. Am I able to copy the hole folder? Or just the database files? If so, where to find them, and which files?! Do I have to create a new tablespace at the new location, or can I move the hole tablespace?!

error : too many values Laughing

regards,

Report message to a moderator

Re: Copy database [message #298878 is a reply to message #298746]

Fri, 08 February 2008 01:53

oracleoracle
Messages: 5
Registered: February 2008
Location: Sweden

Junior Member

Great answer I got .....................not!!

I wonder how to copy a database, I want to move the database from one destination to another.

Please exlain careful, since I'm a beginner!

Report message to a moderator

Re: Copy database [message #298882 is a reply to message #298746]

Fri, 08 February 2008 02:14

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

1.shutdown the database
2.take a clean cold backup of all files
3.copy to the new location
4.recreate the control file

please be insure while taking backup with all possible means.

regards,

Report message to a moderator

Re: Copy database [message #298905 is a reply to message #298882]

Fri, 08 February 2008 04:16

oracleoracle
Messages: 5
Registered: February 2008
Location: Sweden

Junior Member

Thank you!

Report message to a moderator

Re: Copy database [message #299057 is a reply to message #298878]

Fri, 08 February 2008 13:52

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Assuming the directories in the new location are going to be the same as your old database, you could simply copy ALL files (datafiles, redo logs, control files, password file and spfile) to the new location and place them into the corresponding directories. This is assuming a consistent cold backup.

If you are on Windoze, you'll need to create a new Window's service with ORADIM.

Once all of this is in place, you can simply startup your database.

Report message to a moderator

Re: Copy database [message #299488 is a reply to message #299057]

Tue, 12 February 2008 03:52

oracleoracle
Messages: 5
Registered: February 2008
Location: Sweden

Junior Member

Moving the database was harder than I thougth! (I don't know what ORADIM is..) Is there no way to perform this task within the url GUI? E.g. Maintenance-> Move Database Files-> Clone Database. Can I use Clone Database to do this instead?

Report message to a moderator

Re: Copy database [message #299508 is a reply to message #299488]

Tue, 12 February 2008 05:00

ebrian
Messages: 2794
Registered: April 2006

Senior Member

I was able to use OEM's clone database in prior versions of Oracle, but 10gR2 seems to require GRID for that functionality.

oracleoracle wrote on Tue, 12 February 2008 04:52

(I don't know what ORADIM is..)

That's why I provided the link above.

[Updated on: Tue, 12 February 2008 05:01]

Report message to a moderator

Re: Copy database [message #299540 is a reply to message #299508]

Tue, 12 February 2008 06:31

oracleoracle
Messages: 5
Registered: February 2008
Location: Sweden

Junior Member

Well, yes, thank you, I saw and read the link, but I think the ORADIM seems to be too advanced for me..

Report message to a moderator

Re: Copy database [message #299667 is a reply to message #299540]

Tue, 12 February 2008 22:48

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

oracleoracle wrote on Tue, 12 February 2008 19:31

Well, yes, thank you, I saw and read the link, but I think the ORADIM seems to be too advanced for me..

Two years ago, it's seem to me Laughing

Let do it - take an example for the first time in your TEST DB

Report message to a moderator

Previous Topic:	delete archivelogs older than 1 day.
Next Topic:	Datafile Recovery without backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 02:18:12 CDT 2025