OraFAQ Forum: Backup & Recovery » RMAN Duplicate Database

Home » RDBMS Server » Backup & Recovery » RMAN Duplicate Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN Duplicate Database [message #202190]

Wed, 08 November 2006 11:56

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

Report message to a moderator

Re: RMAN Duplicate Database [message #202194 is a reply to message #202190]

Wed, 08 November 2006 12:06

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: RMAN Duplicate Database [message #202196 is a reply to message #202194]

Wed, 08 November 2006 12:21

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

Report message to a moderator

Re: RMAN Duplicate Database [message #202198 is a reply to message #202196]

Wed, 08 November 2006 12:50

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: RMAN Duplicate Database [message #202200 is a reply to message #202198]

Wed, 08 November 2006 13:32

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

Report message to a moderator

Re: RMAN Duplicate Database [message #202202 is a reply to message #202200]

Wed, 08 November 2006 13:40

Mahesh Rajendran
Messages: 10708
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

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.

Report message to a moderator

Previous Topic:	Restore question
Next Topic:	Skipping files backed up already

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 15:14:40 CST 2025