QUESTION
NO: 43
Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
A. Database must be running in archivelog mode.
B. Automatic undo management must be enabled.
C. Undo retention guarantee must be enabled.
D. The tablespace on which the Flashback Data Archive is created must be
managed with
Automatic Segment Space Management (ASSM).
Answer: B,D
Explanation:
Flashback Data Archive Requirements
1. Flashback Data Archive tablespaces must be managed with automatic segment
space management (ASSM).
2. Automatic Undo Management must be enabled.
There are a number of restrictions for flashback archives:
- The tablespaces used for a flashback archive must use local management and automatic
segment space management.
- The database must use automatic undo management.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29555029/viewspace-1612587/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- oracle.1z0-053: RMAN provides more granular catalog security
- oracle.1z0-053: RMAN recovery catalog
- oracle.1z0-053: alter database clear logfile
- oracle.1z0-053: backup plan for his NOARCHIVELOG mode database
- oracle.1z0-053: DB_BLOCK_CHECKING
- oracle.1z0-053:ASM_POWER_LIMIT
- oracle.1z0-053:cancel all pending drops of disks within disk groups
- oracle.1z0-053: RESULT_CACHE_MODE
- oracle.1z0-053: ASM metadata backup
- oracle.1z0-053:Health Monitor checks
