FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP(2013-02-04 09:30:00'，'YYYY-MM-DD HH:Ml:SS'); 1

SELECT * FROM customers AS OF SCN 123456; 2

FLASHBACK TABLE customers TO BEFORE DROP; 3

FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP(2013-02-04 09:30:00','YYYY-MM-DDHH:Ml:SS'); 4

SELECT *FROM customers VERSIONS BETWEEN SCN 123456AND 123999; 5

ALTER TABLE customers FLASHBACK ARCHIVE; 6

Which set of statements depends on the availability of relevant undo data in the undo tablespace?

You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. 

You want to create a test database from the production database and allow the production database to remain open during the duplicate process. 

You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. 

How would you achieve this?