Re: Migration from Oracle 10.2.0.4.0 Windows2003R2 32bit to Oracle 11.2.0.1.0 OEL5.8 64bit
- From: Sheldon Quinny <sheldonquinny@xxxxxxxxx>
- To: Wayne Smith <wts@xxxxxxxxx>
- Date: Mon, 27 Aug 2012 21:32:45 +0300
This what I keep getting ..
even Following this steps , getting the same error
http://www.reachdba.com/showthread.php?495-Database-Migration-From-Windows-to-Linux-Using-RMAN
SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 27 21:31:15 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
SQL> @ab.sql
CREATE CONTROLFILE REUSE SET DATABASE "AMANTEST" RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'/u01/app/oracle/oradata/amantest/system01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
On Mon, Aug 27, 2012 at 9:24 PM, Sheldon Quinny <sheldonquinny@xxxxxxxxx>wrote:
> HI,
>
> Thanks I am trying do to that with rman , but I am getting error.. so I am
> trying to figure what is going wrong.
>
>
> On Mon, Aug 27, 2012 at 9:21 PM, Wayne Smith <wts@xxxxxxxxx> wrote:
>
>> RMAN has a method that allows one to migrate between incompatible data
>> formats?!
>>
>> Cheers, Wayne
>> Wayne T Smith - wts@xxxxxxxxx - UMS-ITS-ECAS -
>>
>> - "You can get help from teachers, but you are going to have
>> - to learn a lot by yourself, sitting alone in a room." --Dr. Seuss
>>
>> On Mon, Aug 27, 2012 at 12:01 PM, Sheldon Quinny <
>> sheldonquinny@xxxxxxxxx> wrote:
>>
>>> Hi All,
>>> I been trying to do a migration from the above set subject line , with
>>> the
>>> help of RMAN.
>>>
>>> Tired using this doc , but did not succeed.
>>> Database Migration From Windows to Linux Using RMAM by Alejandro Vargas |
>>> Principal Support Consultant
>>>
>>> I want to use Rman to do this process rather then imp exp.
>>>
>>> So if anyone have exact steps for the process, I am trying this on small
>>> default database first, then would go on for the production.
>>>
>>> Please if anyone could shed some light over this it would be helpful.
>>>
>>> Thank you.
>>> Regards,
>>> Sheldon.
>>>
>>>
>>> -----------------------------------------------------------------------------------------------------------------
>>>
>>> BANNER
>>> ----------------------------------------------------------------
>>> Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
>>> PL/SQL Release 10.2.0.4.0 - Production
>>> CORE 10.2.0.4.0 Production
>>> TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
>>> NLSRTL Version 10.2.0.4.0 - Production
>>>
>>>
>>> TO
>>>
>>> SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 27 18:55:44 2012
>>>
>>>
>>> --
>>> //www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
