You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）..

第1题

[] 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？（） 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、A. Change the RMAN archived log deletion policy B、B. Use the RMAN CROSSCHECK command to reclaim the archived log space C、C. Change the RMAN retention policy to retain backups for a shorter period of time D、D. Use OS command to move files from the flash recovery area to some other location

点击查看答案

第2题

[] You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task? （） You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11

A、A. A B、B. B C、C. C D、D. D

点击查看答案

第3题

[单选题] Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

A、Perform Export before TSPITR and Import after TSPITR B、Move objects to another schema that has the same tablespace assigned C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN) D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

点击查看答案

第4题

[单选题] Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

A、Perform Export before TSPITR and Import after TSPITR B、Move objects to another schema that has the same tablespace assigned C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN) D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

点击查看答案

第5题

[单选题] You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

A、 user managed complete recovery B、 user managed incomplete recovery C、 RMAN-based complete recovery D、 RMAN-based incomplete recovery

点击查看答案

第6题

[单选题] While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows: 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.（）

A、2，3，5 B、1，2，4 C、1，2，4，5 D、1, 2, 3, 4, 5

点击查看答案

第7题

[单选题] While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows:（） 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.

A、2, 3, 5 B、1, 2, 4 C、1, 2, 4, 5 D、1, 2, 3, 4, 5

点击查看答案

第8题

[单选题] The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）

A、 time-based recovery B、 log sequence recovery C、 cancel-based recovery D、 change-based recovery

点击查看答案

第9题

[单选题] You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

A、 incomplete recovery B、 complete recovery C、 recovery using the Flashback Database feature D、 recovery using the export/import utility

点击查看答案

第10题

[单选题] 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

点击查看答案

You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

请使用微信扫码支付