A.After a shutdown abort. B.When recovering to an SCN. C.When recovering until a specific time. D.When a required archived log is missing.
单项选择题AfterrunningtheCONFIGURERETENTIONPOLICYTORECOVERYWINDOWOF7DAYScommand,whathasbeenaccomplished?()
A.Retain the data file backup for 7 days. B.Run the recover process every 7 days. C.Destroy the physical backup files every 7 days. D.Destroy the physical backup files older than 7 days. E.Retain one backup of each data file for at least 7 days. F.Keep the catalog information in the control file for 7 days.
单项选择题You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to recover the data files but discover that the archived redo log file with sequence number 45, which is needed to perform complete recovery, is invalid. You then begin incomplete recovery-You receive this prompt: ORA-00279:change 309012...03 09 01 11:33:56 needed for thread ORA-00289: suggestion : disk1 archive arch_45.rdo ORA-00280: change 309012 for thread 1 is in sequence #45 Specify log: {=suggested | filename | AUTO | CANCEL} What is the correct response?()
A.Enter the keyword AUTO. B.Enter the keyword CANCEL. C.Press the Enter or Return key. D.Provide the filename ’/disk1/archive/arcg_46.rdo’
多项选择题WhichtwoRMANcommandsinitiatearesynchronizationoftherecoverycatalogwiththetargetdatabasecontrolfile?()
A.COPY B.BACKUP C.CHANGE D.DELETE E.CATALOG
单项选择题You issue these LSNRCTL commands: LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02 What is the result of issuing these commands?()
A.A listener named LISTENER is started. B.A listener named LISTENER01 is started. C.A listener named LISTENER02 is started. D.The START command fails and no listener is started.
单项选择题ExaminetheRMANcommand:SWITCHDATAFILE’ DISK3 user_data01.dbf’;Whichcommanddoyouneedtoissuebeforeyouissuetheabovecommand,sothatRMANfindsthefileintherestoredlocationof’DISK2 user_data01.dbf’?()
A.RESTORE DATAFILE ’/DISK2/user_data01.dbf’ B.RESTORE DATAFILE ’/DISK3/user_data01.dbf’ C.SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’ D.SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’