Duplicate in time from tape backup, possible? How to achieved that...
FunkyJan 16 2008 — edited Jan 16 2008We are using catalog, online RMAN backup on tape, Oracle 10gR2.02, Linux RH4 ES, EMC Legato.
But we need very often to restore database from tape (this is conditio sinne qua non for restore) in some time in the past. restore should be on different server, different location.
We know to restore using catalog...no problem...but...on link: http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrecov.htm#1007514
it is written that if we do not want to change entries in RMAN catalog to newly restored database, we should use "DUPLICATE" way of conning.
So how to do that or is it possible to duplicate database with "DUPLICATE" RMAN command on different server different location, but in some time before...?
Explanation why:
We cannot use restore with classic point in time recovery because we pollute catalog.
Problem is that after every "recover" operation...catalog is "polluted" with entries from this recovered database. On metalink we found similar note about this issue:
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUG&p_id=6191860
So obviously we need to use DUPLICATE .... how...
THX