Re: Error in Dupplication a production database
From: joel garry <joel-garry_at_home.com>
Date: Fri, 25 Sep 2009 12:55:00 -0700 (PDT)
Message-ID: <770c28f9-9240-42a3-85e0-6429923f7ff7_at_e4g2000prn.googlegroups.com>
On Sep 25, 12:20 pm, Michael <mbulch..._at_gmail.com> wrote:
> I am trying to duplicate a production database - version 10.2. 0.1.0.-
> in a different server and I started the instance with nomount. Then I
> connected to rman :
>
> RMAN> connect target /
>
> connected to target database: NIVO (not mounted)
>
> RMAN> connect auxiliary /
>
> RMAN-00571:
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571:
> ===========================================================
> RMAN-00558: error encountered while parsing input commands
> RMAN-01009: syntax error: found "m": 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, rman, run, rpctest, set,
> setlimit, sql, switch, spool, startup, shutdown, send, show, test,
> transport, upgrade, unregister, validate"
> RMAN-01007: at line 1 column 2 file: standard input
>
> But when I tried to connect to auxiliary, I am getting the following
> error. Any idea what could cause this problem.
>
> Thanks in advance,
> Michael
Date: Fri, 25 Sep 2009 12:55:00 -0700 (PDT)
Message-ID: <770c28f9-9240-42a3-85e0-6429923f7ff7_at_e4g2000prn.googlegroups.com>
On Sep 25, 12:20 pm, Michael <mbulch..._at_gmail.com> wrote:
> I am trying to duplicate a production database - version 10.2. 0.1.0.-
> in a different server and I started the instance with nomount. Then I
> connected to rman :
>
> RMAN> connect target /
>
> connected to target database: NIVO (not mounted)
>
> RMAN> connect auxiliary /
>
> RMAN-00571:
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571:
> ===========================================================
> RMAN-00558: error encountered while parsing input commands
> RMAN-01009: syntax error: found "m": 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, rman, run, rpctest, set,
> setlimit, sql, switch, spool, startup, shutdown, send, show, test,
> transport, upgrade, unregister, validate"
> RMAN-01007: at line 1 column 2 file: standard input
>
> But when I tried to connect to auxiliary, I am getting the following
> error. Any idea what could cause this problem.
>
> Thanks in advance,
> Michael
Go to tahiti.oracle.com. In the search box enter: duplicate database
Then click on your version, then on the examples link. Note that you cannot duplicate a database onto itself, as your connect auxiliary command seems to be saying you are trying to do.
jg
-- _at_home.com is bogus. http://au.news.yahoo.com/a/-/mp/6016150/pigeon-transfers-data-faster-than-south-africa-telkom/Received on Fri Sep 25 2009 - 14:55:00 CDT