单项选择题
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message：
Which is the recommended sequence of operations you need to perform for the query successfully？（）
A. Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.
B. Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.
C. Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.
D. Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.
相关考题
-
单项选择题
You are managing an ASM instance. You previously issued the following statements： ALTER DISKGROUP dg1 DROP DISK disk2； ALTER DISKGROUP dg1 DROP DISK disk3； ALTER DISKGROUP dg1 DROP DISK disk5； You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue？（）
A. ALTER DISKGROUP dg1 UNDROP disk2，disk3，disk5
B. ALTER DISKGROUP dg1 UNDROP
C. ALTER DISKGROUP dg1 UNDROP DISKS
D. You cannot cancel the pending disk drops -
多项选择题
WhichstatementsabouttheMEMORY_TARGETinitializationparameteraretrue？（）
A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if MEMORY_MAX_TARGET is set to a value greater than zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D. MEMORY_TARGET is static and cannot be modified without shutting down the instance -
单项选择题
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy： CONFIGURE RETENTION POLICY TO REDUNDANCY 3； Which statement is true？（）
A. The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
B. Backup optimization is performed， but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
C. Backup optimization is permanently disabled
D. Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
