Point in time recovery WITHOUT RMAN
I am practicing backup and recovery below.
1.Insert one record into Scott's EMP table
SQL> SELECT CURRENT_SCN FROM V$DATABASE;
CURRENT_SCN----------- 2395700
—Recover here———
2. Add one record to Scott's EMP table
SQL> SELECT CURRENT_SCN FROM V$DATABASE;
CURRENT_SCN----------- 2503913
★I took hot backup here★
3. Failure occurs (data file and control file completely lost)
4. Manually recover to state 1
what should I do to get back to
CURRENT_SCN----------- 2395700
Thank you.