多项选择题
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.)
单项选择题 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?()
多项选择题 In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this: 1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow?() (Choose two.)