Performing Oracle User-Managed Database Recoveries - OCP: Oracle Database 12c Administrator Certified Professional - page 84

exeRCiSe 2.3 (continued)
ORA-00279: change 5071583 generated at 08/17/2013 15:40:04 needed for thread 1
ORA-00289: suggestion :
/oracle01/fast_recovery_area/ORCL/archivelog/2013_08_17
/o1_mf_1_6_4bk76kwk_.arc
ORA-00280: change 5071583 for thread 1 is in sequence #6
ORA-00279: change 5091960 generated at 08/17/2013 15:49:05 needed for thread 1
ORA-00289: suggestion :
/oracle01/fast_recovery_area/ORCL/archivelog/2013_08_17
/o1_mf_1_7_4bk9ksb4_.arc
ORA-00280: change 5091960 for thread 1 is in sequence #7
ORA-00279: change 5112317 generated at 08/17/2013 16:29:13 needed for thread 1
ORA-00289: suggestion :
/oracle01/fast_recovery_area/ORCL/archivelog/2013_08_17
/o1_mf_1_8_4bk9p236_.arc
ORA-00280: change 5112317 for thread 1 is in sequence #8
ORA-00279: change 5112647 generated at 08/17/2013 16:31:29 needed for thread 1
ORA-00289: suggestion :
/oracle01/fast_recovery_area/ORCL/archivelog/2013_08_17
/o1_mf_1_9_4bk9p2mz_.arc
ORA-00280: change 5112647 for thread 1 is in sequence #9
ORA-00279: change 5112649 generated at 08/17/2013 16:31:30 needed for thread 1
ORA-00289: suggestion :
/oracle01/fast_recovery_area/ORCL/archivelog/2013_08_17
/o1_mf_1_10_4bk9p3gz_.arc
ORA-00280: change 5112649 for thread 1 is in sequence #10
Log applied.
Media recovery complete.
10. Open the database with the ALTER DATABASE OPEN RESETLOGS command. The data-
base will open:
SQL> alter database open resetlogs;
Database altered.
11. Log into the SCOTT schema. Do a SELECT * FROM TEST_TABLE . You should have only
two records in the table:
SQL> Connect scott/tiger
Connected.
SQL> Select * from test_table;
ID