Controlfile vs. RMAN Catalog
Hey, my controlfile is increasing really fast. So I have to recreate the the controlfile on a regular basis. Its growing nearly 150 MB in one month.
Therefore the backups are getting slow, also a logswitch is impacting my database performance. I am using a physical standby so the db parameter archive_lag_target is set to 600 (sec), so every 10 minutes a logswitch occurs.
v$controlfile_record_section is showing archivelogs are the most space consuming part.
Now the question:
Is it an appriopate way to switch from controlfile to rman catalog ? Will this help me to keep the controlfile tiny ?
Chris