This discussion is archived
6 Replies Latest reply: Feb 27, 2013 7:54 AM by 825384 RSS

Creating physical standby database from another physical standby database

825384 Newbie
Currently Being Moderated
hi,
We have one production database and one physical standby of the production. Now we have situation where we need to create one database from either production or from standby. As production is loaded we can not do it using active database option. Now we have the only option to copy the database from standby.

As of now we open the standby and copy it using rman duplicate database and again we put it back to standby mode.

Is it possible to create standby database from standby database only?
Oracle version : 11.1.0.7.0

I have seen procedure allowing to do the same in version 11.2.0.3. I have tried searching for the difference but didn't find when this feature was introduced.

Thanks,
Ketul Patel

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points