Question about RMAN and SCN
Every RMAN recovery scenario that I read about uses the SCN identifier to recover a table or tablespace, but how do you get this value?
The scenarios go like this:
1. Create the object
2. Backup the database
3. Get the SCN
4. Drop the object
5. Recover to the SCN
The problem is, I can do this in a test, but what happens when a user drops an object during a work day and we don't know when exactly it happened? It's not like they will know the SCN. I can use the "until time ___" clause, but is there a way to get the SCN in a backup or know where to easily find them in the alert log, etc.?
0