单项选择题
Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
A.Shut down the database, restore the two data files and then start up the database.
B.Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online.
C.Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open.
D.Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
相关考题
-
单项选择题
YourcompanydecidedtostartusingRMANinitsbackupstrategy.Previouslyyourcompanyusedoperatingsystemfilecopies.WhichcommandisusedtomakeRMANawareofexistingbackupsmadebycopyingfilesattheoperatingsystem？（）
A.CHANGE
B.RESYNC
C.CATALOG
D.CROSSCHECK -
单项选择题
Theclientconnectedtothedatabaseturnsoffhisorhermachinewithoutexitingfromaconnectiontothedatabase.Whichtypeoffailureisthis？（）
A.media
B.instance
C.statement
D.user process -
单项选择题
You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log？（）
A.LOG_ARCHIVE_DEST was not set in the parameter file.
B.LOG_ARCHIVE_START was not set in the parameter file.
C.alter database archivelog； was not executed in MOUNT mode.
D.LOG_ARCHIVE_MAX processes were not set in the parameter file.
