Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Guard - insufficient privileges

azizFeb 24 2012 — edited Feb 24 2012
Spec:
Windows 2008
Oracle 11.1.0.2

I continue to get an error when running my below RMAN script to create data guard for a very small database.
The error is stating that I don't have privilege to write to the remote server - here is the script and error included below:
RMAN> run {
2> allocate channel prmy3 type disk;
3> allocate channel prmy4 type disk;
4> allocate auxiliary channel stby1 type disk;
5> duplicate target database for standby from active database
6> spfile
7> parameter_value_convert 'test1', 'test1'
8> set 'db_unique_name'='test1_coop'
9> set control_files='D:\oradata\test1\control01.ctl'
10> set db_create_file_dest='D:\oradata\test1'
11> set audit_file_dest='C:\app\diag\rdbms\test1'
12> set diagnostic_dest='C:\app\diag\rdbms\test1'
13> set db_create_online_log_dest_1='D:\oradata\test1'
14> set db_recovery_file_dest='D:\Flash_Recovery_Area'
15> set db_recovery_file_dest_size='5G'
16> nofilenamecheck;
17> }
using target database control file instead of recovery catalog
allocated channel: prmy3
channel prmy3: SID=149 device type=DISK
allocated channel: prmy4
channel prmy4: SID=148 device type=DISK
allocated channel: stby1
channel stby1: SID=94 device type=DISK
Starting Duplicate Db at 23-FEB-12
contents of Memory Script:
{
backup as copy reuse
file 'C:\app\product\11.1.0\db_1\DATABASE\PWDtest1.ORA' auxiliary format
'C:\app\product\11.1.0\db_1\DATABASE\PWDtest1.ORA' file
'C:\APP\PRODUCT\11.1.0\DB_1\DATABASE\SPFILETEST1.ORA' auxiliary format
'C:\APP\PRODUCT\11.1.0\DB_1\DATABASE\SPFILETEST1.ORA' ;
sql clone "alter system set spfile= ''C:\APP\PRODUCT\11.1.0\DB_1\DATABASE\SPF
ILETEST1.ORA''";
}
executing Memory Script
Starting backup at 23-FEB-12
RMAN-03009: failure of backup command on prmy3 channel at 02/23/2012 18:43:29
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01031: insufficient privileges
ORA-17629: Cannot connect to the remote database server
continuing other job steps, job failed will not be re-run
released channel: prmy3
released channel: prmy4
released channel: stby1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/23/2012 18:43:29
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on prmy4 channel at 02/23/2012 18:43:29
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01031: insufficient privileges
ORA-17629: Cannot connect to the remote database server
This post has been answered by mseberg on Feb 24 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2012
Added on Feb 24 2012
6 comments
2,939 views