need to load database files on other machine [message #485264] |
Tue, 07 December 2010 01:56 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ateeqrahman786
Messages: 52 Registered: December 2009 Location: Hyderabad,India
|
Member |
|
|
Hi,
I am trying to upload a database backup on a machine. Since the structure of files is different from server, how can i start the database.
Do i need to create a new control file? If yes, how can i run the sql command "Alter database backup controlfile to trace" in nomount mode.
Thanks,
|
|
|
|
|
Re: need to load database files on other machine [message #486099 is a reply to message #486086] |
Mon, 13 December 2010 10:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Well in order to refresh the dump of the database to another server , the operating system should be same
In depends on what you mean by "dump". An export dump is independent of the system.
Quote:cold copy / hot backup copy to tape or scp/rcp to the destination server where ever you found the space .
RMAN and DUPLICATE command is a far better way.
Regards
Michel
|
|
|