多选题When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）AThread number.BLog Sequence number.CControl file sequence number.DName of the last archived log.

题目
多选题
When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）
A

Thread number.

B

Log Sequence number.

C

Control file sequence number.

D

Name of the last archived log.

相似考题

1.Which of the following is a characteristic of a sequence?()A.A sequence will never generate duplicate valuesB.The MAXVALUE of a sequence can be equal to the MINVALUEC.It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zeroD.When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries

2.When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）A、Until SCNB、Until timeC、Until cancelD、Recover using backup control file.

3.Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

4. You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command：   RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS；   After configuring the recovery window， you performed the database backup as follows：（）  A、 Backup RB1 at log sequence number 12871 on 5th JanB、 Backup RB2 at log sequence number 15622 on 12th JanC、 Backup RB3 at log sequence 16721 on 15th JanD、 On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.

更多“多选题When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）AThread number.BLog Sequence number.CControl file sequence number.DName of the last archived log.”相关问题

  • 第1题：

    You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）

    • A、 The log sequence for the database will restart from 1.
    • B、 The log sequence number will be written to the control file.
    • C、 The log sequence number will be written to the datafile headers.
    • D、 The log sequence number will be written to the initialization parameter file.

    正确答案:D

  • 第2题：

    Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?（）

    • A、stored scripts in the recovery catalog
    • B、backups that can be deleted from disk
    • C、backup sets and image copies are obsolete
    • D、backups that do not have the AVAILABLE status in the RMAN repository RMAN

    正确答案:A,D

  • 第3题：

    Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed?（）

    • A、Stored scripts in the recovery catalog
    • B、Backups that can be deleted from disk
    • C、Backup sets and images copies that are obsolete
    • D、Backups that do not have the AVAILABLE status in the RMAN repository

    正确答案:A,D

  • 第4题：

    Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?（）

    • A、Stored scripts in the recovery catalog
    • B、Backups that can be deleted from disk
    • C、Backup sets and images copies that are obsolete
    • D、Backups that do not have the AVAILABLE status in the RMAN repository

    正确答案:A,D

  • 第5题：

    You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

    • A、 user managed complete recovery
    • B、 user managed incomplete recovery
    • C、 RMAN-based complete recovery
    • D、 RMAN-based incomplete recovery

    正确答案:D

  • 第6题：

    单选题
    Which components are needed for successful and most efficient recovery.（）
    A

     The backup RB3 and the current online redo log files

    B

     the backup RB2 and the archived redo log files after the log sequence number 15622

    C

     Backup R81 and the archived redo log hies after the log sequence number 12871

    D

     The backup RB3 and the archived redo log files after the log sequence number 16721


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

  • 第7题：

    多选题
    Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?（）
    A

    Stored scripts in the recovery catalog

    B

    Backups that can be deleted from disk

    C

    Backup sets and images copies that are obsolete

    D

    Backups that do not have the AVAILABLE status in the RMAN repository


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

  • 第8题：

    单选题
    You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）
    A

     UNTIL CANCEL

    B

     UNTIL SCN

    C

     UNTIL SEQUENCE

    D

     UNTIL TIME


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

  • 第9题：

    多选题
    Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?（） (Choose two.)
    A

    stored scripts in the recovery catalog.

    B

    backups that can be deleted from disk.

    C

    backup sets and image copies are obsolete.

    D

    backups that do not have the AVAILABLE status in the RMAN repository.


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

  • 第10题：

    多选题
    Using the LIST command in Recovery Manager （RMAN）， which two pieces of information from the RMAN repository can be listed？ （）
    A

    backups that can be deleted

    B

    stored scripts in the recovery catalog

    C

    backup sets and image copies that are obsolete

    D

    only the most recent backup sets or image copies

    E

    backups that do not have the AVAILABLE status in RMAN repository


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

  • 第11题：

    多选题
    Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed?（）
    A

    Stored scripts in the recovery catalog

    B

    Backups that can be deleted from disk

    C

    Backup sets and images copies that are obsolete

    D

    Backups that do not have the AVAILABLE status in the RMAN repository


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

  • 第12题：

    多选题
    Which two patented or patent-pending compression and caching technologies are used for WX/WXC devices?（）(Choose two.)
    A

    Network Sequence Caching (NSC)

    B

    Molecular Sequence Caching (MSC)

    C

    Network Sequence Reduction (NSR)

    D

    Molecular Sequence Reduction (MSR)


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

  • 第13题：

    Which of the following is a characteristic of a sequence?（）

    • A、A sequence will never generate duplicate values
    • B、The MAXVALUE of a sequence can be equal to the MINVALUE
    • C、It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero
    • D、When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries

    正确答案:B

  • 第14题：

    When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）

    • A、Thread number.
    • B、Log Sequence number.
    • C、Control file sequence number.
    • D、Name of the last archived log.

    正确答案:A,C

  • 第15题：

    You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

    • A、 UNTIL CANCEL
    • B、 UNTIL SCN
    • C、 UNTIL SEQUENCE
    • D、 UNTIL TIME

    正确答案:A

  • 第16题：

    Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards.  The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：  RMAN> RUN {  2> SET UNTIL SEQUENCE 230 THREAD 1;  3> ALTER DATABASE MOUNT;  4> RESTORE DATABASE;  5> RECOVER DATABASE;  6> ALTER DATABASE OPEN RESETLOGS; 7> };  With reference to this scenario， which statement is true？（）

    • A、RMAN recovers up to log sequence 230， but not including 230.
    • B、RMAN returns an error because the log sequence number mentioned in the command should be 229.
    • C、RMAN returns an error because the log sequence number mentioned in the command may never be missing.
    • D、RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.

    正确答案:A

  • 第17题：

    In which three situations is incomplete recovery required？（）

    • A、After a shutdown abort.
    • B、When recovering to an SCN.
    • C、When recovering until a specific time.
    • D、When a required archived log is missing.

    正确答案:B,C,D

  • 第18题：

    单选题
    You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）
    A

     The log sequence for the database will restart from 1.

    B

     The log sequence number will be written to the control file.

    C

     The log sequence number will be written to the datafile headers.

    D

     The log sequence number will be written to the initialization parameter file.


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

  • 第19题：

    单选题
    You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）
    A

     user managed complete recovery

    B

     user managed incomplete recovery

    C

     RMAN-based complete recovery

    D

     RMAN-based incomplete recovery


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

  • 第20题：

    多选题
    Which two types of optimization does the WX 60 device perform when Exchange 2003 and Outlook 2003 areused in the network? （）(Choose two.)
    A

    Packet Flow Acceleration

    B

    Network Sequence Caching

    C

    AppFlow's MAPI acceleration

    D

    Molecular Sequence Reduction


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

  • 第21题：

    多选题
    When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）
    A

    Thread number.

    B

    Log Sequence number.

    C

    Control file sequence number.

    D

    Name of the last archived log.


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

  • 第22题：

    多选题
    Using the LIST command in Recovery Manager （RMAN），which two pieces of information in the RMAN repository can be listed？（）
    A

    stored scripts in the recovery catalog

    B

    backups that can be deleted from disk

    C

    backup sets and image copies are obsolete

    D

    backups that do not have the AVAILABLE status in the RMAN repository


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

  • 第23题：

    单选题
    You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }
    A

     NOMOUNT

    B

     MOUNT

    C

     OPEN

    D

     RESTRICTED


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

  • 第24题：

    单选题
    Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards.  The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：  RMAN> RUN {  2> SET UNTIL SEQUENCE 230 THREAD 1;  3> ALTER DATABASE MOUNT;  4> RESTORE DATABASE;  5> RECOVER DATABASE;  6> ALTER DATABASE OPEN RESETLOGS; 7> };  With reference to this scenario， which statement is true？（）
    A

    RMAN recovers up to log sequence 230， but not including 230.

    B

    RMAN returns an error because the log sequence number mentioned in the command should be 229.

    C

    RMAN returns an error because the log sequence number mentioned in the command may never be missing.

    D

    RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.


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

相关内容