Can we import to another instance on the same box ? [message #342273] |
Thu, 21 August 2008 19:04 |
jren
Messages: 13 Registered: May 2008
|
Junior Member |
|
|
We have Oracle 10G database running on window2003 server, and we are doing daily full export as backup.
Trying to verify if the full export file working, we install a new instance on the same server, and trying to import everything from the full export file, and failed every time, check the errors in the log file, seems it trying to create databse on the same path as origianl one which is in use, wondering is there a way to import full dump to another instance on the same box ? If yes, how to change the path while importing the dump file ? Thx.
|
|
|
Re: Can we import to another instance on the same box ? [message #342274 is a reply to message #342273] |
Thu, 21 August 2008 19:16 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
A database doesn't have a path. The data files of the tablespaces have them. Post what exactly you really did and what error(s) you really get.
And yes, it is possible, the way I usually do it :
- Create the second instance
- Create the tablespaces in the second instance identical to the tablespaces of the first instance
- Import the dump file
|
|
|
|
Re: Can we import to another instance on the same box ? [message #342279 is a reply to message #342273] |
Thu, 21 August 2008 19:54 |
jren
Messages: 13 Registered: May 2008
|
Junior Member |
|
|
Thanks, it's working now, i think the problem is that i missed the second step:
- Create the tablespaces in the second instance identical to the tablespaces of the first instance
after i created them at different directory before i import, then it will work.
Thx again.
|
|
|
Re: Can we import to another instance on the same box ? [message #342280 is a reply to message #342273] |
Thu, 21 August 2008 20:11 |
jren
Messages: 13 Registered: May 2008
|
Junior Member |
|
|
Hi, ebrian, what's benefit of RMAN phsical backup over full export dump ? As the business side doesn't asking recovery point of time, they are satisfied with daily backup, so, I fell safe with daily full dump, and saved them to network share, if the box crashed , i am still able to bring it up on another box, so, i don't see why i need RMAN backups, for my understanding, RMAN backups can help to bring database up running on the same instance if you use control file as catalog, i don't know how to use RAMN backup files on seperate box to bring the database up and running if the primary one crashed, can we ? Thx.
|
|
|
|
|