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

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

相似考题

1.You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）A. Restore the backup control file and open the database with RESETLOGS option.B. Perform point-in-time recovery because flashback cannot be performed again on this tableC. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

2. You executed the following command to perform a backup of the USERS tablespace：  SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1：  ORA-01123： cannot start online backup； media recovery not enabled  What could be the reason for this error（）A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.

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

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

参考答案和解析
正确答案： C
解析： 暂无解析
更多“You execute the following command to perform a backup by usi”相关问题

  • 第1题：

    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.

    正确答案:B,C,E

  • 第2题：

    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

    • A、 The database must have multiplexed redo log files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第3题：

    You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

    • A、 OPEN
    • B、 MOUNT
    • C、 NORMAL
    • D、 NOMOUNT

    正确答案:B

  • 第4题：

    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

  • 第5题：

    You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）

    • A、 SYSDATE should not be used with TIMESTAMP.
    • B、 The database must have multiplexed redo log files.
    • C、 The database must be in the MOUNT state to execute the command.
    • D、 The database must be opened with the RESETLOGS option after the flashback operation.
    • E、 The entire database needs to be restored from the most recent backup before the flashback operation.

    正确答案:C,D

  • 第6题：

    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

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

    多选题
    You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）
    A

    SYSDATE should not be used with TIMESTAMP.

    B

    The database must have multiplexed redo log files.

    C

    The database must be in the MOUNT state to execute the command.

    D

    The database must be opened with the RESETLOGS option after the flashback operation.

    E

    The entire database needs to be restored from the most recent backup before the flashback operation.


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

  • 第9题：

    单选题
    Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）
    A

    Data files that belong to only the root container

    B

    Data files that belong to the root container and all the pluggable databases (PDBs)

    C

    Data files that belong to only the root container and PDB$SEED

    D

    Data files that belong to the root container and all the PDBs excluding PDB$SEED


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

  • 第10题：

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

  • 第11题：

    单选题
    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）
    A

     You should perform a log switch

    B

     You should make a backup of the database

    C

     You should switch the database to the NONARCHIVELOG mode

    D

     You should shut down the database instance and perform a complete database recovery


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

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

    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

  • 第14题：

    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

  • 第15题：

    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

    • A、You should perform a log switch
    • B、You should make a backup of the database
    • C、You should switch the database to the NONARCHIVELOG mode
    • D、You should shut down the database instance and perform a complete database recovery

    正确答案:B

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

    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

  • 第18题：

    多选题
    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,D
    解析： 暂无解析

  • 第19题：

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


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

  • 第20题：

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

  • 第21题：

    单选题
    You have a domain controller that runs Windows Server 2008 R2. The Windows Server Backup  feature is installed on the domain controller.   You need to perform a non-authoritative restore of the domain controller by using an existing  backup file.     What should you do（）
    A

    Restart the domain controller in Directory Services Restore Mode. Use the WBADMIN command to perform a critica

    B

    Restart the domain controller in Directory Services Restore Mode. Use the Windows Server Backup snap-in to perf

    C

    Restart the domain controller in safe mode. Use the Windows Server Backup snap-in to perform a critical volume re

    D

    Restart the domain controller in safe mode. Use the WBADMIN command to perform a critical volume restore.


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

  • 第22题：

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

  • 第23题：

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


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

相关内容