Archived redo logs can be copied to more than one destination by Oracle.（）A、 TrueB、 False

题目

Archived redo logs can be copied to more than one destination by Oracle.（）

  • A、 True
  • B、 False
相似考题

1.The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?（）A. All archived redo log files backed up at least twice to tape are deleted.B. All archived redo log files backed up at least once to tape are eligible for deletion.C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

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

3.Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs

4.Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)A. Database datafilesB. Control filesC. Online redo logsD. Database pfilesE. Archived redo logs

参考答案和解析
正确答案:A
更多“Archived redo logs&#”相关问题

  • 第1题：

    You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）

    • A、 The archived redo log files will be overwritten.
    • B、 The archived redo log files are deleted automatically.
    • C、 The archived redo log files should be moved to some other location.
    • D、 The archived redo log files are still maintained because the file names are unique.

    正确答案:D

  • 第2题：

    You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

    • A、 multiplexed control files
    • B、 RMAN obsolete backups
    • C、 multiplexed online redo log files
    • D、 archived redo logs that have not been copied to tape

    正确答案:B

  • 第3题：

    What is the purpose of the recover command？（） 

    • A、 Recover database datafiles from physical disk backup sets.
    • B、 Recover required incremental backups from physical disk backup sets.
    • C、 Recover required archived redo logs from physical disk backup sets.
    • D、 Apply incremental backups to recover the database. 
    • E、 Apply archived redo logs to recover the database.

    正确答案:B,C,D,E

  • 第4题：

    While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?（）

    • A、The backup fails because one of the archived redo log files is missing. 
    • B、The backup succeeds but it would be without the missing archived log. 
    • C、During backup, you are prompted for the alternative destination for the missing archived redo log file. 
    • D、The backup succeeds because it fails over to one of the alternative archived redo log destinations. 

    正确答案:D

  • 第5题：

    Which of the following does the recover command not do？（）  

    • A、 Restore archived redo logs.
    • B、 Apply archived redo logs.
    • C、 Restore incremental backups.
    • D、 Apply incremental backups.
    • E、 Restore datafile images.

    正确答案:A

  • 第6题：

    单选题
    You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）
    A

     The archived redo log files will be overwritten.

    B

     The archived redo log files are deleted automatically.

    C

     The archived redo log files should be moved to some other location.

    D

     The archived redo log files are still maintained because the file names are unique.


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

  • 第7题：

    单选题
    Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）
    A

    only the control file, the current SPFILE, and data files

    B

    only the current SPFILE and data files if autobackup is disabled

    C

    only the data files and the archived redo logs

    D

    the control file, current SPFILE file, data files, and archived redo logs


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

  • 第8题：

    单选题
    Archived redo logs can be copied to more than one destination by Oracle.（）
    A

     True

    B

     False


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

  • 第9题：

    单选题
    You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）
    A

     The online redo log file Is not allowed to be overwritten.

    B

     The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.

    C

     The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.

    D

     The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.


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

  • 第10题：

    单选题
    You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）
    A

     multiplexed control files

    B

     RMAN obsolete backups

    C

     multiplexed online redo log files

    D

     archived redo logs that have not been copied to tape


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

  • 第11题：

    单选题
    While performing the backup of the flash recovery area， you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files.  What implications does it have on the backup of the flash recovery area？（）
    A

     The backup fails because one of the archived redo log files is missing.

    B

     The backup succeeds but it would be without the missing archived log.

    C

     During backup，you are prompted for the alternative destination for the missing archived redo log file.

    D

     The backup succeeds because it fails over to one of the alternative archived redo log destinations.


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

  • 第12题：

    单选题
    What will be the result of the following configuration？（）   Log_archive_dest_1=location=c：/oracle/arch/mydb Log_archive_dest_2=location=z：/oracle/arch/mydb
    A

     An error will occur during database startup because the second parameter is not valid.

    B

     An error will occur during database startup since you are trying to create archived redo logs in two different locations.

    C

     Archived redo logs will be created in two different locations by the ARCH process.

    D

     Archived redo logs will be created in two different locations by the LGWR process.

    E

     Neither parameter setting is valid， so the database will not start up.


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

  • 第13题：

    Which type of database file is spread across all disks in a disk group？（）

    • A、 All types of files are spread across all disks in the disk group.
    • B、 Datafiles
    • C、 Redo log files
    • D、 Archived redo log files
    • E、 Control files

    正确答案:A

  • 第14题：

    Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

    • A、only the control file, the current SPFILE, and data files
    • B、only the current SPFILE and data files if autobackup is disabled
    • C、only the data files and the archived redo logs
    • D、the control file, current SPFILE file, data files, and archived redo logs

    正确答案:D

  • 第15题：

    Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）  

    • A、 backup database
    • B、 backup database and archivelogs
    • C、 backup database plus archivelogs
    • D、 backup database plus archivelog delete input
    • E、 backup database and archivelog delete input

    正确答案:D

  • 第16题：

    Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）

    • A、Database datafiles
    • B、Control files
    • C、Online redo logs
    • D、Database pfiles
    • E、Archived redo logs

    正确答案:C,D

  • 第17题：

    单选题
    The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below：   LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’   Examine the following RMAN command issued to set the deletion policy for archived log files：   RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt； Which statement is true regarding what this command accomplishes？（）
    A

     All archived redo log files backed up at least twice to tape are deleted.

    B

     All archived redo log files backed up at least once to tape are eligible for deletion.

    C

     All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

    D

     All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.


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

  • 第18题：

    单选题
    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）
    A

     The archived redo logs are stored in an operating system-dependent location.

    B

     The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.

    C

     The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.

    D

     The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.


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

  • 第19题：

    单选题
    Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）
    A

     backup database

    B

     backup database and archivelogs

    C

     backup database plus archivelogs

    D

     backup database plus archivelog delete input

    E

     backup database and archivelog delete input


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

  • 第20题：

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


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

  • 第21题：

    单选题
    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）
    A

     13：00 on Tuesday.

    B

     15：00 on Tuesday.

    C

     Up until the last available archived redo log on Sunday.

    D

     To any point； all the redo should still be available in the online redo logs.

    E

     The database is not recoverable.


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

  • 第22题：

    单选题
    Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified？（）
    A

     only the control file， the current SPFILE， and data files

    B

     only the current SPFILE and data files if autobackup is disabled

    C

     only the data files and the archived redo logs

    D

     the control file，current SPFILE file，data files，and archived redo logs


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

  • 第23题：

    单选题
    Which of the following does the recover command not do？（）
    A

     Restore archived redo logs.

    B

     Apply archived redo logs.

    C

     Restore incremental backups.

    D

     Apply incremental backups.

    E

     Restore datafile images.


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

相关内容