Home » RDBMS Server » Backup & Recovery » should i use rman convert? (10gR2 windows server 2003 64)
should i use rman convert? [message #300257] Thu, 14 February 2008 15:09 Go to next message
meggens
Messages: 57
Registered: February 2007
Location: Netherlands
Member
Hi,

I have two windows 2003 server 64bits hosts.
Unintentionally we installed a 32bits oracle 10.2.0.3 on one of the hosts and configured the databases. Now the databases are running for a while and we noticed the mistake.

I already installed the oracle 64 bit software on the new host and I would like to use rman duplicate option to clone the databases to the new host.

Should I use rman convert database to move the database to the new host or will rman duplicate do. I know the platforms are the same endian format but the database software on the first host is 32bit.

Anybody did this before?

I tried using the duplicate command but got an error after the database was openend but the database seems to function fine (I'm able to query it) This is the error message I get within rman after the database is openend.

run {
allocate auxiliary channel dupdb1 type disk;
set until sequence 270 thread 1;
duplicate target database to DRENTHE NOFILENAMECHECK
logfile
GROUP 1 ('D:\oracle\oradata\DRENTHE\redo111.log','D:\oracle\oradata\DRENTHE\redo112.log'
) size 50M reuse,
GROUP 2 ('D:\oracle\oradata\DRENTHE\redo121.log','D:\oracle\oradata\DRENTHE\redo122.log'
) size 50M reuse,
GROUP 3 ('D:\oracle\oradata\DRENTHE\redo131.log','D:\oracle\oradata\DRENTHE\redo132.log'
) size 50M reuse;
}

.
.
..
.
..
.
.
database opened
Finished Duplicate Db at 14-FEB-08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12005: error during channel cleanup
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], [
]
ORA-06553: PLS-801: internal error [56319]

RMAN>


regards,
Martin
Re: should i use rman convert? [message #300259 is a reply to message #300257] Thu, 14 February 2008 15:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Metalink Note: 62290.1
Re: should i use rman convert? [message #300265 is a reply to message #300259] Thu, 14 February 2008 15:42 Go to previous message
meggens
Messages: 57
Registered: February 2007
Location: Netherlands
Member
Thanks, this document will help me I think.

Maybe you can help me a bit further.
Follow Oracle certification matrix 32bit Oracle is not supported on 64bit Windows.

<quote>
Certify - Certification Matrix: Oracle Database - Enterprise Edition on Microsoft Windows 2003 (AMD64/EM64T)

--------------------------------------------------------------------------------


Server Certifications
OS Product Certified With Version Status Addtl. Info. Components Other
2003 R2 64-bit 10gR2 64-bit N/A N/A Certified Yes None None
2003 64-bit 10gR2 64-bit N/A N/A Certified Yes None None
2003 R2 32-bit 10gR2 32-bit N/A N/A Certified Yes None None
2003 32-bit 10gR2 32-bit N/A N/A Certified Yes None None
</quote>

But when I read the document on metalink it states:
<quote>
If you want to change your hardware wordsize, then you should be able to switch from 32-bit hardware to 64-bit hardware and still use your existing 32-bit Oracle software without encountering any problems, except on Linux systems (32-bit Oracle on 64-bit Linux is not supported).
</quote>
Does this mean when I run my 32bits oracle on windows 64bit with 64bit hardware or does it say your 32bit windows with your 32bit oracle runs on 64bit hardware.

Dit you do this before?

regards,
Martin
Previous Topic: Backing up control file
Next Topic: invalid password file
Goto Forum:
  


Current Time: Sat Dec 10 14:44:57 CST 2016

Total time taken to generate the page: 0.15701 seconds