| ...as in DB2 [message #167517] |
Thu, 13 April 2006 08:22  |
theo06
Messages: 29
Registered: February 2006
|
Junior Member |
|
|
Hi,
I am just looking for
- a chance to create a backup of an oracle 9i database like in IBM DB2 8.2.
- a chance to restore the created backup in another oracle 9i database like it is in DB2
The reason for that is, that i would like get an exact copy of an database to use this copy for testing.
Can you tell me how I can realize that?
Thank you for your help!
|
|
|
|
| Re: ...as in DB2 [message #167788 is a reply to message #167517] |
Mon, 17 April 2006 01:58  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Can you make it more clear?? I mean do you want to copy a database from DB2 to Oracle or from one Oracle instance to another.
|
|
|
|
|
|
| Re: ...as in DB2 [message #167817 is a reply to message #167812] |
Mon, 17 April 2006 04:49 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
It's called "cloning/copying of an Oracle database".
You can google the above and you will get some real good links for that.
Post back if you have any problem.
|
|
|
|
| Re: ...as in DB2 [message #168665 is a reply to message #167817] |
Fri, 21 April 2006 09:14 |
theo06
Messages: 29
Registered: February 2006
|
Junior Member |
|
|
Thank you for that hint. But by now I have another question. In the Propagate-Dialog in OEM I can choose a lot of things from the source db. Which of these do I realy need, if I want to get an exact copy of an existing database?
The problem I encountred was that it seems to use a lot of time when I choose all... (Profile, Users, Roles, Tablespaces, Rollback-Segments and Schemaobjects).
Could you tell me what I realy need to copy?
|
|
|
|
| Re: ...as in DB2 [message #169242 is a reply to message #167517] |
Tue, 25 April 2006 21:44 |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
I think the best way to get an exactly copy of oracle is using "cold backup" if you can shutdown the db. Following these steps:
1.shutdown the db you want to copy
2.copy all datafiles, controlfiles, redo logs, spfile/pfile to the dest machine with the same directories.
3.setup the environment in the dest environment, including create passwd filed and service(windows only)
4.startup dest db
"Hot backup" and rman are also good choice if you don't want to shutdown the db.
ALex zeng | Skype me: hans9zeng
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
