Q
Problem solve Get help with specific problems with your technologies, process and projects.

Running out of space for backups, archive logs

The Oracle database is growing and the physical disk is out of space. Can I move the archive log folder?

We have an archive folder to hold all the archive logs, also an RMAN folder to hold the backup for the database, control file and archive logs. The DB is growing and the physical disk is out of space. We are running in archive mode. Can I change the archive log folder to another physical disk and with all three backups set by RMAN on other disk? Please advise and what procedures should be done? We have Oracle 9i running on 2003 server. Thanks.
Once you've backed up your archived redo logs, you can remove them. RMAN can do this automatically with the following command:
BACKUP ARCHIVELOG DELETE INPUT 

Your RMAN backup contains the archived redo logs now so they are not needed on disk. This may help you with some of your disk space issues.

You can certainly change your archive log destination. Just change the LOG_ARCHIVE_DEST_n parameter in your instance's parameter file. You can change this on the fly with the ALTER SYSTEM command as well so that the next archived redo logs go to the new location.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close