单选题You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）A create a backup of the database and recover all corrupted blocks found in the backupB run a bac

题目
单选题
You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）
A

create a backup of the database and recover all corrupted blocks found in the backup

B

run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database

C

run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view

D

run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view

E

run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

相似考题

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 are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.

3.Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema?（）A. Only 1B. Only 2C. Only 3D. 3 and 1E. 1 and 2

4.Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?（）A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

更多“You execute the following RMAN commands in the order shown b”相关问题

  • 第1题：

    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


    参考答案：B

  • 第2题：

    RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

    • A、’SQL ALTER DATABASE OPEN’；
    • B、SQL ALTER DATABASE ’OPEN’；
    • C、OPEN DATABASE；
    • D、DATABASE OPEN

    正确答案:C

  • 第3题：

    You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  

    • A、 run { open script backup_database； run script backup_database }
    • B、 run { engage script backup_database； }
    • C、 run { run script backup_database； }
    • D、 Run { execute script backup_database； }
    • E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

    正确答案:D

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

    In order to change the system runlevel and execute /etc/inittab entries based on the new runlevel, which of the following commands should be performed?（）

    • A、telinit
    • B、runinit
    • C、sysinit
    • D、startinit

    正确答案:A

  • 第6题：

    单选题
    You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）
    A

    SYSDBA

    B

    SYSOPER

    C

    No system privileges are required for the RMAN user.

    D

    Only SYS user can connect and execute RMAN commands on a target database.


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

  • 第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 execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）
    A

     Create a backup of the database and recover all corrupted blocks found in the backup.

    B

     Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.

    C

     Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.

    D

     Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.

    E

     Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.


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

  • 第9题：

    单选题
    Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）
    A

     The USERS.DBF datafile is corrupted and cannot be restored by RMAN.

    B

     The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.

    C

     The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.

    D

     The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.


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

  • 第10题：

    单选题
    You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）
    A

     run { open script backup_database； run script backup_database }

    B

     run { engage script backup_database； }

    C

     run { run script backup_database； }

    D

     Run { execute script backup_database； }

    E

     The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.


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

  • 第11题：

    单选题
    You run the following commands：   RMAN> list expired backup； RMAN> delete expired backup；   What will happen to the backup set pieces associated with the backups that appear in the list expired backup command？（）
    A

     They will be renamed.

    B

     Nothing will happen to them. The backup set pieces do not exist.

    C

     They will be deleted immediately since they are not in the flash recovery area.

    D

     You will need to manually remove the physical files listed in the output of the commands.

    E

     They will become hidden files and removed 10 days later.


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

  • 第12题：

    单选题
    RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
    A

    ’SQL ALTER DATABASE OPEN’；

    B

    SQL ALTER DATABASE ’OPEN’；

    C

    OPEN DATABASE；

    D

    DATABASE OPEN


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

  • 第13题：

    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

  • 第14题：

    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

    • A、 control file
    • B、 all datafiles
    • C、 password file
    • D、 online redo log file
    • E、 archive redo log file
    • F、 server parameter file
    • G、 only the SYSTEM datafile

    正确答案:A,B,F

  • 第15题：

    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

  • 第16题：

    You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following RMAN commands: RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat10/oracle@inst1; What happens when you execute the above commands?（）

    • A、They deregister all databases registered in the RCAT10 catalog.
    • B、They import metadata for all registered databases in the RCAT10 database.
    • C、They register all the RCAT10-catalog registered databases in the RCO11 catalog.
    • D、They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog.

    正确答案:A,B,C

  • 第17题：

    多选题
    You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following RMAN commands: RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat10/oracle@inst1; What happens when you execute the above commands?（）
    A

    They deregister all databases registered in the RCAT10 catalog.

    B

    They import metadata for all registered databases in the RCAT10 database.

    C

    They register all the RCAT10-catalog registered databases in the RCO11 catalog.

    D

    They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog.


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

  • 第18题：

    单选题
    Which one of the following RMAN commands is used to register the database files with repository that were backed up using O/S commands？（）
    A

    CHANGE

    B

    CATALOG

    C

    CROSSCHECK

    D

    SWITCH


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

  • 第19题：

    单选题
    Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）
    A

    Only 1

    B

    Only 2

    C

    Only 3

    D

    3 and 1

    E

    1 and 2


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

  • 第20题：

    多选题
    You execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）
    A

    Repair the corrupted blocks. If any. In the backup created

    B

    Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks

    C

    Back up the database after checking whether array of the files have corrupted blocks

    D

    Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view

    E

    Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION


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

  • 第21题：

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

  • 第22题：

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

  • 第23题：

    多选题
    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）
    A

    control file

    B

    all datafiles

    C

    password file

    D

    online redo log file

    E

    archive redo log file

    F

    server parameter file

    G

    only the SYSTEM datafile


    正确答案： G,F
    解析： 暂无解析

相关内容