![]() I would archive all of the log files before beginning the backup and copy those log files to where ever my last successful backup was. They cannot recover the datafile that failed and was being backed up because the backup they were making did not complete AND the backup they had was destroyed. They now have no backups and a media failure!!! They are hosed. only keeps the current backup - overwrites the last backup on the tape drive.ĭisk fails in the middle of the backup. True story: someone is making a hot backup. Therefore, you would need all of the archive - in the event the backup you are making right now fails. ![]() There is a down time due this weekend for 8 hours but I would like to get some advice/guidance from yourself before I try anything.ġ) Well, hopefully you keep at least 2 backups - the current one you are making AND the last successful one you made. The problem is I cannot easily try any new backup procedures on my system as it has gone live and is a 24 hour operation with very occassional down time. ( These take about 20 minutes each to backup). All the archived log files that have accumulated before the start of the backup procedure.Ģ. I would like to know If I can miss out backing up of the following :ġ. Currently the backup takes about 2.5 hours and I feel I am backing up too much data. My application consists of 1 owner/user and relies on all objects from LIVE_DATA and LIVE_INDEX. LIVE_INDEX - Has all indexes for the same owner My database has the following tablespaces : Copy each tablespace in turn by setting tablespace into hot backup mode, copy the tablespace files using unix copy command and then finally releasing the tablespace from backup mode. Ĭurrently I am performing a hot backup every day as follows :ġ. I would like some advice/guidance on a particular matter. I am using the oracle hot backup facilty in ARCHIVELOG mode.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |