Forum Stats

  • 3,825,763 Users
  • 2,260,558 Discussions
  • 7,896,662 Comments

Discussions

RMAN-03002: Error with command Duplicate Db at 02/24/2020 16:08:04 RMAN-05501: Duplication of target

User_CQS9E
User_CQS9E Member Posts: 90 Red Ribbon
edited Feb 26, 2020 1:10AM in Recovery Manager (RMAN)

Hi,

I am working on a POC for active data guard configuration. I am not able run the duplicate target database command.

Below is my command.

run

{

allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

allocate channel c4 type disk;

allocate channel prim type disk;

allocate auxiliary channel aux type disk;

duplicate target database for standby from active database spfile

parameter_value_convert 'CHENNAI','DELHI'

set db_file_name_convert='CHENNAI','DELHI'

set log_file_name_convert='CHENNAI','DELHI'

set log_archive_max_processes='10'

set db_unique_name='DELHI'

set standby_file_management='AUTO'

set log_archive_config='dg_config=(CHENNAI,DELHI)'

set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles) db_unique_name=DELHI'

set log_Archive_dest_2='service=CHENNAI async noaffirm reopen=15 valid_for=(all_logfiles,primary_role) db_unique_name=CHENNAI'

set log_archive_config='dg_config=(CHENNAI,DELHI)';

sql channel aux "alter database add standby logfile ''/pkg/vddz8/oradz8/redo1/DELHI/standby_redo01.redo'' size 50M";

sql channel aux "alter database add standby logfile ''/pkg/vddz8/oradz8/redo1/DELHI/standby_redo02.redo'' size 50M";

sql channel aux "alter database add standby logfile ''/pkg/vddz8/oradz8/redo2/DELHI/standby_redo03.redo'' size 50M";

sql channel aux "alter database add standby logfile ''/pkg/vddz8/oradz8/redo2/DELHI/standby_redo04.redo'' size 50M";

sql channel prim "alter system archive log current";

sql channel aux "alter database recover managed standby database disconnect";

}

The Auxiliary connect is working fine.

rman target sys/*******

Recovery Manager: Release 12.2.0.1.0 - Production on Mo Feb 24 16:06:11 2020

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Mit Zieldatenbank verbunden: CHENNAI (DBID=125112213)

RMAN> connect auxiliary sys/*****@DELHI

Bei Hilfsdatenbank angemeldet: CHENNAI (nicht mit MOUNT angeschlossen)

But after sometime getting the below error -

Connected to help database (not started)
Approved channel: c1
Approved channel: c2
Approved channel: c3
Approved channel: c4
Approved channel: prim
RMAN-00571: ============================================== =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ============================================== =============
RMAN-03002: Error with command Duplicate Db at 02/24/2020 16:08:04
RMAN-05501: Duplication of target database is canceled
RMAN-03015: Error in the saved script Memory Script
RMAN-04014: Failed to start: ORA-01031: insufficient privileges

Not able to understand where the issue lies.

Thanks

Ameya Deshmukh

Answers