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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!