Re: tablespaces in backup mode

laredotornado_at_zipmail.com (D. Alvarado) wrote:

>I'm studying for a DBA exam using a book called "Oracle 8i Certified
>Professional DBA Practice Exams" by Jason Couchman. I came upon a
>question that confused me. It is
>
>The DB A has just finished making operating system copies of datafiles
>for backup. Which of the folllowing choices identifies how the DBA
>should complete the backup?
>
>A. Switch online redo logs, back up control file to trace, and take
>tablespaces out of backup mode
>B. Back up control file to trace, switch online redo logs, save backup
>control file and redo logs to tape
>C. Take binary copy of control file, take tablespaces out of backup
>mode, dismount database
>D. Take tablespaces out of backup mode, back up control file to trace,
>switch online redo logs
>
>The experts out there know that the answer is "D" and my question is,
>why do you take tablespaces out of backup mode first? Shouldn't that
>come at the end?
>
>Thanks for any input anyone can provide, - Dave

You take them out of backup mode to update the headers and the control file ( and maybe more cleanup stuff, I haven't looked at the process for a long time)
That's why the 'back up control file to trace' is the next step so you have a copy of the latest version. Received on Wed Mar 17 2004 - 11:51:33 CST