Home » RDBMS Server » Server Administration » create database service in linux by copy database files from windows (10.2.0)
create database service in linux by copy database files from windows [message #410487] Sat, 27 June 2009 06:18 Go to next message
narges
Messages: 11
Registered: December 2004
Junior Member
i have datafile/controlfile/redolog file /pfile copy of mydatabase in shutdown status in OS=windowse and now i want to copy these file to linux and start database service in liux,is this possible?
how i must to fix the change path because of changing OStype?

Report message to a moderator

Re: create database service in linux by copy database files from windows [message #410489 is a reply to message #410487] Sat, 27 June 2009 06:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No this is not possible.
Use RMAN or export/import to do this.

Regards
Michel

[Updated on: Sat, 27 June 2009 06:42]

Report message to a moderator

Re: create database service in linux by copy database files from windows [message #410492 is a reply to message #410487] Sat, 27 June 2009 07:00 Go to previous message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member
As Michel has mentioned, it's not possible to recover the database from different OS

You can't recover Windows based database in Linux by taking cold backups

- You can use Data Pump to create dump file of your database and recover it

- You can use tranportable tablespace future to transport tablespace from WIndows to Linux OS

Report message to a moderator

Previous Topic: connected to Idle Instance
Next Topic: Dropping User
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 13:50:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.