This content has been marked as final. Show 2 replies
[orarman@devtest ~]$ rman target rman/rman@OBAPROD catalog rman/rman@RMANHello,
When you are connecting to the TARGET database from the catalog database, you need to provide the username & password of sys user of TARGET database to perform backup operations. Ofcourse, you can connect with any other user existing in TARGET database but you'll not be permitted to perform backup operations.
Try as below:
rman target sys/<pwd-of-sys-user-of-target-db>@obaprod catalog rman/rman@rmanPassword file of TARGET database must be created on the TARGET (PROD) server.
By default sys user password is change_on_install
So i tried the below from test server
[orarman@devtest ~]$ rman target sys/change_on_install@OBAPROD catalog rman/rman@RMAN
Recovery Manager: Release 220.127.116.11.0 - Production on Thu Nov 15 17:12:30 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges