RMAN DUPLICATE FROM Active Database From Standby ends with ORA-01671

Hi.

Quite interesting question was asked by one of our customers:

“Is it possible/supported to do RMAN DUPLICATE FOR STANDBY FROM ACTIVE DATABASE when TARGET is STANDBY ?”

It’s really seasonable question, especially when You already have standby database and wanna refresh a development environment using standby as a source/target to not stress primary database .

There are no such restriction in 11.2 “Prerequisites Specific to Active Database Duplication”, so why not ? 😉

But even Oracle wanted to provide mentioned functionality it’s not often used(tested), so let’s see what we get as a result Continue reading