多选题You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three

题目
多选题
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）
A

Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

B

Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

C

Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

D

Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

E

Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

F

Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

相似考题

1.You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）A. ASM_POWER_LIMITB. ASM_DISKSTRINGC. ASM_DISKGROUPSD. INSTANCE_TYPE

2.You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）A、 mount the new disk group in the ASM instanceB、 restart the ASM instance and the production database instanceC、 register the new disk groups in the production database instanceD、 restart the ASM instance without restarting the production database instanceE、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

3.n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）A、 Oracle Migration AssistantB、 Recovery Manager （RMAN）C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance

4.You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.All databases of all versions use Automatic Storage Management (ASM).Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）A. The ASM compatibility attribute controls the format of the disk group metadata.B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.C. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

更多“多选题You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ”相关问题

  • 第1题：

    You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）

    • A、ASM_POWER_LIMIT
    • B、ASM_DISKSTRING
    • C、ASM_DISKGROUPS
    • D、INSTANCE_TYPE

    正确答案:A

  • 第2题：

    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

    • A、mount the new disk group in the ASM instance
    • B、restart the ASM instance and the production database instance
    • C、register the new disk groups in the production database instance
    • D、restart the ASM instance without restarting the production database instance
    • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

    正确答案:A

  • 第3题：

    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）

    • A、 RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
    • B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
    • C、 RMAN would relocate all the database files to an ASM disk group.
    • D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

    正确答案:C

  • 第4题：

    You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）

    • A、ASM_POWER_LIMIT
    • B、ASM_DISKSTRING
    • C、ASM_DISKGROUPS
    • D、INSTANCE_TYPE

    正确答案:A

  • 第5题：

    You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）

    • A、Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
    • B、Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
    • C、Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
    • D、Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
    • E、Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
    • F、Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

    正确答案:C,E,F

  • 第6题：

    Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） 

    • A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
    • B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
    • C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
    • D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

    正确答案:C

  • 第7题：

    多选题
    You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）
    A

    Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

    B

    Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

    C

    Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

    D

    Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

    E

    Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

    F

    Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.


    正确答案： E,B
    解析： 暂无解析

  • 第8题：

    多选题
    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）
    A

    The ASM compatibility attribute controls the format of the disk group metadata.

    B

    RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

    C

    The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

    D

    The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

    E

    The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.


    正确答案： E,B
    解析： 暂无解析

  • 第9题：

    单选题
    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）
    A

    RMAN would relocate all the database files to an ASM disk group.

    B

    RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

    C

    RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.

    D

    RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location， defined using OMF


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager（RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）
    A

    RMAN would relocate all the database files to an ASM disk group.

    B

    RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

    C

    RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.

    D

    RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity？ （）
    A

     ASM_POWER_LIMIT

    B

     ASM_DISKSTRING

    C

     ASM_DISKGROUPS

    D

     LARGE_POOL_SIZE


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）
    A

     BACKUP AS BACKUPSET

    B

     BACKUP AS COPY

    C

     BACKUP AS COMPRESSED BACKUPSET

    D

     BACKUP INCREMENTAL LEVEL n CUMULATIVE


    正确答案： B
    解析： 暂无解析

  • 第13题：

    You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity？ （） 

    • A、 ASM_POWER_LIMIT
    • B、 ASM_DISKSTRING
    • C、 ASM_DISKGROUPS
    • D、 LARGE_POOL_SIZE

    正确答案:A

  • 第14题：

    In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

    • A、Oracle Migration Assistant
    • B、Recovery Manager （RMAN）
    • C、Oracle Data Pump Export and Import
    • D、conventional Oracle Export and Import
    • E、operating system utilities to copy the files to the ASM instance

    正确答案:B

  • 第15题：

    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）

    • A、The ASM compatibility attribute controls the format of the disk group metadata.
    • B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
    • C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
    • D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
    • E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

    正确答案:A,B,D

  • 第16题：

    In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files.  Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance？（）

    • A、Oracle Migration Assistant
    • B、Recovery Manager （RMAN）
    • C、Oracle Data Pump Export and Import
    • D、conventional Oracle Export and Import
    • E、operating system utilities to copy the files to the ASM instance

    正确答案:B

  • 第17题：

    You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）

    • A、 BACKUP AS BACKUPSET
    • B、 BACKUP AS COPY
    • C、 BACKUP AS COMPRESSED BACKUPSET
    • D、 BACKUP INCREMENTAL LEVEL n CUMULATIVE

    正确答案:B

  • 第18题：

    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）

    • A、RMAN would relocate all the database files to an ASM disk group.
    • B、RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
    • C、RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
    • D、RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location， defined using OMF

    正确答案:A

  • 第19题：

    单选题
    n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）
    A

     Oracle Migration Assistant

    B

     Recovery Manager （RMAN）

    C

     Oracle Data Pump Export and Import

    D

     conventional Oracle Export and Import

    E

     operating system utilities to copy the files to the ASM instance


    正确答案： D
    解析： 暂无解析

  • 第20题：

    多选题
    You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）
    A

    Increase the value of the ASM_POWER_LIMIT parameter.

    B

    Set the DISK_REPAIR_TIME disk attribute to a lower value.

    C

    Specify the statement that adds the disk back to the disk group.

    D

    Increase the number of ASMB processes.

    E

    Increase the number of DBWR_IO_SLAVES in the ASM instance.


    正确答案： E,D
    解析： 暂无解析

  • 第21题：

    多选题
    You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）
    A

    Increase the value of the ASM_POWER_LIMIT parameter.

    B

    Set the DISK_REPAIR_TIME disk attribute to a lower value.

    C

    Specify the statement that adds the disk back to the disk group.

    D

    Increase the number of ASMB processes.

    E

    Increase the number of DBWR_IO_SLAVES in the ASM instance.


    正确答案： E,D
    解析： 暂无解析

  • 第22题：

    单选题
    Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（）
    A

     You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.

    B

     You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.

    C

     You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.

    D

     You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

    mount the new disk group in the ASM instance

    B

    restart the ASM instance and the production database instance

    C

    register the new disk groups in the production database instance

    D

    restart the ASM instance without restarting the production database instance

    E

    include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


    正确答案： D
    解析： 暂无解析

相关内容