2 Replies Latest reply on Apr 21, 2008 2:54 AM by 26741

    RMAN Duplicate Error

    564841
      Hi

      when i trying to create RMAN Duplicate DB I am getting error

      Recovery Manager: Release 10.2.0.2.0 - Production on Sat Apr 19 09:26:38 2008

      Copyright (c) 1982, 2005, Oracle. All rights reserved.

      RMAN>
      connected to target database: GOLD (DBID=2806355243)

      RMAN>
      connected to auxiliary database: SANDBOX (not mounted)

      RMAN> 2> 3> 4> 5> 6> 7>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "identifier": expecting one of: "device, db_file_name_convert, hig
      h, logfile, nofilenamecheck, open, pfile, ;, skip, until"
      RMAN-01008: the bad identifier was: LOG_FILE_NAME_CONVERT
      RMAN-01007: at line 7 column 1 file: standard input

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "equal": expecting one of: "allocate, alter, backup, beginline, bl
      ockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, deb
      ug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, re
      cover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest
      , set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unre
      gister, validate"
      RMAN-01007: at line 7 column 22 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "pfile": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change
      , connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {,
      library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, r
      man, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, va
      lidate"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "logfile": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, chan
      ge, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host,
      {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync,
      rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister,
      validate"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "group": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change
      , connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {,
      library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, r
      man, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, va
      lidate"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "single-quoted-string": expecting one of: "allocate, alter, backup, beginline, blockrecover,
      catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flas
      hback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, res
      tore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade,
      unregister, validate"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "single-quoted-string": expecting one of: "allocate, alter, backup, beginline, blockrecover,
      catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flas
      hback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, res
      tore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade,
      unregister, validate"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found ")": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, co
      nnect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, lib
      rary, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman,
      run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, valida
      te"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "group": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change
      , connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {,
      library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, r
      man, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, va
      lidate"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "single-quoted-string": expecting one of: "allocate, alter, backup, beginline, blockrecover,
      catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flas
      hback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, res
      tore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade,
      unregister, validate"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "single-quoted-string": expecting one of: "allocate, alter, backup, beginline, blockrecover,
      catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flas
      hback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, res
      tore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade,
      unregister, validate"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found ")": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, co
      nnect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, lib
      rary, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman,
      run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, valida
      te"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "identifier": expecting one of: ";"
      RMAN-01008: the bad identifier was: disk1
      RMAN-01007: at line 1 column 17 file: standard input

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, co
      nnect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, lib
      rary, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman,
      run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, valida
      te"
      RMAN-01007: at line 1 column 22 file: standard input

      RMAN>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, co
      nnect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, lib
      rary, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman,
      run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, valida
      te"
      RMAN-01007: at line 1 column 1 file: standard input

      RMAN>

      Recovery Manager complete.


      its very critical please let me know
        • 1. Re: RMAN Duplicate Error
          ebrian
          Our crystal ball is broken today!

          Would you be able to post the process you followed and commands that you issued to get the errors you posted?
          • 2. Re: RMAN Duplicate Error
            26741
            You would have been running RMAN commands ? It seems as if the
            commands you passed are not RMAN (but SQL ?).

            You'd have to post the actually commands that you submitted to the RMAN
            command line (from a script ?). We can see that there were 7 lines
            and there were words like "LOG_FILE_NAME_CONVERT" and "pfile' and "logfile"
            and "group" and "disk1" but I don't think anyone here can fathom what
            commands you asked RMAN to execute.