Home » RDBMS Server » Backup & Recovery » Copy database
Copy database [message #298746] Thu, 07 February 2008 07:56 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 19:35:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.