Home » RDBMS Server » Backup & Recovery » Moving from one Windows environment to another Linux environment (Oracle 11g R2 11.2.0.1.0 - OEL 5.7)
Moving from one Windows environment to another Linux environment [message #558118] Tue, 19 June 2012 08:26 Go to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

Hi All,

I'm trying to move my backup sets from windows database environment,
to OEL 5.7 environment on another server.

I've found a manual
http://dba-oracle.com/t_rman_clone_copy_database.htm

by which I am trying to do it.


I took backup sets from last night's backup using RMAN,
and the current parameter(initSID.ora) file from the running live database.
Now i need to configure control files in the pfile accordingly.



the questions are:

1.
can i take current control files from the running system,
to restore and recover backup sets from last night,
to the state the database was at backup time?

2. how can i find out if control files are backed up and know by RMAN?
"list backup completed after '2012-JUN-19';" >> gives me Archive redo logs,
datafiles, but don't see the control files(or don't reconize them).


thanks in advance,

Andrey
Re: Moving from one Windows environment to another Linux environment [message #558120 is a reply to message #558118] Tue, 19 June 2012 08:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The URL talks about moving/copying databases across different servers, but same OS.
I would look into RMAN cross platform functionalities.
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmxplat.htm#CHDFHBFI
Re: Moving from one Windows environment to another Linux environment [message #558123 is a reply to message #558118] Tue, 19 June 2012 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I've found a manual
http://dba-oracle.com/t_rman_clone_copy_database.htm


Search for another site, forget this one.

Regards
Michel

[Updated on: Tue, 19 June 2012 08:56]

Report message to a moderator

Re: Moving from one Windows environment to another Linux environment [message #558145 is a reply to message #558123] Tue, 19 June 2012 12:32 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

Michel Cadot wrote on Tue, 19 June 2012 16:54
Quote:
I've found a manual
http://dba-oracle.com/t_rman_clone_copy_database.htm


Search for another site, forget this one.

Regards
Michel



As far as i know,
Donald K. Burleson is one of the most respected,
experienced and known authors of Oracle throughout the yeards,
has published approx. 20 books and over 100 articles....

why would I forget that site of his, sharing his knowledge and experience?
Re: Moving from one Windows environment to another Linux environment [message #558148 is a reply to message #558145] Tue, 19 June 2012 12:51 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Donald K. Burleson is one of the most respected,
experienced and known authors of Oracle throughout the yeards,


You are taken in by his adverts.

Regards
Michel
Re: Moving from one Windows environment to another Linux environment [message #558149 is a reply to message #558148] Tue, 19 June 2012 12:57 Go to previous messageGo to next message
BlackSwan
Messages: 23150
Registered: January 2009
Senior Member
>Donald K. Burleson is one of the most respected,
by himself & his minions.
Re: Moving from one Windows environment to another Linux environment [message #558187 is a reply to message #558149] Wed, 20 June 2012 02:12 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

I've read some of the documentation.seems quit complex,
and requires keeping the source database in a read-only mode, for part of the process.

what I *actually have* is backup sets, pfile, and also control file
produced by RMAN incremental level 0 backup procedure.
(I've had some misunderstanding of weather control file could be current,
or has to be created at the time of backup -only- , but I'll try to figure it out later on).

can't I take those backup sets and files produced by RMAN in Windows OS database server instance,
and somehow recover them on a 5.7 OEL database server instance?


Thanks to all helpers.

Andrey

[Updated on: Wed, 20 June 2012 04:19]

Report message to a moderator

Re: Moving from one Windows environment to another Linux environment [message #558224 is a reply to message #558187] Wed, 20 June 2012 06:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>can't I take those backup sets and files produced by RMAN in Windows OS database server instance,
>>and somehow recover them on a 5.7 OEL database server instance?
No.
RMAN backupsets are OS dependent.
>>I've read some of the documentation.seems quit complex,
Could be.
All you have decide is ,
* How big is your database?
If it is smaller, I would just export and import.
* Are they with same endians?
Quoting docs
Quote:

Basic Concepts of Cross-Platform Data Transportation

You must use the RMAN CONVERT command in a transportable tablespace operation when the source platform is different from the destination platform and the endian formats are different. If you are converting part of the database between platforms that have the same endian format, you can use operating system methods to copy the files from the source to the destination. If you are converting an entire, same endian database, any data files with undo information must be converted. You cannot copy the data files directly from the source to the destination platform.


I would try the mentioned methods in a non-production environment, get comfortable and try in production.
Re: Moving from one Windows environment to another Linux environment [message #558231 is a reply to message #558224] Wed, 20 June 2012 06:21 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

Thank you Mahesh Rajendran.

My Database is approximately 80GB in size,
so I don't think i would like to use Data Pump, unless it's quicker.

I used the query on both source and destination environments to prove that endians are same:

Select vp. ENDIAN_FORMAT
from v$transportable_platform vp , v$database vdb
where vp.platform_id = vdb.PLATFORM_ID


another question:

if my source database is on Windows 32 bit Oracle 10g,
and my destination database is Oracle 11g on OEL 5.7,
are there specific measures to be taken, or process should be same as described here:

http://ofdatabaseandotherdemons.blogspot.co.il/2011/11/database-migration-from-windows-to.html
Re: Moving from one Windows environment to another Linux environment [message #558251 is a reply to message #558231] Wed, 20 June 2012 06:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
When you are providing information in bits and pieces, it hard to suggest.
>>if my source database is on Windows 32 bit Oracle 10g,
>>and my destination database is Oracle 11g on OEL 5.7,
>>are there specific measures to be taken, or process should be same as described here

You are now talking about upgrade and migration.
You first need to migrate database from 10g Windows to 10g (whatever linux) and then upgrade to 11g unix.
or
upgrade your winodws instance to 11g and migrate to Linux.

Again, the mentioned link talks about migrating between same version of oracle. NOT upgrading.

>>My Database is approximately 80GB in size,
>>so I don't think i would like to use Data Pump, unless it's quicker.

All above will take some downtime.
Export/Import is quite easy.
Re: Moving from one Windows environment to another Linux environment [message #558347 is a reply to message #558251] Thu, 21 June 2012 03:03 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

Quote:
Export/Import is quite easy.



1. Export with datapump of full database from Oracle 10g on Windows 32 bit server
2. Moving the dump file(s) to the Linux server
3. Import with datapump of full database to Oracle 11g on OEL 5.7 64 bit
4. fixing privileges on objects owned by special system users,
like SYS, given to normal users(the ones vital for the application)


(a) will it work by the following stages?
(b) anything unexpected or specific I should be ready to encounter in this process?

Thank you,

Andrey

[Updated on: Thu, 21 June 2012 03:03]

Report message to a moderator

Re: Moving from one Windows environment to another Linux environment [message #558368 is a reply to message #558347] Thu, 21 June 2012 07:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
*I would use the same version of export and import. There might be incomptibilities.
*no need to move if you are using above method. Should you move, make sure you are not corrupting it (use bin mode ftp etc)
**like SYS, given to normal users(the ones vital for the application
Are you talking about SYS account/ SYSDBA privileges?
I have not seen any appliction that absolutely need SYS account for normal business operations.
It is like giving root account to regular users in *nix.
You are calling for trouble.

>>(a) will it work by the following stages?
Hopefully.
I would first set up a parallel environment, try above and then do it for real.
I also presume you have not yet tested your application in 11g.
Setting up a parallel environment would weed out all the unexpected and specific issues you might encounter.
Re: Moving from one Windows environment to another Linux environment [message #558371 is a reply to message #558368] Thu, 21 June 2012 07:39 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

Mahesh Rajendran wrote on Thu, 21 June 2012 15:04
*Are you talking about SYS account/ SYSDBA privileges?


I meant: giving privileges to *objects* owned by SYS and such,
which are not transported and might be vital for application to run correctly.

from Oracle documentation:
Restrictions
Grants on objects owned by the SYS schema are never exported.

( http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm

Quote:
I would use the same version of export and import. There might be incomptibilities.

do you mean, you would install a 10g datapump utility on the Linux server, to impdp the database into the oracle 11g instance???

Wouldn't be simpler just to impdp using the VERSION=LATEST ???

Quote:
I would first set up a parallel environment, try above and then do it for real.

This is what i intend to do - bring up a VM copy of my database server, and get started with the testing.

Quote:
I also presume you have not yet tested your application in 11g.

oh, I have. It works fine.

Re: Moving from one Windows environment to another Linux environment [message #558374 is a reply to message #558371] Thu, 21 June 2012 08:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I meant: giving privileges to *objects* owned by SYS and such,
Metadata objects owned by SYS will exist in the new database (with newer version).
You no need to worry about it.
If SYS owns custom objects/tables that are used by application, that is not good.


With VERSION, all you ask is to consider the objects that are "compatible". If the object is not compatible, it wont be considered.
Quote:
The VERSION parameter simply allows you to identify the version of the objects being exported.

By using the same version expdp/impdp tools to export and import you solve most of the problems with compatibility as VERSION is implicitly defined (not less than oracle 9)

>>do you mean, you would install a 10g datapump utility on the Linux server, to impdp the database into the oracle 11g instance???
No.
You can do a remote import. Just use tnsnames entry.
from 10g
expdp or impdp user/pass@11g_database
or
from 11g
expdp or impdp user/pass@10g_database

[Updated on: Thu, 21 June 2012 08:16]

Report message to a moderator

Re: Moving from one Windows environment to another Linux environment [message #558375 is a reply to message #558374] Thu, 21 June 2012 08:27 Go to previous messageGo to next message
Andrey_R
Messages: 194
Registered: January 2012
Location: Euro-Asia
Senior Member

I am not worrying about their *existence* - I worry about giving ordinary imported users privileges to *use*(select, execute, whatever) some of the objects owned by system users like SYS (such as select on v$session, for example), which i understand from the documentation - will not be imported, so I will have to complete those manually.


expdp from Linux server on 10g Database on Windows server, then impdp.
I like this Idea.


Thank you all, and specially Mahesh Rajendran for your kind help,
I'll update if it worked and share issues I have encountered when I finish.

Regards,
Andrey
Re: Moving from one Windows environment to another Linux environment [message #558380 is a reply to message #558375] Thu, 21 June 2012 10:36 Go to previous message
gazzag
Messages: 388
Registered: November 2010
Location: Bristol, UK
Senior Member
You can also use impdp to import over a datababase link. Check out the NETWORK_LINK impdp parameter.
Previous Topic: recover table which truncated
Next Topic: To retrieve the dropped tables
Goto Forum:
  


Current Time: Fri Dec 19 18:21:35 CST 2014

Total time taken to generate the page: 0.09998 seconds