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_at_gmail.com>
Date: Tue, 28 Aug 2012 21:12:32 +0300
Message-ID: <CAPfA+9OkhrH22=uexig9AyCUhkLCvrAmqRc9LPTDaekQu_bgyw_at_mail.gmail.com>

Hi Kamran,
I tried your steps the first time and also tried if later now but I am getting this issue ..
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

I am not sure what with it.. still trying to figure it out yet.

Does upper case or lower would make a difference in 11gR2 Linux 64bit Please share your thoughts with this.

---

create controlfile reuse database "amantest" noresetlogs archivelog

    maxlogfiles 16
    maxlogmembers 3
    maxdatafiles 100
    maxinstances 8
    maxloghistory 292
logfile
  group 1 '/u01/app/oracle/oradata/amantest/redo01.log' size 50m blocksize 512,
  group 2 '/u01/app/oracle/oradata/amantest/redo02.log' size 50m blocksize 512,
  group 3 '/u01/app/oracle/oradata/amantest/redo03.log' size 50m blocksize 512
-- standby logfile
datafile

  '/u01/app/oracle/oradata/amantest/system01.dbf',
  '/u01/app/oracle/oradata/amantest/sysaux01.dbf',
  '/u01/app/oracle/oradata/amantest/undotbs01.dbf',
  '/u01/app/oracle/oradata/amantest/users01.dbf'

character set we8mswin1252
;

---

On Tue, Aug 28, 2012 at 7:34 AM, Sheldon Quinny <sheldonquinny_at_gmail.com>wrote:

> Hi,

>

> Thanks,
> Will go thru this and update you with the results..

>

> Thank you.

>
>

> On Tue, Aug 28, 2012 at 7:07 AM, Kamran Agayev (ICT/SNO) <
> itakamran_at_azercell.com> wrote:

>
>> Hi Sheldon
>>
>> You can try my step by step video tutorial:
>> http://kamranagayev.com/2010/08/20/rman-convert-database-video-tutorial/
>>
>> Let me know if you have any issues
>>
>>
>> Kamran Agayev A.
>> Oracle ACE Director, OCP
>> http://kamranagayev.com
>>
>>
>> -----Original Message-----
>> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
>> On Behalf Of Sheldon Quinny
>> Sent: Monday, August 27, 2012 9:02 PM
>> To: Oracle-L Freelists
>> Subject: Migration from Oracle 10.2.0.4.0 Windows2003R2 32bit to Oracle
>> 11.2.0.1.0 OEL5.8 64bit
>>
>> 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

Received on Tue Aug 28 2012 - 13:12:32 CDT