Re: Migration from Oracle 10.2.0.4.0 Windows2003R2 32bit to Oracle 11.2.0.1.0 OEL5.8 64bit

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> _at_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_at_gmail.com>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_at_maine.edu> wrote:
>
>> RMAN has a method that allows one to migrate between incompatible data
>> formats?!
>>
>> Cheers, Wayne
>> Wayne T Smith - wts_at_maine.edu - 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_at_gmail.com> 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
>>>
>>>
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l