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
dzeljko
Messages: 19
Registered: April 2005
Junior Member
Hello,

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 9.2.0.5.0

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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
check sqlnet.ora for authentication_services
Check values of NLS_LANG on both ends.
check value of REMOTE_LOGIN_PASSWORDFILE
And, from where are you invoking this ?
Invoke from duplicate database server.
so change
>>connect target
to
connect target sys/sys@target

and
>>connect auxiliary sys/passwd@conn_string_to_aux
to
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

Hi,
Go through below link
http://dbataj.blogspot.com/2006/12/duplicating-database-with-recovery.html


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


Current Time: Tue Nov 26 20:53:41 CST 2024