易搜题 > 资格证大类 > 计算机编程 > 问题详情
问题详情

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.)

A

2, 6, 4, 5, 3

B

1, 2, 4, 5, 3, 6

C

1, 2, 4, 6, 3

D

1, 2, 7, 5, 3, 6

未找到的试题在搜索页框底部可快速提交,在会员中心"提交的题"查看可解决状态。 收藏该题
查看答案

相关问题推荐

  • Examine the following commands and their output: View the exhibit and examine the Flashback Version Query that was executed after the preceding commands. What could be the possible cause for the query not displaying any row?()

    A、 Flashback logging is not enabled for the database.

    B、 The changes made to the table are not committed.

    C、 Supplemental logging is not enabled for the database.

    D、 The database is not configured in ARCHIVELOG mode.

  • Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.  Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?() 

    A

     Redo logs 

    B

     Control file

    C

     The latest backup of only the damaged data file

    D

     The latest backup of all the data file in the USERS tablespace

    E

     Temporary files of temporary tablespace

    F

     Archive Logs since the latest backup to point of failure

  • Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job?()

    A

     SET_ATTRIBUTE_NULL

    B

     ALTER_JOB

    C

     ALTER_JOB_PARAMETERS

    D

     ALTER

    E

     SET_ATTRIBUTE

  • The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?()

    A、The Oracle database will perform block checking for the index blocks only

    B、The Oracle database will not perform block checking for any of the data blocks

    C、The Oracle database will perform block checking for the default permanent tablespace only

    D、The Oracle database will perform block checking for the data blocks in all user tablespaces

    E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

  • Which command will result in a trace file being created with the create controlfile command contained in it?()  

    A、 alter database backup controlfile

    B、 alter database backup controlfile to trace

    C、 alter database controlfile backup

    D、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’

    E、 alter database begin controlfile backup

联系客服 会员中心
TOP