Re: Error in Dupplication a production database
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 25 Sep 2009 23:27:49 +0200
Message-ID: <4ABD35D5.1040607_at_gmail.com>
joel garry 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 23:27:49 +0200
Message-ID: <4ABD35D5.1040607_at_gmail.com>
joel garry wrote:
> 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/
While true, the error message seems to be something unrelated - at least on 10.2.0.4 connect to the same instance as target and auxiliary doesn't generate any error messages ...
Best regards
Maxim Received on Fri Sep 25 2009 - 16:27:49 CDT