Implementing ARCHIVELOG - Any ideas?
Scary scenario:
- Production database;
- NOARCHIVELOG;
- Only logical backups;
- "Theoretically" 24x7; cold backups cannot be implemented (one MONTHLY backup MAY be possible);
- No load balancing: all datafiles concentrated on the same RAID5 device
- Disk capacity near the limit;
- No resources or possibility of changing that architecture immediately;
The question is: what is a proper way to force ARCHIVELOG on a scenario like that? some considerations I already made:
- Archiving to a remote server is a bit dangerous; a network failure might impact database activity; anyway, even with no failures network bandwidth should be severely affected.
- Maybe ARCHIVELOG could be implemented on the local disk with an automatic routine to clear archives. However, it would be an extra write activity on a RAID5 device busy enough. It might potentially affect performance.
Any different and creative approaches to workaround that without hardware interventions? :confused:
Re: Implementing ARCHIVELOG - Any ideas?
Quote:
Originally posted by adrianomp
- Only logical backups;
I won't even touch that one...