Hi , I would really appreciate your assistance and input.
I am cloning/duplicating a database from a standby database, previously we used to cancel managed recovery on the standby database to clone it always worked.
Now to allow our business to run reports anytime on the standby database(active dataguard), we applied patch (14263190) so that we still duplicate without cancelling managed recovery and allow business to get real time reports.Our duplicate now fails with :
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/ptchdb002/oradata/system01.dbf'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/05/2016 09:17:21
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 195235 and starting SCN of 8670589784878
RMAN>
Recovery Manager complete.
But after applying patch 14263190: STANDBY TO NORMAL DUPLICATION SOMETIMES THROWS RMAN-5531
Changes made on the RMAN configs on the standby database:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
CONFIGURE BACKUP OPTIMIZATION OFF;
Your assistance will be greatly appreciated.
Regards,
Mzwandile