单项选择题
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()
A.SMON would automatically restore the lost file.
B.You would need to restore the whole database from the last backup.
C.You would need to restore the file from the last full database backup.
D.You would need to use flashback technology to restore the lost redo log member.
E.You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
F.You would need to restore the missing log file by copying one of the remaining files from the same group.
相关考题
-
多项选择题
You decided to increase the value for the SHARED_SERVERS parameter by using the following command: SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=?; Which three values can be specified for the SCOPE clause?()
A.ALL
B.PFILE
C.BOTH
D.NONE
E.SPFILE
F.MEMORY
G.INSTANCE
H.DATABASE -
单项选择题
Youhavethreedatabases,FINDB,PAYDBandADMINDB,locatedinSydney,TokyoandSingaporerespectively.Youwanttoperformadministrativetaskswhichincludestartingupandshuttingdownthedatabases,creatingandmanagingtablespacesanddatabaseusers,andtakingregularbackups,forallofthethreedatabasesfromLondon.Whichcomponentmustbeenabledandrunningoneachhostmachinetoachieveyourobjective?()
A.Oracle Management Agent
B.Enterprise Manager with Grid Control
C.Enterprise Manager with Database Control
D.Operating System Socket for incoming requests
E.Real Application Cluster (RAC) with three instances
F.Enterprise Manager with Generic Database Management -
单项选择题
YouareusingthebackupschedulerinEnterpriseManager(EM)toscheduleabackupofyourdatabase.Whichtypeofscriptdoesthebackupschedulergenerate?()
A.SQL script
B.PL/SQL script
C.Operating System (OS) script
D.Enterprise Manager (EM) script
E.Recovery Manager (RMAN) script
