多项选择题
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery.
Which two tasks would you be required to perform in the recovery process？ （）
A.open the database with the RESETLOGS option
B.open the database with the RESTRICTED option
C.recover all the data files to the same system change number （SCN）
D.recover to the required SCN only that data file in which the error occurred
相关考题
-
单项选择题
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1 3> ALTER DATABASE MOUNT 4> RESTORE DATABASE 5> RECOVER DATABASE 6> ALTER DATABASE OPEN RESETLOGS 7> } With reference to this scenario， which statement is true？（）
A.RMAN recovers up to log sequence 230， but not including 230.
B.RMAN returns an error because the log sequence number mentioned in the command should be 229.
C.RMAN returns an error because the log sequence number mentioned in the command may never be missing.
D.RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing. -
多项选择题
Foranincompleterecovery，whichfourbackuptypescanbeusedbyRecoveryManager（RMAN）torestoredatafiles？（）
A.RMAN image copies
B.RMAN database backups
C.RMAN tablespace backups
D.usermanaged backups placed in the flash recovery area
E.usermanaged backups that have been cataloged with RMAN
F.usermanaged data file backups for which the full path name is specified -
单项选择题
Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3： Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）
A.only case 1
B.only case 2
C.only case 3
D.case 1 and 2
E.case 2 and 3
F.case 1 and 3
G.all cases： case 1， case 2 and case 3
