单项选择题
Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）
A. shutdown restore datafile 4； recover datafile 4； alter database open；
B. Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；
C. Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；
D. Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；
E. Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
相关考题
-
单项选择题
What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；
A. Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.
B. The restore command will fail.
C. The recover command will fail.
D. The alter database open resetlogs command will fail.
E. All these commands will fail because they must be in the confines of a run block.
-
单项选择题
IfyoufinderrorsintheviewV$DATABASE_BLOCK_CORRUPTIONwithastatusofMEDIA_CORRUPT，whatRMANcommandwouldyouruntocorrecttheproblem？（）
A. recover lost blocks
B. recover corrupt blocks
C. recover media corrupt blocks from list
D. recover corrupt blocks from list
E. recover corruption list -
多项选择题
You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（）
A. SYSTEM
B. SYSAUX
C. UNDO
D. USERS
E. TEMP
F. This restore is not possible
