單項選擇題

View the Exhibit.

One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table.
Which statement is true？（）

A.You must recover all data files to the required system change number （SCN）.
B.You must recover all data files， except those that are offline， to the required SCN .
C.You must recover all data files belonging to the USERS tablespace to the required SCN.
D.You cannot recover all data files because segment space management is performed manually for the undo tablespace.

你可能感興趣的試題

多項選擇題

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.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true？（）

你可能感興趣的試題

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？ （）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

View the Exhibit.

One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table.
Which statement is true？（）

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？（）