單項(xiàng)選擇題

Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：
01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：
’/u01/app/oracle/oradata/orcl/example01.dbf’
You need to rectify the corruption while ensuring the following： The data file should remain online.
The mean time to recover （MTTR） should be minimal.
You are not using a backup control file， and all the archived logs are accessible.
Which option would you choose？（）

A.flash back the corrupted blocks
B.use the DBMS_REPAIR package
C.use the RMAN TSPITR command
D.use the RMAN BLOCKRECOVER command
E.use the RESTORE DATABASE and RECOVER DATABASE commands
F.investigate the time at which the corruption occurred and perform a point-in-time recovery

你可能感興趣的試題

單項(xiàng)選擇題

The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）

A.The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
B.DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
C.The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.
D.The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.
E.The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent

單項(xiàng)選擇題

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

A.the DBNEWID utility
B.the ANALYZE command
C.the RMAN LIST command
D.the RMAN REPORT command
E.the RMAN CROSSCHECK command
F.the RMAN BLOCKRECOVER command

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

你可能感興趣的試題

The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

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

The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）