Database Backup and Recovery (MOSC)

MOSC Banner

How to restore a tablespace backup in a specific date/time

edited Aug 26, 2018 5:06AM in Database Backup and Recovery (MOSC) 4 commentsAnswered

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center