Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to revert a database back to one day previous state.

664050Feb 3 2011 — edited Feb 3 2011

Hi,

Of course, if no backup, then no restore.

However, unfortunately there is NO database backup available i.e. export/expdp/OS Backup/RMAN/Flashback. But, the requirement is to prepare another database on another server with one day back state. So, can we take fresh backup of the database which has all the archived logs, and restore it on another server as one day back previous state.

Is there any possible way to do this by using existing archive logs? Can LogMiner help in this regard?

Thanks,
SYED.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2011

Added on Feb 3 2011

#backup, #general-database-discussions

4 comments

1,467 views