Home » RDBMS Server » Backup & Recovery » Problem with duplicate database using rman
Problem with duplicate database using rman [message #217441] Fri, 02 February 2007 03:58 Go to next message
Messages: 19
Registered: April 2005
Junior Member

I'm trying to clone oracle database from existing database on remote server. First I prepared the same file structure on auxilary server as on target is, created passwd file on aux, created init.ora file on aux from spfile from target database, copied backup from target on the same file structure on aux host and updated lister.ora configuration on aux and tnsnames on target host. I started database instance on aux (with the same sid as it is on target) in nomount mode. I'm getting following error while I try to initiate the command as shown below from rman on target. Kindly help me resolving this.

Recovery Manager: Release

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN> connect target
connected to target database: ORCL (DBID=924445643)

RMAN> connect auxiliary sys/passwd@conn_string_to_aux

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
Re: Problem with duplicate database using rman [message #217477 is a reply to message #217441] Fri, 02 February 2007 07:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
check sqlnet.ora for authentication_services
Check values of NLS_LANG on both ends.
And, from where are you invoking this ?
Invoke from duplicate database server.
so change
>>connect target
connect target sys/sys@target

>>connect auxiliary sys/passwd@conn_string_to_aux
connect auxillary sys/sys
--# define ORACLE_SID in os
Re: Problem with duplicate database using rman [message #217595 is a reply to message #217441] Fri, 02 February 2007 23:01 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Go through below link

hope this helps
Previous Topic: problem while taking cold backup
Next Topic: how to cross check /test weather the backup is fine
Goto Forum:

Current Time: Thu Jul 27 20:06:50 CDT 2017

Total time taken to generate the page: 0.08032 seconds