1

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?

7
  • you should use "DUPLICATE TARGET DATABASE for standby FROM ACTIVE DATABASE;" if you want a standby database. then this error should not occur.
    – miracle173
    Jan 9 at 22:37
  • archive logging should be enabled on the primary database
    – miracle173
    Jan 9 at 22:40
  • @DmitryDemin, I'm asking about using stand-by DB as source..
    – habad
    Jan 10 at 8:52
  • @habad You can use standby as source for other standby. 1. Create backup standby database using rman .Copy backup +archive log to new standby host.2. restore database from backup. 3 recover database from archive log. 4 create standby controlfile on primary host 'ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/db3_stby. ctl'; ' 5 Configure tnsnames.ora on primary and new standby . 6 Configure LOG_ARCHIVE_DEST_3 on primary host. 7 Start standby listener and standby database on new host Jan 10 at 9:44
0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.