Is it possible to duplicate a standby database on the fly

oraclerman

Can I duplicate a standby database on the fly?

Currently, I'm getting this error:

RMAN-03002: failure of Duplicate Db command at 01/08/2021 01:55:58
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01152: file 3
was not restored from a sufficiently old backup

When I run:

DUPLICATE TARGET DATABASE TO clone_db FROM ACTIVE DATABASE;

Any idea?

Best Answer

Step 2: Mount or Open the Source Database Before beginning RMAN duplication, mount or open the source database it if it is not already mounted or open. If the source database is open, then archiving must be enabled. If the source database is not open, and if it is not a standby database, then it must have been shut down consistently.

Duplicating a Database

To create a standby database with the DUPLICATE command you must connect as target to the primary database and specify the FOR STANDBY option. You cannot connect to a standby database and create an additional standby database. Basic Concepts of Standby Creation with RMAN

Related Question