单选题You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in 

题目
单选题
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）
A

2，1，4，3，5，6

B

1，4，3，2，6，5

C

1，4，2，6，3，5

D

3，2，1，4，5，6

相似考题

1.You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?（）A. 8, 1, 3, 2, 4, 5, 7, 6B. 1, 8, 3, 4, 2, 5, 7, 6C. 1, 3, 4, 2, 8, 5, 6, 7D. 1, 3, 2, 4, 6, 5, 7, 8

2.You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）A、Enable the flash recovery area and specify it as the archived redo log destination.B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C、Enable the flash recovery area but do not specify it as the archived redo log destination.D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode

3. You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）A、 Reregistering the target database in recovery catalogB、 Transporting the new tablespaces to the recovery catalog databaseC、 Syncronizing the recovery catalog with the target database control fileD、 Performing a fresh backup of the target database to include the new data files in the catalog database

4.You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）A、The location can be changed only if the flash recovery area is empty.B、After executing the command， all new flash recovery area files will be created in the new location.C、The command will generate an error because you cannot change the flash recovery area while the database is open.D、All the existing files in the flash recovery area will be moved to the new location， and all new Flash Recovery Area files will be created in the new location.

更多“单选题You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in ”相关问题

  • 第1题：

    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?（）

    • A、using only the RMAN SWITCH command to set the new location for the data file
    • B、placing the database in the MOUNT state for the restore and recovery operations.
    • C、using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
    • D、configuring two channels: one for the restore operation and the other for the recovery operation

    正确答案:C

  • 第2题：

    You decided to change the location of the flash recovery area. You executed the following command：   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；   Which statement is true？（）

    • A、 The location can be changed only if the flash recovery area is empty.
    • B、 After executing the command， all new flash recovery area files will be created in the new location.
    • C、 The command will generate an error because you cannot change the flash recovery area while the database is open.
    • D、 All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.

    正确答案:B

  • 第3题：

    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）

    • A、2，1，4，3，5，6
    • B、1，4，3，2，6，5
    • C、1，4，2，6，3，5
    • D、3，2，1，4，5，6

    正确答案:A

  • 第4题：

    You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

    • A、Reregistering the target database in recovery catalog
    • B、Transporting the new tablespaces to the recovery catalog database
    • C、Syncronizing the recovery catalog with the target database control file
    • D、Performing a fresh backup of the target database to include the new data files in the catalog database

    正确答案:C,D

  • 第5题：

    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）

    • A、2，1，4，3，5，6
    • B、1，4，3，2，6，5
    • C、1，4，2，6，3，5
    • D、3，2，1，4，5，6

    正确答案:A

  • 第6题：

    单选题
    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）
    A

    2，1，4，3，5，6

    B

    1，4，3，2，6，5

    C

    1，4，2，6，3，5

    D

    3，2，1，4，5，6


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

  • 第7题：

    单选题
    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）
    A

     the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view

    B

     the column of the V$INSTANCE_RECOVERY view

    C

     the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view

    D

     the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view


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

  • 第8题：

    单选题
    You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: Which option illustrates the correct sequence that you must use?（）
    A

    8, 1, 3, 2, 4, 5, 7, 6

    B

    1, 8, 3, 4, 2, 5, 7, 6

    C

    1, 3, 4, 2, 8, 5, 6, 7

    D

    1, 3, 2, 4, 6, 5, 7, 8


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

  • 第9题：

    单选题
    You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task：   1） Restore an autobackup of the server parameter file. 2） Restore the control file  3） Start the target database instance  4） Mount the database  5） Restore the data files  6） Open the database with RESETLOGS option  7） Recover the data files  8） Set DBID for the target database   Which option illustrates the correct sequence that you must use？（）
    A

     8， 1， 3， 2， 4， 5， 7， 6

    B

     1， 8， 3， 4， 2， 5， 7， 6

    C

     1， 3， 4， 2， 8， 5， 6， 7

    D

     1， 3， 2， 4， 6， 5， 7， 8


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

  • 第10题：

    单选题
    You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）
    A

    Multiplex all database files.

    B

    Configure the Flash Recovery Area.

    C

    Configure the database instance for ARCHIVELOG mode.

    D

    Configure the FAST_START_MTTR_TARGET initialization parameter


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

  • 第11题：

    单选题
    You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: 1) Restore an autobackup of the server parameter file. 2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database Which option illustrates the correct sequence that you must use?（）
    A

    8，1，3，2，4，5，7，6

    B

    1，8，3，4，2，5，7，6

    C

    1，3，4，2，8，5，6，7

    D

    1，3，2，4，6，5，7，8


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

  • 第12题：

    单选题
    You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）
    A

     ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；

    B

     ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；

    C

     ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；

    D

     ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；


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

  • 第13题：

    You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

    • A、You must have started the database instance in restricted mode.
    • B、You must have started the database instance inNORMALmode.
    • C、You must have started the database instance with server parameter file.
    • D、You must have started the database instance but must not have mounted.
    • E、You must have started the database instance but must not have opened.

    正确答案:C

  • 第14题：

    You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）  

    • A、 ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；
    • B、 ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；
    • C、 ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；
    • D、 ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；

    正确答案:B

  • 第15题：

    You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）

    • A、Multiplex all database files.
    • B、Configure the Flash Recovery Area.
    • C、Configure the database instance for ARCHIVELOG mode.
    • D、Configure the FAST_START_MTTR_TARGET initialization parameter

    正确答案:C

  • 第16题：

    ou are using the flash recovery area （fast recovery area in 11g Release 2） to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is （jetting filled up very fast and it is running out of space.  Your database flash recovery area is low on specie and you have no more room on disk. Proactively， which two options could you use to make more space available in the flash recovery（）

    • A、 Change the RMAN archived log deletion policy.
    • B、 Use the RMAN CROSSCHECK command to reclaim the archived log space.
    • C、 Change the RMAN retention policy to retain backups for a shorter period of time.
    • D、 Use OS command to move files from the flash recovery area to some other location.

    正确答案:B,D

  • 第17题：

    You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task（）

    • A、Multiplex all database files
    • B、Configure the Flash Recovery Area.
    • C、Configure the database instance for ARCHIVELOG mode.
    • D、Configure the FAST_START_MTTR_TARGET initialization parameter.

    正确答案:C

  • 第18题：

    单选题
    You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）
    A

    The location can be changed only if the flash recovery area is empty.

    B

    After executing the command， all new flash recovery area files will be created in the new location.

    C

    The command will generate an error because you cannot change the flash recovery area while the database is open.

    D

    All the existing files in the flash recovery area will be moved to the new location， and all new Flash Recovery Area files will be created in the new location.


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

  • 第19题：

    单选题
    You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task（）
    A

    Multiplex all database files

    B

    Configure the Flash Recovery Area.

    C

    Configure the database instance for ARCHIVELOG mode.

    D

    Configure the FAST_START_MTTR_TARGET initialization parameter.


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

  • 第20题：

    单选题
    You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）
    A

    Enable the flash recovery area and specify it as the archived redo log destination.

    B

    Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

    C

    Enable the flash recovery area but do not specify it as the archived redo log destination.

    D

    Disable the flash recovery area and start the database instance in NOARCHIVELOG mode


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

  • 第21题：

    单选题
    You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）
    A

     Enable the flash recovery area and specify it as the archived redo log destination.

    B

     Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

    C

     Enable the flash recovery area but do not specify it as the archived redo log destination. 

    D

     Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.


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

  • 第22题：

    单选题
    You decided to change the location of the flash recovery area. You executed the following command：   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；   Which statement is true？（）
    A

     The location can be changed only if the flash recovery area is empty.

    B

     After executing the command， all new flash recovery area files will be created in the new location.

    C

     The command will generate an error because you cannot change the flash recovery area while the database is open.

    D

     All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.


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

  • 第23题：

    单选题
    In Recovery Manager （RMAN）， you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged， you want to place the data file in a different location while resto ing the file.  Which option must you consider for this task？（）
    A

     using only the RMAN SWITCH command to set the new location for the data file

    B

     placing the database in the MOUNT state for the restore and recovery operations

    C

     using an RMAN RUN block with the SET NEWNAME and then the SWITCH command

    D

     configuring two channels： one for the restore operation and the other for the recovery operation


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

相关内容