You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）
A、back up the control file to trace
B、bring database to the MOUNT state
C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
相关问题推荐
-
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）
A、 V$DATABASE
B、 V$UNDOSTAT
C、 V$FLASHBACK_DATABASE_LOG
D、 V$FLASHBACK_DATABASE_STAT
-
public class Yippee { public static void main（String [] args） { for（int x = 1； x
A、 No output is produced. 123
B、 No output is produced. 234
C、 No output is produced. 1234
D、 An exception is thrown at runtime. 123
E、 An exception is thrown at runtime. 234
F、 An exception is thrown at rijntime. 1234
-
下列选项中不符合良好程序设计风格的是()。
A．源程序要文档化
B．数据说明的次序要规范化
C．避免滥用goto语句
D．模块设计要保证高耦合、高内聚
-
Your SPFILE contains the following parameter settings： SGA_TARGET = 8G DB_CACHE_SIZE = 4G SHARED_POOL_SIZE = 2G LARGE_POOL_SIZE = 512M JAVA_POOL_SIZE = 512M LOG_BUFFER = 100M SGA_MAX_SIZE = 10G You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement： SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH； What is the result of this statement？（）
A、 The database crashes.
B、 The large pool releases 512M of memory.
C、 The large pool retains 1G of allocated memory.
D、 The large pool increases to 1，512M of memory.
-
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file and all the archived logs are accessible. Which option would you choose？（）
A、 flash back the corrupted blocks
B、 use the DBMS_REPAIR package
C、 use the RMAN TSPITR command
D、 use the RMAN BLOCKRECOVER command
E、 use the RESTORE DATABASE and RECOVER DATABASE commands
F、 investigate the time at which the corruption occurred and perform a point-in-time recovery