1Z0-052 · Question #102
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.)
The correct answer is C. You can perform complete database backups without closing the database. D. All the previous closed database backups including control files become invalid afteryou configure. Running Oracle in ARCHIVELOG mode enables online (hot) backups and requires taking a new backup after the mode switch because prior NOARCHIVELOG backups cannot support complete media recovery.
Question
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.)
Options
- AYou must shut down the database instance to perform the backups.
- BYou must configure the Flash Recovery Area (FRA) for the database.
- CYou can perform complete database backups without closing the database.
- DAll the previous closed database backups including control files become invalid afteryou configure
How the community answered
(51 responses)- A4% (2)
- B4% (2)
- C92% (47)
Why each option
Running Oracle in ARCHIVELOG mode enables online (hot) backups and requires taking a new backup after the mode switch because prior NOARCHIVELOG backups cannot support complete media recovery.
Shutting down the database is required only in NOARCHIVELOG mode; ARCHIVELOG mode exists specifically to enable online backups without downtime.
The Flash Recovery Area is optional, not mandatory; archived logs can be directed to any valid OS path using the LOG_ARCHIVE_DEST_n parameters without configuring an FRA.
ARCHIVELOG mode allows the database to remain open and fully operational during a backup because redo logs are archived, providing the before/after images needed to make a hot backup consistent upon restore.
Backups taken while the database was in NOARCHIVELOG mode lack the corresponding archived redo logs required for media recovery; after switching to ARCHIVELOG mode, those old backups cannot be used for a full, consistent recovery and are effectively invalid.
Concept tested: ARCHIVELOG mode backup capabilities and implications
Source: https://docs.oracle.com/cd/E11882_01/backup.112/e10642/archredo.htm
Topics
Community Discussion
No community discussion yet for this question.