niusouti.com

单选题What RMAN command is used to execute a tablespace point-in-time recovery？（）ArecoverBduplicateCrestoreDcopyENone of the above

题目
单选题
What RMAN command is used to execute a tablespace point-in-time recovery？（）
A

 recover

B

 duplicate

C

 restore

D

 copy

E

 None of the above

相似考题

1.View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()A. 4B. 8C. 7D. 0

2. You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

3. Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement：   SQL>ALTER TABLSPACE temp OFFLINE NORMAL；   What is the result of this statement？（）A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.

4.Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN > BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command?（）A. Place the root container in ARHCHIVELOG mode.B. Take the user data tablespace offline.C. Place the root container in the nomount stage.D. Ensure that HR_PDB is open.

更多“What RMAN command is used to execute a tablespace point-in-t”相关问题

  • 第1题：

    You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)

    • A、The backup piece size will be limited to 300 MB
    • B、The RMAN uses multiplexing to perform backup
    • C、The operation is accomplished using the default channel available
    • D、The RMAN parallelizes the backup although the parallelism is not set for a channel

    正确答案:A,C

  • 第2题：

    What RMAN command is used to execute a tablespace point-in-time recovery？（）

    • A、 recover
    • B、 duplicate
    • C、 restore
    • D、 copy
    • E、 None of the above

    正确答案:A

  • 第3题：

    Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）

    • A、 It is used to change failure priority only for HIGH or LOW priorities.
    • B、 It is used to execute the advised repair script.
    • C、 It is used to change failure priority only for the CRITICAL priority.
    • D、 It is used to explicitly close the open failures.
    • E、 It is used to inform the database about the repair after the repair script executes.

    正确答案:A,D

  • 第4题：

    You configured the default backup device type as disk for RMAN backups. In your database，because of business requirements，you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this？（）  

    • A、 MAXSETSIZE TO 2
    • B、 DEVICE TYPE DISK PARALLELISM 2
    • C、 RETENTION POLICY TO REDUNDANCY 2
    • D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

    正确答案:C

  • 第5题：

    You execute the following command to perform a backup by using Recovery Manager （RMAN）： RMAN> run  {allocate channel c1 type sbt;  backup datafile 1;  }  The command errors out. A part of the error message is as follows：  RMAN/x7f03009： failure of allocate command on c1 channel  ORA/x7f19554： error allocating device， device type： SBT_TAPE， device name：  What could explain why the statement failed？（）

    • A、sbt is not a valid device type.
    • B、Media Management Library was not loaded.
    • C、The sbt device cannot be used for data file backups.
    • D、No path was defined in the ALLOCATE CHANNEL command.
    • E、The channel is currently being used by another RMAN session.

    正确答案:B

  • 第6题：

    Which statement about using RMAN stored scripts is true?（）

    • A、To create and execute an RMAN stored script, you must use a recovery catalog.
    • B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
    • C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
    • D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

    正确答案:A

  • 第7题：

    单选题
    View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation：   RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； }   What is the multiplexing level in the preceding backup process？（）
    A

     4

    B

     8

    C

     7

    D

     0


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

  • 第8题：

    单选题
    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
    A

    the DBNEWID utility

    B

    the ANALYZE command

    C

    the RMAN LIST command

    D

    the RMAN REPORT command

    E

    the RMAN CROSSCHECK command

    F

    the RMAN BLOCKRECOVER command


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

  • 第9题：

    多选题
    You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）
    A

    The database is in NOMOUNT state.

    B

    The database is in ARCHIVELOG mode and the tablespace is online.

    C

    The database is in ARCHIVELOG mode and the tablespace is offline.

    D

    The database is in NOARCHIVELOG mode and the tablespace is online.

    E

    The database is in NOARCHIVELOG mode and the tablespace is offline.


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

  • 第10题：

    多选题
    Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）
    A

    It is used to change failure priority only for HIGH or LOW priorities.

    B

    It is used to execute the advised repair script.

    C

    It is used to change failure priority only for the CRITICAL priority.

    D

    It is used to explicitly close the open failures.

    E

    It is used to inform the database about the repair after the repair script executes.


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

  • 第11题：

    单选题
    You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace， you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting？（）
    A

     configure a default device for RMAN backups

    B

     temporarily disable the retention policy for RMAN backups

    C

     configure automatic channel allocation for RMAN backups

    D

     use the CONFIGURE command to reconfigure the recovery window to 60 days


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

  • 第12题：

    单选题
    You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）
    A

     The command generates an error.

    B

     The command backs up the tablespace and creates a backup set of size 200 MB

    C

     The command backs up the tablespace and creates two backup sets of size 100 MB each.

    D

     The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.


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

  • 第13题：

    Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?（）

    • A、The RMAN backup fails because the TOOLS tablespace is read-only
    • B、The RMAN skips the backup of the tablespace because backup optimization is enabled
    • C、The RMAN makes backup because optimization can be enabled only for backups to disk
    • D、The RMAN makes the backup because no backup of the tablespace exists within the seven day window

    正确答案:D

  • 第14题：

    Which command is used to begin a tablespace point-in-time recovery？（）  

    • A、 Restore tablespace
    • B、 Recover tablespace
    • C、 Tablespace recover
    • D、 Recover to time
    • E、 recover datafile

    正确答案:B

  • 第15题：

    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（） 

    • A、the DBNEWID utility
    • B、the ANALYZE command
    • C、the RMAN LIST command
    • D、the RMAN REPORT command
    • E、the RMAN CROSSCHECK command
    • F、the RMAN BLOCKRECOVER command

    正确答案:B

  • 第16题：

    View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation：   RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； }   What is the multiplexing level in the preceding backup process？（）

    • A、 4
    • B、 8
    • C、 7
    • D、 0

    正确答案:A

  • 第17题：

    You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）

    • A、The tablespace would require recovery to go back online.
    • B、A checkpoint is taken on all data files that are associated with the SALES tablespace.
    • C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error
    • D、The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

    正确答案:B,C

  • 第18题：

    单选题
    Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?（）
    A

    The RMAN backup fails because the TOOLS tablespace is read-only

    B

    The RMAN skips the backup of the tablespace because backup optimization is enabled

    C

    The RMAN makes backup because optimization can be enabled only for backups to disk

    D

    The RMAN makes the backup because no backup of the tablespace exists within the seven day window


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

  • 第19题：

    单选题
    Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）
    A

    Place the root container in ARHCHIVELOG mode.

    B

    Take the user data tablespace offline.

    C

    Place the root container in the nomount stage.

    D

    Ensure that HR_PDB is open.


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

  • 第20题：

    多选题
    You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）
    A

    The tablespace would require recovery to go back online.

    B

    A checkpoint is taken on all data files that are associated with the SALES tablespace.

    C

    The sessions that subsequently try to access the objects in the SALES tablespace receive an error

    D

    The new status of the SALES tablespace is recorded in the control file when the database instance isclosed


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

  • 第21题：

    单选题
    When running the tablespace point-in-time command   recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error:  RMAN-00571: ===========================================================  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS  =============== RMAN-00571:  ===========================================================  RMAN-03002: failure of recover command at 10/08/2008 16:00:30  RMAN-20202: Tablespace not found in the recovery catalog  RMAN-06019: could not translate tablespace name "USERS"   What is the likely cause of the error?（）
    A

     The database is in ARCHIVELOG mode.

    B

     There is not a current backup of the database available.

    C

     The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.

    D

     The USERS tablespace is not eligible for TSPITR because it has invalid objects.

    E

     The recover tablespace command is incorrect and generates the error.


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

  • 第22题：

    单选题
    You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly.  On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3.  Because there are no changes made to the TOOLS tablespace， you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting？（）
    A

    configure a default device for RMAN backups

    B

    temporarily disable the retention policy for RMAN backups

    C

    configure automatic channel allocation for RMAN backups

    D

    use the CONFIGURE command to reconfigure the recovery window to 60 days


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

  • 第23题：

    单选题
    The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command：        SQL> EXECUTE   DBMS_SERVER_ALERT.SET_THRESHOLD        （dbms_server_alert.tablespace_pct_full，        dbms_server_alert.operator_ge，80，        dbms_server_alert.operator_ge，90，        1，1，NULL，   dbms_server_alert.object_type_tablespace，’DATA’）；   What will be the result of the command？（）
    A

     The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.

    B

     The total numbers of alerts that you receive every day will be reduced.

    C

     The total number of alerts that you receive every day will be increased.

    D

     No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.


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

  • 第24题：

    单选题
    What RMAN command is used to execute a tablespace point-in-time recovery？（）
    A

     recover

    B

     duplicate

    C

     restore

    D

     copy

    E

     None of the above


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

相关内容