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
相关问题推荐
-
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
-
You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday, you issued the following commands: CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE RETENTION POLICY TO REDUNDANCY 3; From Monday to Saturday, you performed the following actions: Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed?()
A、 The backup will not be performed at all.
B、 three times
C、 four times
D、 six times
-
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently, the warning threshold for the tablespace space usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool, you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do?()
A、disable SQL tracing for theAPPS tablespace
B、disable logging attribute for the APPS tablespace
C、modify the tablespace to be a dictionarymanaged tablespace
D、increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace
E、increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace
-
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
-
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.