Connection to Target RMAN throws insufficient privileges error
664430Jun 21 2011 — edited Jun 21 2011I have primary database running over 11.1.0.7.5 and trying to create standby database using below command
connect target sys/password@dgprod
connect auxiliary /
run
{
allocate auxiliary channel c1 device type disk;
allocate auxiliary channel c2 device type disk;
allocate auxiliary channel c3 device type disk;
allocate auxiliary channel c4 device type disk;
duplicate target database for standby from active database
db_file_name_convert=(
'/u01/oradata/dgprod/datafile','/u01/oradata/dgstd/datafile')
nofilenamecheck;
}
But I am getting
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges
I have checked that remote_login_passwordfile paramter over primaray database is set to exclusive and password file has been created over $ORACLE_HOME/dbs
Can anyone please suggest what I am missing here...