Which response would be correct?

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?

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Prakash

Prakash

In noarchivelog, how can you switch logfiles? silly.

Cương Thi Tiên Sinh

Cương Thi Tiên Sinh

I think E is the best option.