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

exeRCiSe 2.3 (continued)
-----------
5135522
6. Shut down the database.
SQL> shutdown abort
ORACLE instance shut down.
7. Once you are sure the database is down, restore the database data files from their
backup location to the location where the database files belong:
[oracle@localhost orcl]$ pwd
/oracle01/backup/orcl
[oracle@localhost orcl]$ cp *.dbf /oracle01/oradata/orcl/*
8. Mount the database:
[oracle@localhost orcl]$ sqlplus "/ as sysdba"
SQL*Plus: Release 12.1.0.1.0 Production on Tue Feb 18 14:22:34 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 167395328 bytes
Fixed Size 1298612 bytes
Variable Size 142610252 bytes
Database Buffers 20971520 bytes
Redo Buffers 2514944 bytes
Database mounted.
9. Recover the database using the RECOVER DATABASE UNTIL CHANGE command. You
will use the SCN you queried in step 3 as the SCN to recover to. Enter AUTO when
prompted for an archived redo log to apply:
SQL> Recover database until change 5135413;
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_.arc
ORA-00280: change 5071334 for thread 1 is in sequence #5
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto