Database Backup and Recovery (MOSC)

MOSC Banner

RMAN recover - how to start recovery again after an Open resetlogs

edited Nov 21, 2019 10:36AM in Database Backup and Recovery (MOSC) 11 commentsAnswered

Oracle EE 12.1.0.2

Linux  2.6.32-754.23.1.el6.x86_64

What happened: There is an interval partitioned table (year long partitions) that was mistakenly purged by dropping the current years partition. The process was put into place every night that dropped the current partition.   So, every night, prior to the drop partition, we would have had the current days worth of data.  I know the exact time when the drop partition job juns.

In order to get the data back I need to restore from the backup to the point in time just prior to the time the partition is dropped, export the days worth of data and then somehow recover until the point in time just prior to the next days drop partition time. I need to do this for about 14 days worth of data. I had planned on setting a restore point prior to opening the database , opening the database, reading the data and then flashing back to the restore point in order to recover until just before the

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