You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?（）A、A base catalog existsB、The r

题目

You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?（）

  • A、A base catalog exists
  • B、The recovery catalog is empty
  • C、The base recovery catalog must be dropped
  • D、A target database is registered in the recovery catalog
相似考题

1.You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）A、RCO1 only.B、DB01 only.C、DB02 only.D、DB01 and DB02 only.E、DB01，DB02，and RC01.

2.You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）A、 SQL scriptsB、 Recovery Manager （RMAN） scriptC、 Data PumpD、 SQL*LoaderE、 Flashback database

3.You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）A、 take data files from the read-only tablespace offline before performing a recoveryB、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery； status of the tablespace in control file will be changed automatically

4. You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.A、4，1，5，6，3，2B、4，3，1，5，6，2C、4，5，1，3，2，6D、5，4，1，3，2，6E、5，4，1，3，6，2

更多“You want to create the Recovery ”相关问题

  • 第1题：

    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

    • A、 ONLINE
    • B、 REVERSE
    • C、 PARALLEL
    • D、 COMPRESS
    • E、 NOLOGGING
    • F、 COMPUTE STATISTICS

    正确答案:C,E

  • 第2题：

    You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）

    • A、Start the instance and open the database, instance recovery automatically recovers control files 
    • B、Create a file based on the contents of the trace file and save it to the control file locations and start the database 
    • C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 
    • D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 
    • E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

    正确答案:D

  • 第3题：

    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

    • A、 You will need to open the database with the resetlogs command.
    • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
    • C、 You will use the resetlogs version of the create controlfile command.
    • D、 You will use the noresetlogs version of the create controlfile command.
    • E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

    正确答案:D

  • 第4题：

    You need to ensure that you can recover system configuration and data if your computer hard disk fails.  What should you do？ （）

    • A、Create a system restore point.
    • B、Create a backup of all file categories.
    • C、Create a Complete PC Backup and Restore image.
    • D、Perform an Automated System Recovery （ASR） backup.

    正确答案:C

  • 第5题：

    单选题
    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)


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

  • 第6题：

    单选题
    You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）
    A

     take data files from the read-only tablespace offline before performing a recovery

    B

     recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

    C

     drop the read-only tablespace and re-create the tablespace after recovery

    D

     perform a recovery； status of the tablespace in control file will be changed automatically


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

  • 第7题：

    多选题
    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）
    A

    ONLINE

    B

    REVERSE

    C

    PARALLEL

    D

    COMPRESS

    E

    NOLOGGING

    F

    COMPUTE STATISTICS


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

  • 第8题：

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


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

  • 第9题：

    单选题
    You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?（）
    A

    A base catalog exists

    B

    The recovery catalog is empty

    C

    The base recovery catalog must be dropped

    D

    A target database is registered in the recovery catalog


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

  • 第10题：

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


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

  • 第11题：

    单选题
    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）
    A

     You will need to open the database with the resetlogs command.

    B

     All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

    C

     You will use the resetlogs version of the create controlfile command.

    D

     You will use the noresetlogs version of the create controlfile command.

    E

     You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command


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

  • 第12题：

    单选题
    You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）
    A

    RCO1 only.

    B

    DB01 only.

    C

    DB02 only.

    D

    DB01 and DB02 only.

    E

    DB01，DB02，and RC01.


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

  • 第13题：

    You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）

    • A、 DB_CREATE_FILE_DEST
    • B、 DB_RECOVERY_FILE_DEST
    • C、 DB_RECOVERY_FILE_DEST_SIZE
    • D、 DB_ONLINE_LOG_DEST_n

    正确答案:B,C

  • 第14题：

    Which command do you use to create a recovery-catalog schema? （）

    • A、create recovery catalog 
    • B、create catalog
    • C、build catalog 
    • D、catalog create 
    • E、mount catalog 

    正确答案:B

  • 第15题：

    You are the Exchange administrator of the Xxx Corporation’s Exchange 2010 organization.You need to retrieve all messages from Ann’s mailbox that have the word "classified" in the message body and the subject of "New Project." The message may be either in the Calendar or Inbox folders. What should you do？（）

    • A、Use the Exchange Management Console to create a recovery storage group
    • B、Use the Exchange Management Shell to create a recovery storage group
    • C、Use the Exchange Management Console to create a recovery database
    • D、Use the Exchange Management Shell to create a recovery database
    • E、Use the Restore-Mailbox cmdlet to restore only messages that the word "classified" in the message body and the subject of "New Project"
    • F、Use the Export-Message cmdlet to restore only messages that the word "classified" in the message body and the subject of "New Project"

    正确答案:D,E

  • 第16题：

    单选题
    You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository.  Which condition must be met before you create the VPC？（）
    A

     A base catalog exists

    B

     The recovery catalog is empty

    C

     The base recovery catalog must be dropped

    D

     A target database is registered in the recovery catalog


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

  • 第17题：

    多选题
    You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）
    A

    DB_CREATE_FILE_DEST

    B

    DB_RECOVERY_FILE_DEST

    C

    DB_RECOVERY_FILE_DEST_SIZE

    D

    DB_ONLINE_LOG_DEST_n


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

  • 第18题：

    单选题
    Which command do you use to create a recovery-catalog schema? （）
    A

    create recovery catalog 

    B

    create catalog

    C

    build catalog 

    D

    catalog create 

    E

    mount catalog 


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

  • 第19题：

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

  • 第20题：

    单选题
    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’；


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

  • 第21题：

    单选题
    In what order would you execute the following steps to create a recovery catalog？（） a.Issue the create catalog command.  b.Create the recovery-catalog database.  c.Create the recovery-catalog user.  d.Grant the recovery_catalog_owner privilege to the recovery-catalog user.  e.Issue the register database command from the target database.
    A

    a，b，c，d，e

    B

    b，a，d，c，e

    C

    b，c，d，a，e

    D

    b，c，d，e，a

    E

    b，d，c，a，e


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

  • 第22题：

    单选题
    You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.
    A

    4，1，5，6，3，2

    B

    4，3，1，5，6，2

    C

    4，5，1，3，2，6

    D

    5，4，1，3，2，6

    E

    5，4，1，3，6，2


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

  • 第23题：

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

相关内容