Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with lost archive logs
tsteege_at_gmail.com wrote:
> On Aug 30, 1:34 pm, "tste..._at_gmail.com" <tste..._at_gmail.com> wrote:
> > Sorry I forgot to mention that the servers backup had not been running > for a while, and I can not recover the logs. Can I force Oracle to > think a backup has been done and then start my backup running nightly? > > Thanks again. >
How are you backing up your Oracle database? Are you just using Backup Exec? If so, then your backups are inconsistent and may not be usable for recovery. Have you tested recovery from these backups before? Backups are useless unless you can recover using them.
I would recommend implementing RMAN to do your backup to disk. Then have Backup Exec backup up the backup.
When you do a full backup of the Oracle database, you no longer need the archived redo logs generated before that backup. So you can remove them. RMAN can also be used to backup the archived redo logs and to delete them after they have been backed up.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown -- Posted via a free Usenet account from http://www.teranews.comReceived on Thu Aug 30 2007 - 14:55:03 CDT