单项选择题
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）
A.recover using Oracle Flashback Database technology
B.restore the data files from backup and perform a complete recovery
C.restore only the corrupted data file and perform tablespace recovery
D.restore the data files from backup and perform cancelbased recovery
E.restore the entire database from the most recent backup and start the instance and open the database
相关考题
-
单项选择题
WhichstatementistrueaboutthelossofsystemcriticaldatafilesinARCHIVELOGmode？（）
A.The data files can be recovered till the last committed transaction.
B.The data files can be recovered without shutting down the database.
C.The data file is taken offline automatically; the database remains open.
D.The data files can be recovered to the time of the most recent backup. -
多项选择题
Inyourdatabase，theLogWriter（LGWR）processisunabletowritetoamemberofacurrentredologgroupduetoread/writefailure.Whichtwoeffectswouldyouseeinyourdatabase？（）
A.The database instance aborts.
B.The database operation temporarily halts till the member becomes available.
C.Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D.The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E.The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file. -
多项选择题
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）
A.The instance aborts.
B.The database cannot be recovered.
C.The database can be recovered by restoring the control files from the backup.
D.The database remains opened and you have to shut it down with the ABORT option.
E.The database can be restored till the point of the last closed whole database backup.
