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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Duplicate Rman Issues ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-01031:

ASulthanJun 15 2016 — edited Jun 15 2016

Can  you please assist how to resovle below issues

RMAN> connect target sys/gscc

connected to target database: GSCC (DBID=1482991755)

RMAN> connect auxiliary sys/sys@gsccdr

connected to auxiliary database: GSCCDR (not mounted)

RMAN> run {

2>         allocate channel prmy1 type disk;

3>      allocate channel prmy2 type disk;

4>      allocate channel prmy3 type disk;

5>      allocate channel prmy4 type disk;

6>      allocate auxiliary channel stby type disk;

7>      duplicate target database for standby from active database

8>      spfile

9>              parameter_value_convert 'gscc','gsccdr'

10>             set db_unique_name='gsccdr'

11>             set db_file_name_convert='/gscc/','/gscc/'

12>             set log_file_name_convert='/gscc/','/gscc/'

13>             set control_files='E:\app\express\oradata\gscc\standby1.ctl'

14>             set log_archive_max_processes='5'

15>             set fal_client='gsccdr'

16>             set fal_server='gscc'

17>             set standby_file_management='AUTO'

18>             set log_archive_config='dg_config=(gscc,gsccdr)'

19>             set log_archive_dest_2='service=orcl ASYNC valid_for=(ONLINE_LOG

FILE,PRIMARY_ROLE) db_unique_name=gscc'

20>      ;

21>

22> }

using target database control file instead of recovery catalog

allocated channel: prmy1

channel prmy1: SID=224 device type=DISK

allocated channel: prmy2

channel prmy2: SID=5 device type=DISK

allocated channel: prmy3

channel prmy3: SID=35 device type=DISK

allocated channel: prmy4

channel prmy4: SID=67 device type=DISK

allocated channel: stby

channel stby: SID=249 device type=DISK

Starting Duplicate Db at 15-JUN-16

contents of Memory Script:

{

   backup as copy reuse

   targetfile  'E:\app\express\product\11.2.0\dbhome_1\DATABASE\PWDgscc.ORA' aux

iliary format

'E:\app\express\product\11.2.0\dbhome_1\DATABASE\PWDgsccdr.ORA'   targetfile

'E:\APP\EXPRESS\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEGSCC.ORA' auxiliary form

at

'E:\APP\EXPRESS\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEGSCCDR.ORA'   ;

   sql clone "alter system set spfile= ''E:\APP\EXPRESS\PRODUCT\11.2.0\DBHOME_1\

DATABASE\SPFILEGSCCDR.ORA''";

}

executing Memory Script

Starting backup at 15-JUN-16

RMAN-03009: failure of backup command on prmy1 channel at 06/15/2016 15:47:26

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: prmy1

released channel: prmy2

released channel: prmy3

released channel: prmy4

released channel: stby

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 06/15/2016 15:47:26

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of backup command on prmy2 channel at 06/15/2016 15:47:26

ORA-17629: Cannot connect to the remote database server

ORA-17627: ORA-01031: insufficient privileges

ORA-17629: Cannot connect to the remote database server

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 13 2016
Added on Jun 15 2016
5 comments
18,152 views