4 Replies Latest reply: Sep 6, 2013 8:49 AM by Pradeepcmst RSS

    Multi platform db cloning issue

    debashisora

      I am cloning DB  from windows server to Linix .  I did folowing steps

      1. Create contraol file from trace and edit the file location ( windows file convension to Linux) .
      2. Also edit init file
      3. copy db file to unix location ( Log , arcive . undo file exclude )
      4. start db on nomount
      5 Then issue following create control file command
      CREATE CONTROLFILE SET DATABASE "BETA" RESETLOGS ARCHIVELOG
          MAXLOGFILES 16
          MAXLOGMEMBERS 3
          MAXDATAFILES 400
          MAXINSTANCES 8
          MAXLOGHISTORY 292
          LOGFILE
        GROUP 4 '/u02/oradata2/BETA/LOG1ABETA.ORA' SIZE 200M BLOCKSIZE 512,
        GROUP 5 '/u02/oradata2/BETA/LOG2ABETA.ORA'  SIZE 200M BLOCKSIZE 512,
        GROUP 6 '/u02/oradata2/BETA/LOG3ABETA.ORA'  SIZE 200M BLOCKSIZE 512
      -- STANDBY LOGFILE
      DATAFILE
      '/u02/oradata2/BETA/RBS1BETA.ORA'
      '/u02/oradata2/BETA/SYSAUX1BETA.ORA'
      '/u02/oradata2/BETA/SYSBETA.ORA'
      '/u02/oradata2/BETA/TLS1BETA.ORA'
      '/u02/oradata2/BETA/USR102BETA.ORA'
      '/u02/oradata2/BETA/USR103BETA.ORA'
      '/u02/oradata2/BETA/USR104BETA.ORA'
      '/u02/oradata2/BETA/USR10BETA.ORA'
      '/u02/oradata2/BETA/USR11BETA.ORA'
      '/u02/oradata2/BETA/USR12BETA.ORA'
      '/u02/oradata2/BETA/USR13BETA.ORA'
      '/u02/oradata2/BETA/USR14BETA.ORA'
      '/u02/oradata2/BETA/USR15BETA.ORA'
      '/u02/oradata2/BETA/USR16BETA.ORA'
      '/u02/oradata2/BETA/USR17BETA.ORA'
      '/u02/oradata2/BETA/USR18BETA.ORA'
      '/u02/oradata2/BETA/USR19BETA.ORA'
      '/u02/oradata2/BETA/USR1BETA.ORA'
      '/u02/oradata2/BETA/USR20BETA.ORA'
      '/u02/oradata2/BETA/USR21BETA.ORA'
      '/u02/oradata2/BETA/USR22BETA.ORA'
      '/u02/oradata2/BETA/USR23BETA.ORA'
      '/u02/oradata2/BETA/USR24BETA.ORA'
      '/u02/oradata2/BETA/USR25BETA.ORA'
      '/u02/oradata2/BETA/USR26BETA.ORA'
      '/u02/oradata2/BETA/USR27BETA.ORA'
      '/u02/oradata2/BETA/USR28BETA.ORA'
      '/u02/oradata2/BETA/USR29BETA.ORA'
      '/u02/oradata2/BETA/USR2BETA.ORA'
      '/u02/oradata2/BETA/USR30BETA.ORA'
      '/u02/oradata2/BETA/USR31BETA.ORA'
      '/u02/oradata2/BETA/USR32BETA.ORA'
      '/u02/oradata2/BETA/USR33BETA.ORA'
      '/u02/oradata2/BETA/USR34BETA.ORA'
      '/u02/oradata2/BETA/USR35BETA.ORA'
      '/u02/oradata2/BETA/USR36BETA.ORA'
      '/u02/oradata2/BETA/USR37BETA.ORA'
      '/u02/oradata2/BETA/USR38BETA.ORA'
      '/u02/oradata2/BETA/USR39BETA.ORA'
      '/u02/oradata2/BETA/USR3BETA.ORA'
      '/u02/oradata2/BETA/USR40BETA.ORA'
      '/u02/oradata2/BETA/USR41BETA.ORA'
      '/u02/oradata2/BETA/USR42BETA.ORA'
      '/u02/oradata2/BETA/USR43BETA.ORA'
      '/u02/oradata2/BETA/USR44BETA.ORA'
      '/u02/oradata2/BETA/USR45BETA.ORA'
      '/u02/oradata2/BETA/USR46BETA.ORA'
      '/u02/oradata2/BETA/USR47BETA.ORA'
      '/u02/oradata2/BETA/USR48BETA.ORA'
      '/u02/oradata2/BETA/USR49BETA.ORA'
      '/u02/oradata2/BETA/USR4BETA.ORA'
      '/u02/oradata2/BETA/USR50BETA.ORA'
      '/u02/oradata2/BETA/USR51BETA.ORA'
      '/u02/oradata2/BETA/USR52BETA.ORA'
      '/u02/oradata2/BETA/USR53BETA.ORA'
      '/u02/oradata2/BETA/USR54BETA.ORA'
      '/u02/oradata2/BETA/USR55BETA.ORA'
      '/u02/oradata2/BETA/USR5BETA.ORA'
      '/u02/oradata2/BETA/USR6BETA.ORA'
      '/u02/oradata2/BETA/USR7BETA.ORA'
      '/u02/oradata2/BETA/USR8BETA.ORA'
      '/u02/oradata2/BETA/USR9BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR11BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR13BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR15BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR17BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR19BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR1BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR21BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR23BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR25BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR27BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR29BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR31BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR3BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR5BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR7BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR9BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR10BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR12BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR14BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR16BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR18BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR20BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR22BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR24BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR26BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR28BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR2BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR30BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR4BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR6BETA.ORA'
      '/u02/oradata2/BETA/SHIPUSR8BETA.ORA'
      '/u02/oradata2/BETA/TMP1BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX10BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX11BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX12BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX13BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX14BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX15BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX16BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX17BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX18BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX19BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX1BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX20BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX21BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX22BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX23BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX24BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX25BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX26BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX27BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX28BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX2BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX3BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX4BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX5BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX6BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX7BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX8BETA.ORA'
      '/u02/oradata2/BETA/CUSTIDX9BETA.ORA'
      '/u02/oradata2/BETA/IDX102BETA.ORA'
      '/u02/oradata2/BETA/IDX103BETA.ORA'
      '/u02/oradata2/BETA/IDX104BETA.ORA'
      '/u02/oradata2/BETA/IDX10BETA.ORA'
      '/u02/oradata2/BETA/IDX11BETA.ORA'
      '/u02/oradata2/BETA/IDX12BETA.ORA'
      '/u02/oradata2/BETA/IDX13BETA.ORA'
      '/u02/oradata2/BETA/IDX14BETA.ORA'
      '/u02/oradata2/BETA/IDX15BETA.ORA'
      '/u02/oradata2/BETA/IDX16BETA.ORA'
      '/u02/oradata2/BETA/IDX17BETA.ORA'
      '/u02/oradata2/BETA/IDX18BETA.ORA'
      '/u02/oradata2/BETA/IDX19BETA.ORA'
      '/u02/oradata2/BETA/IDX1BETA.ORA'
      '/u02/oradata2/BETA/IDX20BETA.ORA'
      '/u02/oradata2/BETA/IDX21BETA.ORA'
      '/u02/oradata2/BETA/IDX22BETA.ORA'
      '/u02/oradata2/BETA/IDX23BETA.ORA'
      '/u02/oradata2/BETA/IDX24BETA.ORA'
      '/u02/oradata2/BETA/IDX25BETA.ORA'
      '/u02/oradata2/BETA/IDX26BETA.ORA'
      '/u02/oradata2/BETA/IDX27BETA.ORA'
      '/u02/oradata2/BETA/IDX28BETA.ORA'
      '/u02/oradata2/BETA/IDX2BETA.ORA'
      '/u02/oradata2/BETA/IDX3BETA.ORA'
      '/u02/oradata2/BETA/IDX4BETA.ORA'
      '/u02/oradata2/BETA/IDX5BETA.ORA'
      '/u02/oradata2/BETA/IDX6BETA.ORA'
      '/u02/oradata2/BETA/IDX7BETA.ORA'
      '/u02/oradata2/BETA/IDX8BETA.ORA'
      '/u02/oradata2/BETA/IDX9BETA.ORA'
      '/u02/oradata2/BETA/XFACEIDX1BETA.ORA'
      '/u02/oradata2/BETA/XFACEIDX2BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX10BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX11BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX12BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX13BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX14BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX15BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX16BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX17BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX18BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX19BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX1BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX20BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX21BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX22BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX23BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX24BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX25BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX26BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX27BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX28BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX29BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX2BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX30BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX31BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX32BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX33BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX34BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX35BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX36BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX3BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX4BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX5BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX6BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX7BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX8BETA.ORA'
      '/u02/oradata2/BETA/EDIIDX9BETA.ORA'
      '/u02/oradata2/BETA/EQPIDX1BETA.ORA'
      '/u02/oradata2/BETA/EQPIDX2BETA.ORA'
      '/u02/oradata2/BETA/EQPIDX3BETA.ORA'
      '/u02/oradata2/BETA/EQPIDX4BETA.ORA'
      '/u02/oradata2/BETA/EQPIDX5BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX10BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX11BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX12BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX13BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX14BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX15BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX16BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX17BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX18BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX19BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX1BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX20BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX21BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX22BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX23BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX24BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX25BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX26BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX27BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX28BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX29BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX2BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX30BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX31BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX32BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX33BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX34BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX35BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX36BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX37BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX38BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX39BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX3BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX4BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX5BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX6BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX7BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX8BETA.ORA'
      '/u02/oradata2/BETA/SHIPIDX9BETA.ORA'
      '/u02/oradata2/BETA/CUSTUSR1BETA.ORA'
      '/u02/oradata2/BETA/CUSTUSR2BETA.ORA'
      '/u02/oradata2/BETA/CUSTUSR3BETA.ORA'
      '/u02/oradata2/BETA/CUSTUSR4BETA.ORA'
      '/u02/oradata2/BETA/CUSTUSR5BETA.ORA'
      '/u02/oradata2/BETA/CUSTUSR6BETA.ORA'
      '/u02/oradata2/BETA/CUSTUSR7BETA.ORA'
      '/u02/oradata2/BETA/EQPUSR1BETA.ORA'
      '/u02/oradata2/BETA/EQPUSR2BETA.ORA'
      '/u02/oradata2/BETA/EQPUSR3BETA.ORA'
      '/u02/oradata2/BETA/EQPUSR4BETA.ORA'
      '/u02/oradata2/BETA/XFACEUSR1BETA.ORA'
      '/u02/oradata2/BETA/XFACEUSR2BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR10BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR11BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR12BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR13BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR14BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR15BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR16BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR17BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR18BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR19BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR1BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR20BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR21BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR22BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR23BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR24BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR25BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR26BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR27BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR28BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR29BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR2BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR30BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR31BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR32BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR33BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR34BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR3BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR4BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR5BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR6BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR7BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR8BETA.ORA'
      '/u02/oradata2/BETA/EDIUSR9BETA.ORA'
      '/u02/oradata2/BETA/UNDO1BETA.ORA'
      CHARACTER SET WE8MSWIN1252;

      But I am getting "ORA-01967 invalid option for CREATE CONTROLFILE"  line 14

      Could any one help me what is the exact . I don't think it is sytax error

      Thanks in advance
      Debashis Mallick