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

相关问题推荐

• What are the two advantages of RMAN Block Media Recovery （BMR） over file/x7flevel recovery？（）

  A

  BMR lowers the mean time to recover （MTTR）.

  B

  BMR supports point­in­time recovery of individual data blocks.

  C

  BMR enables you to use incremental backups for block recovery.

  D

  BMR enables recovery even when the database is not mounted or open.

  E

  BMR enables you to use proxy backups to perform block media recovery.

  F

  BMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.

  查看答案

• You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）

  A、 Index cluster

  B、 Hash cluster

  C、 Sorted Hash cluster

  D、 Real Application Cluster

  查看答案

• Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）

  A

  The database opens normally.

  B

  The database prompts for a database recovery.

  C

  The database writer writes to a trace file， indicating that the temporary file is not found.

  D

  The database gets mounted and throws an error indicating that the temporary file requires recovery.

  查看答案

• View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

  A

   all the data files belonging to the USERS tablespace

  B

   password file

  C

   online redo log files

  D

   the current control file

  E

   archived redo log files

  F

   the current server parameter file

  G

   data files belonging to the USERS tablespace and all the default tablespaces

  查看答案

• You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }

  A、 NOMOUNT

  B、 MOUNT

  C、 OPEN

  D、 RESTRICTED

  查看答案