This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Sep 19, 2013 12:05 PM by 993806 Go to original post RSS
  • 15. Re: Database migration from NON ASM to ASM
    TSharma-Oracle Guru
    Currently Being Moderated

    Sorry, I was confused about the approach you were using. Were all you conversion steps ran successfully including system and undo conversion? As you are moving to ASM , did you convert all other tablespaces as well? Which document you are following?

  • 16. Re: Database migration from NON ASM to ASM
    993806 Newbie
    Currently Being Moderated

    This is what I used when I ran the conversion through RMAN:

     

    Started up database in read only mode

     

    Connected to RMAN as rman target / and I used the following command for the convert:

     

    convert database new database 'xfwbudb' transport script 'C:\Users\Administrator\xfwbudb_convert\transport.sql' to platform 'Linux x86 64-bit' db_file_name_convert 'C:\APP\ADMINISTRATOR\ORADATA\WIFI' 'C:\Users\Administrator\xfwbudb_convert';

     

     

    So I converted all the data files included Undo and System, and then I moved whatever file placed onto the destination folder 'C:\Users\Administrator\xfwbudb_convert' of source platform to the destination platform server.

     

    My next step was using the asmcmd to copy the converted files from Non ASM to ASM. pfile has been updated and control file was created successfully on the new server. I'm just struggling when open database with reset logs.

     

    I was working around this issue for the last three days and am just wondering if the caused by the convert command I used above!

     

    Do you think I used the convert command mistakenly? The reason I said that because I haven't included FORMAT syntax to the convert command as format '+BUDB_DATAG'? but I used a regular file system path and then those files have been stored on ASM using asmcmd.

     

    The database is very big so I don't want to do it again if you don't think there is something wrong with convert syntax.

     

    Thanks for any given feedback.

  • 17. Re: Database migration from NON ASM to ASM
    Hemant K Chitale Oracle ACE
    Currently Being Moderated

    I would ask why you got this error :

    >ORA-39700: database must be opened with UPGRADE option

    Are the source and destnation rdbms executables at the same version and patchset level ?

     

    Hemant K Chitale


  • 18. Re: Database migration from NON ASM to ASM
    993806 Newbie
    Currently Being Moderated

    Was not on the same version, was my bad though. I ran the same version and it works fine now.

     

    Now, I want to upgrade the new database from 11.2.0.1 which I have now my destination new platform to 11.2.0.4, is there any useful link which could walk me through from .1 to .4 directly on the same server? and should I need to upgrade my ASM which left on 11.2.0.3 version to to the newest release?

  • 19. Re: Database migration from NON ASM to ASM
    TSharma-Oracle Guru
    Currently Being Moderated

    TSharma wrote:

     

    TRY THIS:

    alter database open resetlogs upgrade;


    Also, check your source and destination database are same at version and patch level.

    @993806 : This is the first question I asked. You could have saved everybody's time.

     

    You should open a new Post for your new question in order to get more responses from people.

  • 20. Re: Database migration from NON ASM to ASM
    993806 Newbie
    Currently Being Moderated

    I guess you misunderstood me. I think I'm good to go with the migration. I was just asking you that I want to upgrade my new database release from 11.2.0.1 to 11.2.0.4 I guess this is the latest release. is it straight forward though? and would I need to upgrade my current release of ASM which on release 11.2.0.3 to the latest release as well?

     

    Thanks for your given efforts working with me on this issue!

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points