Re: backup
- From: Gus Spier <gus.spier@xxxxxxxxx>
- To: Brian Zelli <Brian.Zelli@xxxxxxxxxxxxxxx>
- Date: Tue, 24 Feb 2015 10:22:50 -0500
Yeesh!
First, is the root cause of this issue embedded in the database backup plan?
Genericly, let's start with a backup strategy centered on Oracle Recovery
Manager (RMAN). Perform a level 0 incremental backup once a week during
periods of lowest database activity.
Perform level 1 incremental backup once a day for every other day of the
week.
All the time from the level 0 backup, backup logs are generated and
archived. If, God forbid, your database suffers catastrophe, you restore
from the level 0 backup, then the latest level 1 backup, then the archived
redo logs, and finally the online redo logs to bring your database back to
the point just before it crashed.
If you manage to survive an entire week without having to restore/recover
your database. You repeat the backup strategy, but, at the end of the new
level 0 backup, you no longer need to keep the archived redo logs on disk.
I recommend that you copy them to "permanent" storage and use the Recovery
Manager software to delete them.
If indeed you are using RMAN, use the CATALOG command to tell the Recovery
Manager where you moved the archivelogs to. Then perform your level 0
backup using BACKUP ... DELETE ALL INPUT
HTH,
Gus
On Tue, Feb 24, 2015 at 9:35 AM, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx>
wrote:
> I had a database that ran out of archive space, so I altered the archive
> location to get it going again.
>
> Now I want to back it up. Do I alter the archive logs back first or back
> it up as is and then alter the archive location
>
> back to where it was after the backup?
>
>
>
> Brian
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
Other related posts:
