DUPLICATE FROM ACTIVE DATABASE Fails With RMAN-03009 ORA-17628 ORA-19505

While creating a new physical standby database by using RMAN duplicate command, the following errors occur:

RMAN> run {
allocate channel prim1 type disk;
allocate channel prim2 type disk;
allocate auxiliary channel standby1 type disk;
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
...
..
.
RMAN-03009: failure of backup command on prim2 channel 
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""

SOLUTION

  1. Check and remove the old standby database data files.
  2. Make sure directories for standby database data files created and accessible.

RMAN Backup Failed With RMAN-03014 RMAN-03009

RMAN failed with errors while resync the recovery catalog.

...
..
.
starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script al_netbkup
RMAN-03002: failure of allocate command at 01/10/2018 08:52:24
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 01/10/2018 08:52:24
ORA-01403: no data found
RMAN>

Find there is a database guarantee restore point.

SQL> select * from v$restore_point;

SCN DATABASE_INCARNATION# GUA STORAGE_SIZE TIME
---------- --------------------- --- ------------ ---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE
--------------------------------------------------------------------------- ---
NAME CON_ID
-------------------------------------------------------------------------------------------------------------------------------- ----------
 851245362 1 YES 1.9327E+10 09-JAN-18 10.46.35.000000000 AM
 YES
POINT_201801091046

Drop this restore point.

SQL> drop restore point POINT_201801091046;

Restore point dropped.

SQL> select * from v$restore_point;

no rows selected

Check again, both sync catalog and RMAN backups are successful.

RMAN> list backup of database;

starting full resync of recovery catalog
full resync complete

List of Backup Sets
===================
...
..
.