You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as
shown here:
1. Put the tablespaces in backup mode.
2. Back up the datafiles for all tablespaces.
3. Take the tablespaces out of backup mode.
4. Back up all archived redo logs.
Your colleague asks for you to comment on his plan. Which response would be correct?
A.
The plan will work as is.
B.
The plan needs to be modified to allow for an archive-log switch after step 3.
C.
The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
D.
The plan needs to be adjusted to shut down the database after step 1 and to restart the
database after step 2.
E.
The plan cannot work as presented.
The answer should be E. Because the database is in NOARCHIVELOG mode, hot backup is not possible so the plan will not work. If the database was in ARCHIVELOG mode, option B will be correct.
Yes, I agree with you.
Not necessarily. If the command ALTER SYSTEM SWITCH LOGFILE is issued after step 3 before step 4, the backup of archive redo logs won’t go down in vain.
That is if the database is in ARCHIVELOG mode my friend.
Option E is correct for NOARCHIVELOG Database
E is correct.
Yes , E is the correct answer , because the database is in NOARCHIVLOG Mode .