dbTalk Databases Forums  

Target and Auxiliary have different OS and version of Oracle

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Target and Auxiliary have different OS and version of Oracle in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
moongeegee
 
Posts: n/a

Default Target and Auxiliary have different OS and version of Oracle - 05-06-2010 , 09:03 AM






The target is Window server 2003 with 10g 10.2.0.2.0 oracle and the
Auxiliary is Windows XP with 10g 10.2.0.1.0 oracle.
Can I user rman duplicate database to duplicate database from target
to auxiliary ?

Reply With Quote
  #2  
Old   
joel garry
 
Posts: n/a

Default Re: Target and Auxiliary have different OS and version of Oracle - 05-06-2010 , 01:23 PM






On May 6, 6:03*am, moongeegee <moongee... (AT) gmail (DOT) com> wrote:
Quote:
The target is Window server 2003 with 10g 10.2.0.2.0 oracle and the
Auxiliary is Windows XP with 10g 10.2.0.1.0 oracle.
Can I user rman duplicate database to duplicate database from target
to auxiliary ?
It depends on information you have not supplied. The answer is
probably yes, but you might want to patch up some in case there are
bugs.

See the OracleŽ Database Backup and Recovery Advanced User's Guide
about Cross-Platform Transportable Databases and Tablespaces and
Preparing for CONVERT DATABASE: Using the DBMS_TDB Package

In there you will see a reference to V$DB_TRANSPORTABLE_PLATFORM and
related views. Select everything from that view and see if your
operating systems and platform are listed, and think about how what
you posted is ambiguous.

jg
--
@home.com is bogus.
http://www.bogost.com/blog/flash_is_not_a_right.shtml

Reply With Quote
  #3  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Target and Auxiliary have different OS and version of Oracle - 05-08-2010 , 06:23 AM



On 05/06/2010 07:23 PM, joel garry wrote:
Quote:
On May 6, 6:03 am, moongeegee<moongee... (AT) gmail (DOT) com> wrote:
The target is Window server 2003 with 10g 10.2.0.2.0 oracle and the
Auxiliary is Windows XP with 10g 10.2.0.1.0 oracle.
Can I user rman duplicate database to duplicate database from target
to auxiliary ?

It depends on information you have not supplied. The answer is
probably yes, but you might want to patch up some in case there are
bugs.

See the OracleŽ Database Backup and Recovery Advanced User's Guide
about Cross-Platform Transportable Databases and Tablespaces and
Preparing for CONVERT DATABASE: Using the DBMS_TDB Package

In there you will see a reference to V$DB_TRANSPORTABLE_PLATFORM and
related views. Select everything from that view and see if your
operating systems and platform are listed, and think about how what
you posted is ambiguous.

jg
--
@home.com is bogus.
http://www.bogost.com/blog/flash_is_not_a_right.shtml
Well, with 10.2.0.3 and 10.2.0.4 it is not working.
The whole exercise goes well, up to the point where
the clone is about to be opened.
It then start (rightfully so) moaning about it should
be opened in upgrade mode. Which will leave you in a
catch-22 situation.

Frank van Bortel

Reply With Quote
  #4  
Old   
joel garry
 
Posts: n/a

Default Re: Target and Auxiliary have different OS and version of Oracle - 05-09-2010 , 07:34 PM



On May 8, 3:23*am, Frank van Bortel <fbor... (AT) home (DOT) nl> wrote:
Quote:
On 05/06/2010 07:23 PM, joel garry wrote:



On May 6, 6:03 am, moongeegee<moongee... (AT) gmail (DOT) com> *wrote:
The target is Window server 2003 with 10g 10.2.0.2.0 oracle and the
Auxiliary is Windows XP with 10g 10.2.0.1.0 oracle.
Can I user rman duplicate database to duplicate database from target
to auxiliary ?

It depends on information you have not supplied. *The answer is
probably yes, but you might want to patch up some in case there are
bugs.

See the OracleŽ Database Backup and Recovery Advanced User's Guide
about Cross-Platform Transportable Databases and Tablespaces and
Preparing for CONVERT DATABASE: Using the DBMS_TDB Package

In there you will see a reference to V$DB_TRANSPORTABLE_PLATFORM and
related views. *Select everything from that view and see if your
operating systems and platform are listed, and think about how what
you posted is ambiguous.

jg
--
@home.com is bogus.
http://www.bogost.com/blog/flash_is_not_a_right.shtml

Well, with 10.2.0.3 and 10.2.0.4 it is not working.
The whole exercise goes well, up to the point where
the clone is about to be opened.
It then start (rightfully so) moaning about it should
be opened in upgrade mode. Which will leave you in a
catch-22 situation.

Frank van Bortel
Dang, you're right. The duplicate is so helpfully automatic it shoots
itself in the foot. https://support.oracle.com/CSP/main/...type=NOT#aref2
Thought I had seen a solution to that somewhere, guess I'm just
confused by all the possibilities.

jg
--
@home.com is bogus.
http://www.computerworld.com/s/artic...market_inquiry

Reply With Quote
  #5  
Old   
sandeep pande
 
Posts: n/a

Default Re: Target and Auxiliary have different OS and version of Oracle - 05-11-2010 , 03:02 AM



On May 6, 6:03*pm, moongeegee <moongee... (AT) gmail (DOT) com> wrote:
Quote:
The target is Window server 2003 with 10g 10.2.0.2.0 oracle and the
Auxiliary is Windows XP with 10g 10.2.0.1.0 oracle.
Can I user rman duplicate database to duplicate database from target
to auxiliary ?
Hi,
In this case you can not use "rman duplicate" but for duplicating you
can use "rman convert database"
see http://download.oracle.com/docs/cd/B...91/dbxptrn.htm


Thanks
Sandy

Reply With Quote
  #6  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Target and Auxiliary have different OS and version of Oracle - 05-12-2010 , 04:19 AM



On 05/11/2010 09:02 AM, sandeep pande wrote:
Quote:
On May 6, 6:03 pm, moongeegee<moongee... (AT) gmail (DOT) com> wrote:
The target is Window server 2003 with 10g 10.2.0.2.0 oracle and the
Auxiliary is Windows XP with 10g 10.2.0.1.0 oracle.
Can I user rman duplicate database to duplicate database from target
to auxiliary ?

Hi,
In this case you can not use "rman duplicate" but for duplicating you
can use "rman convert database"
see http://download.oracle.com/docs/cd/B...91/dbxptrn.htm

Gues I wasn't clear, but the catch-22 I was referring to is an RMAN clone.

Did you test/try/exercise for yourself, ever, or is this bookshelf
knowledge?

--

Regards,

Frank van Bortel

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.