多项选择题
While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.
Which RMAN command do you use to perform BMR and repair the corrupt block?()
A. RECOVER FILE=1201 BLOCK=1968
B. RECOVER CORRUPTION LIST
C. RECOVER DATAFILE 1201 BLOCK 1968
D. RECOVER BLOCK CORRUPTION LIST
E. None of the above
相关考题
-
多项选择题
Whichofthefollowingarecorrectaboutblockmediarecovery?()
A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
B. Logical corruptions are repairable by BMR
C. Physical corruptions are repairable by BMR
D. RMAN can use any backup for a BMR restore
E. ARCHIVELOG mode is not required if you have both a full and incremental backup for restore -
多项选择题
Which two statements are true about the duplexing of the backups taken by RMAN? ()(Choose two.)
A. It's only supported for the backups performed on the tape
B. It is not supported for backup operations that produce image copies
C. Duplex backups need a parallelism for the device to be equal to number of copies
D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously -
单项选择题
The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?()
A. 1,4,5,2,3
B. 1,4,3,2,5
C. 4,5,2,3,1
D. 2,3,4,5,1
E. 1,4,2,3,5
