单项选择题

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.

单项选择题A client server application has been configured to use local naming. The client and server run on separate machines. When the client tries to connect， it receives a TNS error. By carefully examining the environment， a tnsnames.ora is found only on the Oracle server machine， among other things. After copying this tnsnames.ora onto the client machine， the client is able to connect to the server. Which statement is true？（）

A.tnsnames.ora must be on the client machine for local naming.
B.tnsnames.ora must be removed from the server for the connection to work.
C.tnsnames.ora must be on both the client and server machines for local naming.
D.tnsnames.ora is not required for local naming; the problem was not fixed by copying the file to the client.

单项选择题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？（）

A.Only the SET command must be within a RUN block.
B.All commands should be executed at the RMAN prompt.
C.All three commands must be within a single RUN block.
D.Only the RESTORE and RECOVER commands must be within a single RUN block.