Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> More online backup questions

More online backup questions

From: Roy Brokvam <roy.brokvam_at_conax.com>
Date: Wed, 7 Apr 1999 11:38:38 +0200
Message-ID: <1JFO2.71$vy.387@news1.online.no>


Dear Oracle friends,

I think many of the aspects of online backup are poorly documented. Maybe I haven't looked in the right places? Anyway, hopefully, you know the answers to some of my questions.

In Oracle 7.3.4, between ALTER TABLESPACE ... BEGIN BACKUP and ALTER TABLESPACE ... END BACKUP, does DBWR write to the tablespace datafiles? If it does, do you have a not-too-long explanation of how this is handled at recovery? I mean, Oracle can't possibly know which datafiles/parts of a datafile that I have already copied, can it?

The v$backup view reports the backup status of datafiles. Am I right in saying that all datafiles belonging to the same tablespace must have the same status? If so, why does the v$backup view report per datafile, and not per tablespace?

Does the control file contain information about backup status (in particular, the time of backup) of datafiles/tablespaces? If so, should I also backup the control file after partial backups?

Can I delete archived log files after successful online backup of all tablespaces? If so, I guess that the most recent achived log file that I may delete, is the file with sequence number 1 less than oldest online log sequence number before I start the first partial backup?

Grateful for any help.

Regards,

Roy Brokvam
roy.brokvam_at_conax.com Received on Wed Apr 07 1999 - 04:38:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US