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.)
A.
You must shut down the database instance to perform the backups.
B.
You must configure the Flash Recovery Area (FRA) for the database.
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 the database to ARCHIVELOG mode.
Maybe it’s true with RMAN backups, but a manual cold backup can’t be invalidated.
When you configure database in ARCHIVELOG then:
– the datbase is only recoverable from the last backup taken in that mode, so previous backups are “invalid”
– with the database in NOARCHIVELOG mode, recovery is possible only until the time of the last backup.
-in ARCHIVELOG mode, recovery is possible until the time of the last commit.
(based on the Oracle Database 11g: Administration Workshop)
How are they Invalid? you can take the last offline backup and restore it.However, you wouldn’t be able to roll it forward with the archivelogs, but you weren’t able to prior to enabling archiving anyway. I don’t get it. The validity of the cold backups are no different whether archiving is enabled or it’s not. Maybe I’m miss understanding something here.
In D is about ‘closed database backup including control files” made before configuring ARCHIVELOG mode .
Anyway, after you configure database in ARCHIVELOG there is a change in the archive process, log format and log destination, control file (structural changes made to the database affect control file if database is running in ARCHIVELOG mode).
However you can use such backup to recover the database to the state from before configuring ARCHIVELOG mode.
And from the training book “11g Administration Workshop II”:
“Back up your database after switching to ARCHIVELOG mode because your database is recoverable only from the first backup taken in that mode”.
Isn’t Choice B true?
“You must configure the Flash Recovery Area (FRA) for the database.”
I thought archivelog doesn’t work without FRA configured.
No, it is not necessary but you need to specify location for storing archive logs.
The destination should exist before placing database in ARCHIVELOG mode.
One of the destinations can be fast recovery area.
D is not a good choice but the only choice besides C, from the training book, all the backups become “invalid” after you configure to ARCHIVELOG mode, but the fact is if I want, I really can recover with that “invalid” backups. C,D correct, but not accurate.