Database Reference
In-Depth Information
exeRCiSe 2.2 (continued)
7. To recover the database, issue the RECOVER DATABASE command. The command may
return a response that says “media recovery complete,” as shown here:
SQL> recover database
Media recovery complete.
You may also be prompted to apply archived redo logs. Simply enter AUTO at
the prompt:
SQL> recover database
ORA-00279: change 5071334 generated at 08/17/2013 15:35:51 needed for thread 1
ORA-00289: suggestion :
/oracle01/fast_recovery_area/ORCL/archivelog
/2013_08_17/o1_mf_1_5_4bk6onh8_.arcORA-00280:
change 5071334 for thread 1 is in sequence #5
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
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_.arcORA-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_.arcORA-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_.arcORA-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
Search WWH ::




Custom Search