How to restore a tablespace backup in a specific date/time
Hi, Fellows,
I have Oracle Standard Edition in my office, *** with no archivelog ***, and I need to restore a set of tablespaces so quickly, which are part of a schema's structure prepared for testings. Since a lot of tests can be executed in a single day, the datapump tools (expdp/impdp) take a looooong time to restore data and it is not fast enough for what we need. So, we had tried to use the RMAN, as described below for one of the schema's tablespaces:
--- Backup #1 ---
C:\...> rman target /
RMAN> backup tablespace guineapig;
to perform this backup, I had no need to shutdown the database, or something. Therefore, when do we need to restore its data, with the following comands: