Title: Archive files and their Management
Greetings Gurus
Just wondering...
Our archive log's directory has grown substantially and space is becoming an issue.
How do you know which archive files is safe to delete?
In other words...
Do you delete all archive files older than the last
Title: Archive files and their Management
Our policy is to keep archive for the last 2 days
at least.
We are doing daily backup so it gives us the option to
restore from the last backup or the one before
without
restoring archive logs.
Yechiel AdarMehish
- Original Message
Title: Archive files and their Management
theoretically only the archive files after the backup started are needed.
but there might be issues of a corruptedbackup, and to guard against that
we have a policy of keeping archive files for one week.
you
should also keep checking your backups
I do an rman backup of the archivelogs each time I do a backup of the
database. I use the delete option and delete the archivelogs because I can
restore them from the backup.
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October
Title: Archive files and their Management
I'm up
for my backup and recovery class here soon, butthis conversation has
brought up questions
that I think some of you wouldn't mind discussing
anyway. I see
whereimplementing archive logs
requires that youmodify the database startup
procedure
I'm not quite sure what you mean by modify the database startup procedure. You
must be in MOUNT mode to change between archive and noarchive. You don't need to
change the mode each time you startup you database. Once you put a database in
archivelog mode, you are in that mode until you
Title: Archive files and their Management
The
key to the issue is very simple, Redo Logs (including archived) contain
information that cannot be recovered by other means (unless you capture EVERY
statement issued). As such, they are to be protected at all costs. The vast
majority
Title: RE: Archive files and their Management
ok thanks for the info. The following was MISLEADING:
http://www.orafaq.com/faqdbabr.htm
Section: How does one put a database into ARCHIVELOG mode?
To enable ARCHIVELOG mode, simple change your database startup command script, and bounce