Database Backup and Recovery (MOSC)

MOSC Banner

User deleted prod data 12/9 it's now 12/22

Greetings,

History:

I have 12.1 EE standalone database that I'm in the process of upgrading. Lots of ppl working on it.

User deleted data out of table1 12/9 @ ~noon. I restored table1 from 12/8 backup into non-prod database.

The goal is to recover table until 12/9 @ 20:00, I have archive logs for prod.

However, I can't use prod logs on non-prod DB. So this is of no use.


Action Plan:

So I have to restore table1 to table2 on prod, then "recover table2 until time." Lastly, drop table1 and rename table2 to table1.

Questions:

How to "recover table2 until time"? Table2 did not exist when I did the backup. So I don't have a backup of table2.

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