i was reading abt these methods of recovery. In classrooms, the lecturer always simulate this sort of recovery by noticing the time (for time-based recovery), or the log seq# (for changed-based recovery). In reality, there will always be careless users who deleted a record they shldnt and now wanted those back. Eg, a programmer accidentally deletes a program source code which is located in PGMR tablespace, or a user deletes records from the HR tablespace
Q1: How do i find out which datafile/datafiles stored the objects that i need to recover knowing only the tablespace?
Q2: How do i find out what time the transaction occurs (usually users dont notice the time)? or How do i find out which SCN the transaction occurs?
Any suggestions on how to go abt time-based, change-based recovery and any experience to share is very much welcome
Background: Oracle 9.2.0 running on win2k