dbTalk Databases Forums  

Error in Dupplication a production database

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Error in Dupplication a production database in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael
 
Posts: n/a

Default Error in Dupplication a production database - 09-25-2009 , 02:20 PM






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

Reply With Quote
  #2  
Old   
joel garry
 
Posts: n/a

Default Re: Error in Dupplication a production database - 09-25-2009 , 02:55 PM






On Sep 25, 12:20*pm, Michael <mbulch... (AT) gmail (DOT) com> wrote:
Quote:
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
--
@home.com is bogus.
http://au.news.yahoo.com/a/-/mp/6016...africa-telkom/

Reply With Quote
  #3  
Old   
Maxim Demenko
 
Posts: n/a

Default Re: Error in Dupplication a production database - 09-25-2009 , 04:27 PM



joel garry wrote:
Quote:
On Sep 25, 12:20 pm, Michael <mbulch... (AT) gmail (DOT) 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
--
@home.com is bogus.
http://au.news.yahoo.com/a/-/mp/6016...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

Reply With Quote
  #4  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Error in Dupplication a production database - 10-29-2009 , 07:22 AM



On 25 sep, 20:20, Michael <mbulch... (AT) gmail (DOT) com> wrote:
[snip]
Quote:
RMAN-01009: syntax error: found "m":
[more snipped]
RMAN-01007: at line 1 column 2 file: standard input
Are you, by any chance, cuttin'-n-pastin'?!? RMAN (from the prompt)
spells with an 'M' in position 2...

Grtz, Frank

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.