单选题You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is

题目
单选题
You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?（）
A

The backup is deleted.

B

The backup is marked unavailable.

C

The backup overrides the backup retention policy.

D

the backup becomes eligible for deletion according to the existing retention policy

相似考题

1.Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

2. You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS；  When a backup is performed， what would be the status of this backup after seven days？（）A、 The backup would be marked as invalid.B、 The backup would be marked as obsolete.C、 The backup would be removed from the media.D、 The backup would be removed from the RMAN repository.

3.You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）A、A different procedure is required to restore a database from compressed backups B、The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. C、Using this command to create backups minimizes the bandwidth consumed.D、Using this command to create backups improves the performance of the backup process 

4. You performed an incremental level 0 backup of a database: RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?（）A、Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.B、The change tracking file must always be backed up when you perform a full database backup.C、Block change tracking will always reduce I/O performed during cumulative incremental backups.D、More than one database block may be read by an incremental backup for a change made to a single block.E、The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

更多“单选题You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMANCHANGE BACKUPSET 231 NOKEEP; What is ”相关问题

  • 第1题：

    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

    • A、 when you change the name of a datafile
    • B、 when you drop a table from the database
    • C、 when you take an export of the database
    • D、 when you back up the database using OS utilities
    • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
    • F、 when you issue a BACKUP command from inside the RMAN run block

    正确答案:A,E,F

  • 第2题：

    You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）

    • A、 The backup will not be performed at all.
    • B、 three times
    • C、 four times
    • D、 six times

    正确答案:C

  • 第3题：

    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

    • A、Datafiles
    • B、 Current control file
    • C、 Server parameter file （spfile）
    • D、 Password file

    正确答案:D

  • 第4题：

    You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：  RMAN> REPORT NEED BACKUP days 3;  What would be the output of this command？（） 

    • A、a list of files that require a backup within three days
    • B、a list of files that have not been backed up for three days
    • C、a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
    • D、a list of files for which a backup has already been performed and may need a backup after three days

    正确答案:B

  • 第5题：

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

    • A、The backup status will be marked expired in RMAN recovery catalog.
    • B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
    • C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
    • D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
    • E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

    正确答案:C

  • 第6题：

    You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）

    • A、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；
    • B、 CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；
    • C、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；
    • D、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；

    正确答案:C

  • 第7题：

    单选题
    You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：  RMAN> REPORT NEED BACKUP days 3;  What would be the output of this command？（）
    A

    a list of files that require a backup within three days

    B

    a list of files that have not been backed up for three days

    C

    a list of files that RMAN recommends be backed up only once in every three days， based on low volatility

    D

    a list of files for which a backup has already been performed and may need a backup after three days


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

  • 第8题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


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

  • 第9题：

    多选题
    You performed an incremental level 0 backup of a database: RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?（）
    A

    Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

    B

    The change tracking file must always be backed up when you perform a full database backup.

    C

    Block change tracking will always reduce I/O performed during cumulative incremental backups.

    D

    More than one database block may be read by an incremental backup for a change made to a single block.

    E

    The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.


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

  • 第10题：

    单选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
    A

    The backup status will be marked expired in RMAN recovery catalog.

    B

    The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.

    C

    The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl

    D

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.

    E

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.


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

  • 第11题：

    单选题
    You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）
    A

     When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.

    B

     When a structural change is made to the database， then a backup of the current control file is performed.

    C

     When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.

    D

     When a structural change is made to the database， then a backup of the alert log file will be performed.


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

  • 第12题：

    单选题
    You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS；  When a backup is performed， what would be the status of this backup after seven days？（）
    A

     The backup would be marked as invalid.

    B

     The backup would be marked as obsolete.

    C

     The backup would be removed from the media.

    D

     The backup would be removed from the RMAN repository.


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

  • 第13题：

    Examine the following command used to perform incremental level 0 backup：   RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；   To enable the block change tracking， after the incremental level 0 backup you issued the following command：   SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：   RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which two statements are true in the above situation？（）

    • A、 The block change tracking data will be used only from the next incremental 0 backup.
    • B、 The incremental backup will use change tracking data for accomplishing the backup.
    • C、 The incremental backup will not use change tracking data for accomplishing the backup.
    • D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

    正确答案:A,C

  • 第14题：

    You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

    • A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
    • B、 When a structural change is made to the database， then a backup of the current control file is performed.
    • C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
    • D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

    正确答案:D

  • 第15题：

    You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately， you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again？（）  

    • A、 register database
    • B、 recover catalog
    • C、 load backupset
    • D、 synch metadata
    • E、 catalog start with

    正确答案:E

  • 第16题：

    You perform a backup using the following BACKUP command：   RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE；   Which statement is true of this command？（）  

    • A、 A different procedure is required to restore a database from compressed backups
    • B、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.
    • C、 Using this command to create backups minimizes the bandwidth consumed
    • D、 Using this command to create backups improves the performance of the backup process

    正确答案:C

  • 第17题：

    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

    • A、 backup database all
    • B、 backup compressed database
    • C、 backup as compressed backupset database
    • D、 backup as compressed backup database plus archivelog all
    • E、 backup as compressed backupset database plus compress archivelog all

    正确答案:C

  • 第18题：

    You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.  After some days， you want to change the status of the database backup and you issued the following command：   RMAN>CHANGE BACKUPSET 231 NOKEEP；   What is the implication of this command？（）

    • A、 The backup is deleted.
    • B、 The backup is marked unavailable.
    • C、 The backup overrides the backup retention policy.
    • D、 the backup becomes eligible for deletion according to the existing retention policy.

    正确答案:D

  • 第19题：

    单选题
    You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）
    A

     CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；

    B

     CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；

    C

     CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；

    D

     CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；


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

  • 第20题：

    单选题
    You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）
    A

     The backup will not be performed at all.

    B

     three times

    C

     four times

    D

     six times


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

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）
    A

    Datafiles

    B

     Current control file

    C

     Server parameter file （spfile）

    D

     Password file


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

  • 第22题：

    单选题
    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）
    A

     backup database all

    B

     backup compressed database

    C

     backup as compressed backupset database

    D

     backup as compressed backup database plus archivelog all

    E

     backup as compressed backupset database plus compress archivelog all


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

  • 第23题：

    单选题
    You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?（）
    A

    A different procedure is required to restore a database from compressed backups

    B

    The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.

    C

    Using this command to create backups minimizes the bandwidth consumed

    D

    Using this command to create backups improves the performance of the backup process


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

相关内容