archive logs filling up space
560369Jun 29 2007 — edited Jul 9 2007Hi,
I have oracle10g in linux machine.
when i enabled archivelog mode, after some days i found that the database did not startup bec the archive logs got filledup.
so i disabled the archive logs and did a backup of database using RMAN as follows:
RMAN>backup as backupset database;
Now how can i enable the Archivelog mode and be able to manage the database without getting the archive log files gettign filled up and stopping the database from startingup.
I know i cannot manually delete archivelog files. so how else can i set up such a way that old archive log files get deleted or archived automatically.
Becasue nect time i want to use RMAN to backup both database as well as archive logs.
Can someone guide me.
Thanks,
Philip.