单选题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.

题目
单选题
When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）
A

Until SCN

B

Until time

C

Until cancel

D

Recover using backup control file.

相似考题

1.Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?（）A. Mount the container database (CDB) and restore the control file from the control file auto backup.B. Recover and open the CDB in NORMAL mode.C. Mount the CDB and then recover and open the database, with the RESETLOGS option.D. Open all the pluggable databases.E. Recover each pluggable database.F. Start the database instance in the nomount stage and restore the control file from control file auto backup.

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. You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database. A、a， b， f， gB、c， f， gC、a， d， f， gD、a， f， gE、a， e， g

4.You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）  A、 Restore and recover the datafile.B、 Restore and recover the tablespace.C、 Restore and recover the database.D、 Restore and recover the control file.E、 Restore and recover the parameter file.

更多“单选题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.”相关问题

  • 第1题：

    Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）

    • A、Until last commit
    • B、Until the time you perform recovery
    • C、Until the time the date file got corrupted
    • D、Until the point where the last transaction begun
    • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

    正确答案:A

  • 第2题：

    You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）

    • A、 A user table was lost at the specified time.
    • B、 A redo log file was lost at the specified time.
    • C、 The backup control file is on a faster disk than the current one.
    • D、 The current control file has a different path compared with the intended time of recovery.
    • E、 The current control file does not match the physical structure of the database at the intended time of recovery.

    正确答案:E

  • 第3题：

    Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

    • A、Until last commit
    • B、Until the time you perform recovery
    • C、Until the time the date file got corrupted
    • D、Until the point where the last transaction begun
    • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

    正确答案:A

  • 第4题：

    The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）

    • A、until SCN
    • B、until time
    • C、until cancel
    • D、using backup control file

    正确答案:C

  • 第5题：

    You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）

    • A、restore the tablespace from the backup; there is no need to apply the redo information 
    • B、restore the full database to recover the data up to the point when you performed the backup 
    • C、restore the tablespace from the backup， and then perform a recovery using the backup control file
    • D、restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied

    正确答案:D

  • 第6题：

    In which scenario will you issue the following command？（）      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING        BACKUP CONTROLFILE；

    • A、 when all the control files are missing and only a binary backup of the current control file exists
    • B、 when a multiplexed copy of the current control file is missing
    • C、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
    • D、 when the SPFILE is missing

    正确答案:A

  • 第7题：

    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

    • A、 You will need to open the database with the resetlogs command.
    • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
    • C、 You will use the resetlogs version of the create controlfile command.
    • D、 You will use the noresetlogs version of the create controlfile command.
    • E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

    正确答案:D

  • 第8题：

    单选题
    In which scenario will you issue the following command？（）      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING        BACKUP CONTROLFILE；
    A

     when all the control files are missing and only a binary backup of the current control file exists

    B

     when a multiplexed copy of the current control file is missing

    C

    when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists

    D

     when the SPFILE is missing


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

  • 第9题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）
    A

    restore the tablespace from the backup; there is no need to apply the redo information 

    B

    restore the full database to recover the data up to the point when you performed the backup 

    C

    restore the tablespace from the backup， and then perform a recovery using the backup control file

    D

    restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied


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

  • 第10题：

    单选题
    You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database.
    A

    a， b， f， g

    B

    c， f， g

    C

    a， d， f， g

    D

    a， f， g

    E

    a， e， g


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）
    A

     recover lost blocks

    B

     recover corrupt blocks

    C

     recover media corrupt blocks from list

    D

     recover corrupt blocks from list

    E

     recover corruption list


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

  • 第13题：

    You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

    • A、 V$BACKUP_CORRUPTION
    • B、 V$COPY_CORRUPTION
    • C、 V$DATABASE_BLOCK_CORRUPTION
    • D、 RC_BACKUP_CORRUPTION

    正确答案:C

  • 第14题：

    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

    • A、Restore and recover the datafile. 
    • B、Restore and recover the tablespace. 
    • C、Restore and recover the database. 
    • D、Restore and recover the control file. 
    • E、Restore and recover the parameter file.

    正确答案:A

  • 第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题：

    You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

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

    正确答案:C,D

  • 第17题：

    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）

    • A、 restore the tablespace from the backup； there is no need to apply the redo information
    • B、 restore the full database to recover the data up to the point when you performed the backup
    • C、 restore the tablespace from the backup and then perform a recovery using the backup control file
    • D、 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied

    正确答案:D

  • 第18题：

    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）

    • A、 recover lost blocks
    • B、 recover corrupt blocks
    • C、 recover media corrupt blocks from list
    • D、 recover corrupt blocks from list
    • E、 recover corruption list

    正确答案:E

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）
    A

    Restore and recover the datafile. 

    B

    Restore and recover the tablespace. 

    C

    Restore and recover the database. 

    D

    Restore and recover the control file. 

    E

    Restore and recover the parameter file.


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

  • 第21题：

    单选题
    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）
    A

     Restore and recover the datafile.

    B

     Restore and recover the tablespace.

    C

     Restore and recover the database.

    D

     Restore and recover the control file.

    E

     Restore and recover the parameter file.


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

  • 第22题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup； there is no need to apply the redo information

    B

     restore the full database to recover the data up to the point when you performed the backup

    C

     restore the tablespace from the backup and then perform a recovery using the backup control file

    D

     restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied


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

  • 第23题：

    单选题
    When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）
    A

    Until SCN

    B

    Until time

    C

    Until cancel

    D

    Recover using backup control file.


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

  • 第24题：

    单选题
    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）
    A

     You will need to open the database with the resetlogs command.

    B

     All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

    C

     You will use the resetlogs version of the create controlfile command.

    D

     You will use the noresetlogs version of the create controlfile command.

    E

     You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command


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

相关内容