网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance 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 datafile by using the image copy. You could perform the following steps to accomplish this:   1) Mount the database  2) Take the data file offline  3) Bring the data file online  4) Use the RMAN SWITCH TO command to switch the image copy  5) Apply the archived redo logs  6) Open the database  7) Use the RMAN RESTORE TO command to switch to the image copy   Which two options illustrate the correct sequence of steps that you could follow?()
A

2, 6, 4, 5, 3

B

1, 2, 4, 5, 3, 6

C

1, 2, 4, 6, 3

D

1, 2, 7, 5, 3, 6


参考答案

参考解析
解析: 暂无解析
更多 “多选题In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance 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 datafile by using the image copy. You could perform the following steps to accomplish this:   1) Mount the database  2) Take the data file offline  3) Bring the data file online  4) Use the RMAN SWITCH TO command to switch the image copy  5) Apply the archived redo logs  6) Open the database  7) Use the RMAN RESTORE TO command to switch to the image copy   Which two options illustrate the correct sequence of steps that you could follow?()A2, 6, 4, 5, 3B1, 2, 4, 5, 3, 6C1, 2, 4, 6, 3D1, 2, 7, 5, 3, 6” 相关考题
考题 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

考题 You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?()A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option

考题 In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance 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 datafile by using the image copy. You could perform the following steps to accomplish this:1) Mount the database2) Take the data file offline3) Bring the data file online4) Use the RMAN SWITCH TO command to switch the image copy5) Apply the archived redo logs6) Open the database7) Use the RMAN RESTORE TO command to switch to the image copyWhich two options illustrate the correct sequence of steps that you could follow?() (Choose two.)A. 2, 6, 4, 5, 3B. 1, 2, 4, 5, 3, 6C. 1, 2, 4, 6, 3D. 1, 2, 7, 5, 3, 6

考题 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 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

考题 Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?()A、2, 4, 3B、1, 4, 3, 2C、2, 5, 4, 3, 6D、5, 2, 4, 3, 6E、1, 5, 4, 3, 6, 2

考题 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

考题 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 fileB、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

考题 n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、 Oracle Migration AssistantB、 Recovery Manager (RMAN)C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance

考题 You 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 space 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 policyB、Use the RMAN CROSSCHECK command to reclaim the archived log spaceC、Change the RMAN retention policy to retain backups for a shorter period of timeD、Use OS command to move files from the flash recovery area to some other location

考题 Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.   The steps to recover the damaged data files are follows:   1. Mount the database  2. Open the database  3. Recover the data file  4. Restore the data file  5. Make the data file offline  6. Make the data file online   Which option identifies the correct sequence that you must use to recover the data files?()A、 2,4,3B、 1,4,3,2C、 2,5,4,3,6D、 5,2,4,3,6E、 1,5,4,3,6,2

考题 In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、Oracle Migration AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

考题 While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()A、configure the database to run in ARCHIVELOG modeB、configure the Flash Recovery Area to enable automatic database backupC、schedule the database backup using DBMS_JOB package after creating the databaseD、schedule the database backup using Recovery Manager (RMAN)commands after creating the databaseE、schedule the database backup using Database Configuration Assistant (DBCA)while creating the database

考题 You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?()A、Mount the databaseB、Open the database in NORMAL modeC、Open the database in RESTRICTED modeD、Open the database with the RESETLOGS option

考题 You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?()A、Open the database in NORMAL modeB、Open the database in read-only modeC、Open the database in RESTRICTED modeD、Open the database with the RESETLOGS option

考题 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 instanceB、add new tempfiles to the temporary tablespaces after recoveryC、perform a media recovery and open the database with the RESETLOGS optionD、perform a media recovery and bring the database to NOARCHIVELOG mode

考题 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 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

考题 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.

考题 In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance 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 datafile by using the image copy. You could perform the following steps to accomplish this:   1) Mount the database  2) Take the data file offline  3) Bring the data file online  4) Use the RMAN SWITCH TO command to switch the image copy  5) Apply the archived redo logs  6) Open the database  7) Use the RMAN RESTORE TO command to switch to the image copy   Which two options illustrate the correct sequence of steps that you could follow?()A、 2, 6, 4, 5, 3B、 1, 2, 4, 5, 3, 6C、 1, 2, 4, 6, 3D、 1, 2, 7, 5, 3, 6

考题 Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage?() A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.C、 You can use the SWITCH DATABASE TO COPY Recovery Manager (RMAN) command to switch back to non-ASM disk storage if you have not deleted your original datafiles.D、 You cannot use Recovery Manager (RMAN) to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

考题 多选题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?()Ashut down and restart the instanceBadd new tempfiles to the temporary tablespaces after recoveryCperform a media recovery and open the database with the RESETLOGS optionDperform a media recovery and bring the database to NOARCHIVELOG mode

考题 多选题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()AChange the RMAN archived log deletion policy.BUse the RMAN CROSSCHECK command to reclaim the archived log space.CChange the RMAN retention policy to retain backups for a shorter period of time.DUse OS command to move files from the flash recovery area to some other location.

考题 单选题n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A  Oracle Migration AssistantB  Recovery Manager (RMAN)C  Oracle Data Pump Export and ImportD  conventional Oracle Export and ImportE  operating system utilities to copy the files to the ASM instance

考题 多选题In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance 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 datafile by using the image copy. You could perform the following steps to accomplish this: 1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow?() (Choose two.)A2, 6, 4, 5, 3B1, 2, 4, 5, 3, 6C1, 2, 4, 6, 3D1, 2, 7, 5, 3, 6

考题 单选题Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage?()A  You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.B  You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.C  You can use the SWITCH DATABASE TO COPY Recovery Manager (RMAN) command to switch back to non-ASM disk storage if you have not deleted your original datafiles.D  You cannot use Recovery Manager (RMAN) to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

考题 多选题You 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 space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery?()AChange the RMAN archived log deletion policyBUse the RMAN CROSSCHECK command to reclaim the archived log spaceCChange the RMAN retention policy to retain backups for a shorter period of timeDUse OS command to move files from the flash recovery area to some other location

考题 多选题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.)AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database

考题 多选题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.()AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database