Database Reference
In-Depth Information
4. If you restored the wrong version of data file C:\APP\ORACLE\ORADATA\MYCDB\
F0C1AB908C5349DD93E43CE41D6A4188\DATAFILE\O1_MF_USERS_9KKF4Z7O_.DBF, then
replace it with the correct one
Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Restore and recover datafile 12; Recover datafile 7; Recover datafile 8;
...
Strategy: The repair includes complete media recovery with no data loss
Repair script: C:\APP\ORACLE\diag\rdbms\mycdb\mycdb\hm\reco_2067260308.hm
There are several things to notice in this output:
1. First is the repeated output of the LIST FAILURE command.
2. Next, RMAN begins to review the errors and generate recovery actions.
3. Then RMAN displays the manual recovery actions that are available.
For example, if the data file were there but just offline, the manual action might be
to bring the data file back online. In our case, there are no manual actions available
because the data file is missing.
4. Next, you will see some optional manual actions.
In this case, these actions are there for us to perform in case we accidently renamed the
file or copied the wrong file into place. None of these is the case here.
5. Finally, you see the Automated Repair Options section.
This section provides you with the actions needed to restore and recover the missing
data file. In this case, we are being told to restore three data files (12, 7, and 8). Note
that the output also includes a repair script, which contains the commands needed to
restore and recover the database. The repair script is the place to check for all of the
commands that need to be used.
At this point, we could manually run the RMAN commands to restore and recover the
data files in question. If we wanted to further exercise the Data Recovery Advisor, we could
then use the REPAIR FAILURE command, as shown here (we have removed the output of the
actual repair since it isn't important to the overall concept we are trying to teach):
RMAN> repair failure;
Strategy: The repair includes complete media recovery with no data loss
Repair script: C:\APP\ORACLE\diag\rdbms\mycdb\mycdb\hm\reco_3183092618.hm
contents of repair script:
# recover datafile
sql 'MYPDB' 'alter database datafile 7, 8, 9 offline';
recover datafile 7, 8, 9;
sql 'MYPDB' 'alter database datafile 7, 8, 9 online';
Search WWH ::




Custom Search