Database Backup and Recovery (MOSC)

MOSC Banner

Recover data from archivelogs created prior to a backup has been taken

I took a full backup of a database and restored this onto a new server.
After successful restore the database got a new incarnation after issuing "alter database open resetlogs".

From this point in time archivelogs are now generated.
I have not yet created any backups for this database, meaning i have all the archivelogs from the point in time i executed open resetlogs up till today.

Now, During the first couple of days after restore, there were some data that was inserted into a table, and some automated schedules processed this data, before they got rid of the partitions keeping the incoming data ( In normal situations this is as expected- however in this case something wrong happened and data was incorrectly processed and later deleted).

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