47. You are working on an Oracle Database 10g database. Because of da
ta loss, you decided to perform. a Flashback Database operation using
the following command:
SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE ?5/24);
Which two statements are true? (Choose two.)
A. SYSDATE should not be used with TIMESTAMP.
B. The database must have multiplexed redo log files.
C. The database must be in the MOUNT state to execute the command.
D. The database must be opened with the RESETLOGS option after the fl
ashback operation.
E. The entire database needs to be restored from the most recent back
up before the flashback operation.
Answer: C, D
The database must be mounted in exclusive mode to issue the FLASHB
ACK DATABASE command and must be opened with the RESETLOGS option whe
n finished.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-717718/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
