Home » RDBMS Server » Backup & Recovery » RMAN Duplicate Database
RMAN Duplicate Database [message #202190] Wed, 08 November 2006 11:56 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
I am trying to duplicate a database through RMAN. But having issues with connection to the 3 databases through RMAN and I cannot set up a password file for target.

The current environment variable is poiting to duplicate database.

rman target sys/password@TARGET catalog rman_user/password@catalog auxiliary / trace=duplicate.trc

I am getting following error.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: ORA-01031: insufficient privileges

Please help

Thanks
Toshi
Re: RMAN Duplicate Database [message #202194 is a reply to message #202190] Wed, 08 November 2006 12:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
connect target sys/sys@primary  #Connect to target database which is about to be duplicated	
connect catalog c_secondary/rman@rmandb #connect to catalog
connect auxiliary  sys/sys	# connet to duplicate database identified by ORACLE_SID.

Follow-up with this post.
http://www.orafaq.com/forum/m/197817/42800/#msg_199029
Re: RMAN Duplicate Database [message #202196 is a reply to message #202194] Wed, 08 November 2006 12:21 Go to previous messageGo to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
i tried rman trace=dulpicate.trc
RMAN>connect target sys/password@target

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04005: error from target database: ORA-01031: insufficient privileges

Still all environment variable is pointing to duplicate. Please help
Re: RMAN Duplicate Database [message #202198 is a reply to message #202196] Wed, 08 November 2006 12:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
trace is used for debugging only.
Why are you going after it?
This is to do with your tns connectivity.
Make sure you have set REMOTE_LOGIN_PASSWORD_FILE=exclusive.
try again.
Re: RMAN Duplicate Database [message #202200 is a reply to message #202198] Wed, 08 November 2006 13:32 Go to previous messageGo to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
Thanks for all your help and suggestions.

That's what my real question is, I do not have password file, is there a work around without having password file.

Thanks
Re: RMAN Duplicate Database [message #202202 is a reply to message #202200] Wed, 08 November 2006 13:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I am not aware of any.
connect target / might help.
But you need to do this from target machine. Then you cannot do duplicate.

[Updated on: Wed, 08 November 2006 13:41]

Report message to a moderator

Re: RMAN Duplicate Database [message #202296 is a reply to message #202202] Thu, 09 November 2006 00:42 Go to previous message
raviramappa
Messages: 1
Registered: November 2006
Junior Member
yes you can invoke RMAN on the target machine but you need to create password file and configure listener & tnsnames for the auxiliary (duplicate) database and connect as below
$ RMAN target / catalog user/password@connectstring auxiliary sys/password@connectstring.
Previous Topic: Restore question
Next Topic: Skipping files backed up already
Goto Forum:
  


Current Time: Fri Dec 09 04:07:02 CST 2016

Total time taken to generate the page: 0.13151 seconds