單項(xiàng)選擇題

Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.
What is the least disruptive recover strategy available in Oracle9i？（）

A.Rebuild the index using the online option.
B.Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again.
C.Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.
D.Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

你可能感興趣的試題

單項(xiàng)選擇題

Examine this syntax which allocates channels during a parallel image copy：
RMAN> CONFIGURE DEVICE TYPE disk parallelism 4：
2> COPY
3> datafile 1 TO ‘/BACKUP/datafile1.dbf’，
4> datafile 2 TO ‘/BACKUP/datafile2.dbf’，
5> datafile 3 TO ‘/BACKUP/datafile3.dbf；
RMAN>COPY
2> datafile 4 TO ‘/BACKUP/datafile4.dbf’；
How many channels are used？（）

A.0
B.1
C.3
D.4

單項(xiàng)選擇題

You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）

A.SYSDBA
B.SYSOPER
C.No system privileges are required for the RMAN user.
D.Only SYS user can connect and execute RMAN commands on a target database.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）

你可能感興趣的試題

You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.
What is the least disruptive recover strategy available in Oracle9i？（）

You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）