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.
Explanation:
Without command ALTER SYSTEM SWITCH LOGFILE, the backup of archive redo logs will
be useless.
Database is in noarchivelog mode so this plan not work. The correct answer is E.
@brajmohan is correct, this plan cannot work as it is in NOARCHIVELOG mode.
Answer is E
I agree with E.
E looks correct:
https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmquick.htm
This is how to backup a database in naorchivelog mode:
Backing Up a Database in NOARCHIVELOG Mode
If a database runs in NOARCHIVELOG mode, then the only valid database backup is a consistent backup. For the backup to be consistent, the database must be mounted after a consistent shutdown. No recovery is required after restoring the backup.
To make a consistent database backup:
Start RMAN and connect to a target database.
Shut down the database consistently and then mount it.
For example, enter the following commands to guarantee that the database is in a consistent state for a backup:
RMAN> SHUTDOWN IMMEDIATE;
RMAN> STARTUP FORCE DBA;
RMAN> SHUTDOWN IMMEDIATE;
RMAN> STARTUP MOUNT;
Run the BACKUP DATABASE command.
For example, enter the following command at the RMAN prompt to back up the database to the default backup device:
RMAN> BACKUP DATABASE;
The following variation of the command creates image copy backups of all datafiles in the database:
RMAN> BACKUP AS COPY DATABASE;
Open the database and resume normal operations.
The following command opens the database:
RMAN> ALTER DATABASE OPEN;
B would be correct, if the database were in ARCHIVELOG mode.
As it is in NOARCHIVELOG mode the answer is E.