OCP 1Z0 053 86

86.Your production database is running in archivelog mode and you are using recovery manager (RMAN) 
with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the 
database instance after a regular maintenance task on Sunday, the database fails to open displaying the 
message that the data file belonging to the users tablespace are corrupted. 
The steps to recover the damaged data files are follows: 
1. Mount the database 
2. Open the database 
3. Recover the data file 
4. Restore the data file 
5. Make the data file offline 
6. Make the data file online 
Which option identifies the correct sequence that you must use to recover the data files? 
A. 2, 4, 3 
B. 1, 4, 3, 2 
C. 2, 5, 4, 3, 6 
D. 5, 2, 4, 3, 6 
E. 1, 5, 4, 3, 6, 2 
Answer: E 

因有文件损坏，不能open。只有先mount，修复后再open

参见
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta2008.htm#RCMRF90312

Example 3-19 Setting a New Name for a Restored Data File

Assume that /disk1, which contains data file 9, suffers a media failure. This example specifies a new name for the data file, restores it, updates the control file to use the new name, recovers it, and then brings it online:

RUN
{
  SQL "ALTER DATABASE DATAFILE 9 OFFLINE";
  SET NEWNAME FOR DATAFILE 9 TO '/disk2/users01.dbf';
  RESTORE DATAFILE 9;
  SWITCH DATAFILE ALL;
  RECOVER DATAFILE 9;
  SQL "ALTER DATABASE DATAFILE 9 ONLINE";
}