多选题You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）ABy using the trace file.BBy using the alert log file.CBy using the datab

题目
多选题
You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）
A

By using the trace file.

B

By using the alert log file.

C

By using the database ID

D

By using the server parameter file.

E

By using the V$CONTROLFILE view.

F

By using the autobackup format configuration setting.

相似考题

1. In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）A、a tablespace is taken offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database

2.You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？ （）A、 the alert log fileB、 the server parameter fileC、 the formatted name of a control file autobackupD、 an RMAN session log fileE、 the trace file

3. You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） A、back up the control file to traceB、bring database to the MOUNT stateC、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

4. 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 fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

更多“多选题You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）ABy using the trace file.BBy using the alert log file.CBy using the datab”相关问题

  • 第1题：

    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）.  In which two sources would you find the DBID？ （）

    • A、the trace file
    • B、the alert log file
    • C、an RMAN session log file
    • D、the server parameter file
    • E、the formatted name of a control file autobackup

    正确答案:C,E

  • 第2题：

    It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）

    • A、cannot be used in RMAN
    • B、by starting up the database again
    • C、by using the CATALOG command of RMAN
    • D、by using the RECOVER CATALOG command in RMAN
    • E、by re-creating the target control file to rebuild the RMAN repository

    正确答案:C

  • 第3题：

    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）

    • A、 By using the trace file.
    • B、 By using the alert log file.
    • C、 By using the database ID
    • D、 By using the server parameter file.
    • E、 By using the V$CONTROLFILE view.
    • F、 By using the autobackup format configuration setting.

    正确答案:C,F

  • 第4题：

    In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？ （）

    • A、 A tablespace is taken offline.
    • B、 The database instance is restarted.
    • C、 A new data file is added to an existing tablespace.
    • D、 A successful backup is recorded in the RMAN repository.
    • E、 The RMAN connection is disconnected from the target database.

    正确答案:C,D

  • 第5题：

    You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）

    • A、 rman TARGET / NOCATALOG
    • B、 rman TARGET sys/password
    • C、 rman TARGET sys/password AS SYSDBA
    • D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

    正确答案:B

  • 第6题：

    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup？（）

    • A、by using the trace file
    • B、by using the alert log file
    • C、by using the database ID
    • D、by using the server parameter file
    • E、by using the V$CONTROLFILE view
    • F、by using the autobackup format configuration setting

    正确答案:C,F

  • 第7题：

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

  • 第8题：

    多选题
    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）.  In which two sources would you find the DBID？ （）
    A

    the trace file

    B

    the alert log file

    C

    an RMAN session log file

    D

    the server parameter file

    E

    the formatted name of a control file autobackup


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

  • 第9题：

    单选题
    You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）
    A

     rman TARGET / NOCATALOG

    B

     rman TARGET sys/password

    C

     rman TARGET sys/password AS SYSDBA

    D

     rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat


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

  • 第10题：

    多选题
    In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？ （）
    A

    A tablespace is taken offline.

    B

    The database instance is restarted.

    C

    A new data file is added to an existing tablespace.

    D

    A successful backup is recorded in the RMAN repository.

    E

    The RMAN connection is disconnected from the target database.


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

  • 第11题：

    多选题
    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？ （）
    A

    the alert log file

    B

    the server parameter file

    C

    the formatted name of a control file autobackup

    D

    an RMAN session log file

    E

    the trace file


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

  • 第12题：

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


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

  • 第13题：

    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

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

    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

    • A、shut down and restart the instance
    • B、add new tempfiles to the temporary tablespaces after recovery
    • C、perform a media recovery and open the database with the RESETLOGS option
    • D、perform a media recovery and bring the database to NOARCHIVELOG mode

    正确答案:B,C

  • 第16题：

    You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

    • A、 Start the database in the MOUNT stage.
    • B、 Back up the control file to trace.
    • C、 Set the DBID
    • D、 Issue the RECOVER DATABASE command.

    正确答案:C

  • 第17题：

    You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message：   SQL> startup ORA-01078： failure in processing system parameters LRM-00109：  could not open parameter file ，  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN，   how would you respond to this error？（）  

    • A、 Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
    • B、 Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
    • C、 Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
    • D、 Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
    • E、 Issue the restore spfile from autobackup command from the RMAN prompt.

    正确答案:C

  • 第18题：

    多选题
    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command：  RMAN> RESTORE CONTROLFILE；  Which two operations do you need to perform after restoring the control file from backup？（）
    A

    shut down and restart the instance

    B

    add new tempfiles to the temporary tablespaces after recovery

    C

    perform a media recovery and open the database with the RESETLOGS option

    D

    perform a media recovery and bring the database to NOARCHIVELOG mode


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

  • 第19题：

    单选题
    It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）
    A

    cannot be used in RMAN

    B

    by starting up the database again

    C

    by using the CATALOG command of RMAN

    D

    by using the RECOVER CATALOG command in RMAN

    E

    by re-creating the target control file to rebuild the RMAN repository


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

  • 第20题：

    多选题
    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）
    A

    By using the trace file.

    B

    By using the alert log file.

    C

    By using the database ID

    D

    By using the server parameter file.

    E

    By using the V$CONTROLFILE view.

    F

    By using the autobackup format configuration setting.


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

  • 第21题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第22题：

    多选题
    In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）
    A

    a tablespace is taken offline

    B

    the database instance is restarted

    C

    a new data file is added to an existing tablespace

    D

    a successful backup is recorded in the RMAN repository

    E

    the RMAN connection is disconnected from the target database


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

  • 第23题：

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

  • 第24题：

    多选题
    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup？（）
    A

    by using the trace file

    B

    by using the alert log file

    C

    by using the database ID

    D

    by using the server parameter file

    E

    by using the V$CONTROLFILE view

    F

    by using the autobackup format configuration setting


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

相关内容