Hi
We have the Oracle 11.2.0.3 Database. Initially we used to do the cold backups with a downtime for our production database. To avoid the weekly downtime we shifted the DB to archivelog mode and taking the hot backups now. We have peak usage of the database for 10 to 12 days in a month. Those days we see around 300gb of archive log getting created daily. Most of the content being the DML on the tables which is not required for us. We are ok even if nothing has been recorded. I checked that NO LOGGING does restrict the redo log generation for INSERT operations but not for the other DML operations.
Is there a better way to backup the database with no downtime? If not is there a better way to restrict the redo log generation with Database in Archive log Mode ??
Thanks
Ram