rman duplicate command failed with error while allocating multiple channel through run block
$ cat Proddb_standby_build.sh
connect target sys/Password@PRODDB_PRIM
connect auxiliary sys/Password@PRODDB_OCI_STDBY
run {
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
allocate channel ch5 type disk;
allocate channel ch6 type disk;
allocate auxiliary channel ch7 type disk;
allocate auxiliary channel ch8 type disk;
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER;
}
error details:
$ tail -90f Proddb_standby_build.log
Spooling started in log file: /home/oracle/scripts/Migration/proddb/Proddb_standby_build.log
Recovery Manager19.10.0.0.0
RMAN>
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.08.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.08.00.00 in TARGET database is not current
connected to target database: PRODDB (DBID=2143832746)
RMAN>
connected to auxiliary database: PRODDB (not mounted)
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11>
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=1565 instance=proddb1 device type=DISK
allocated channel: ch2
channel ch2: SID=1711 instance=proddb1 device type=DISK
allocated channel: ch3
channel ch3: SID=1778 instance=proddb1 device type=DISK
allocated channel: ch4
channel ch4: SID=1850 instance=proddb1 device type=DISK
allocated channel: ch5
channel ch5: SID=2134 instance=proddb1 device type=DISK
allocated channel: ch6
channel ch6: SID=2205 instance=proddb1 device type=DISK
allocated channel: ch7
channel ch7: SID=2411 device type=DISK
allocated channel: ch8
channel ch8: SID=2477 device type=DISK
Starting Duplicate Db at 19-OCT-21
current log archived
contents of Memory Script:
{
backup as copy reuse
passwordfile auxiliary format '/u02/app/oracle/product/19.0.0.0/dbhome_2/dbs/orapwproddb11' ;
}
executing Memory Script
Starting backup at 19-OCT-21
Finished backup at 19-OCT-21
duplicating Online logs to Oracle Managed File (OMF) location
duplicating Datafiles to Oracle Managed File (OMF) location
contents of Memory Script:
{
sql clone "alter system set control_files =
''+DATAC1/PRODDB_OCI/CONTROLFILE/current.328.1079736267'' comment=
''Set by RMAN'' scope=spfile";
backup as copy current controlfile for standby auxiliary format '+DATAC1/PRODDB_OCI/CONTROLFILE/current.328.1079736267';
sql clone "alter system set control_files =
''+DATAC1/PRODDB_OCI/CONTROLFILE/current.328.1079736267'' comment=
''Set by RMAN'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set control_files = ''+DATAC1/PRODDB_OCI/CONTROLFILE/current.328.1079736267'' comment= ''Set by RMAN'' scope=spfile
Starting backup at 19-OCT-21
channel ch1: starting datafile copy
copying standby control file
output file name=+DATAC1/PRODDB_OCI/CONTROLFILE/current.328.1079736267 tag=TAG20211019T015841
channel ch1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 19-OCT-21
sql statement: alter system set control_files = ''+DATAC1/PRODDB_OCI/CONTROLFILE/current.328.1079736267'' comment= ''Set by RMAN'' scope=spfile
Oracle instance shut down
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
released channel: ch5
released channel: ch6
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/19/2021 01:59:21
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Solution: Configure parallelism in rman and run duplicate
Connect to rman target:
rman
connect target sys/Password@PRODDB_PRIM
connect auxiliary sys/Password@PRODDB_OCI_STDBY
Configure parallelism:
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
Duplicate will run without any errors now
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER;
No comments:
Post a Comment