Link to home
Start Free TrialLog in
Avatar of Kevin
KevinFlag for United States of America

asked on

Is it safe to move .arc archive files to another location to free up space?

The directory where the archive files are stored has gotten very large. We are in No Archive Log Mode but before we consider the option of switching to Archive Log Mode I need to at least free up some space in the mean time. I have additional space on other directories would I be able to move at least 1month of files do bring the size down in the interim?
Thanks,
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

If you are in no archive log mode, what is generating the files?

Normally archived redo log files are safe to move as long as you realize the possible issues.

You can also compress them but you'll have the same concerns as moving them.

For example:
If you are backing up using RMAN, RMAN keeps track of what is supposed to be where.  If you move files RMAN no longer knows where they are.
Avatar of Kevin

ASKER

In the directory there seems to be at least three months of files dating back from March totaling about 16GB. The person who I am assisting isn't sure how these files were cleaned up in the past as the main DB Admin is out ill.

-rw-r-----   1 oracle   oracle   2096640 Mar 26 20:52 arch_1_234419.arc

Is there a way to confirm if RMAN is actually be used? Additionally are you saying that because these files are actually being generated that RMAN is indeed in use?

Also to the original question is it safe to move some of those files to another location in the mean time to free up space?

Right now the directory is 98% full and I am trying to avoid the system locking up.

thanks,
>>Is there a way to confirm if RMAN is actually be used?

There are a lot of RMAN views.

I would start off with:
select * from V$RMAN_BACKUP_JOB_DETAILS;

All the views are listed here:
https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcviews001.htm

That is a 10g doc but the views are the same.


>> Additionally are you saying that because these files are actually being generated that RMAN is indeed in use?

Not saying that.  I'm saying that it is likely that some database is running in archive log mode.

>>is it safe to move some of those files to another location in the mean time to free up space?

I already answered that:  Yes as long as you are aware of the ramifications.  Before you ask:  No, I cannot tell you all the possible ramifications.
SOLUTION
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>That will not break anything in production.

"break", no.  Confuse, possibly.

If RMAN is being used and it cleans up obsolete files, it will need some manual intervention if the files are manually moved around or compressed (which would change the name).
Avatar of Kevin

ASKER

After reading more the system appears to be in archive mode. however from what I was reading the original location copys can either be manually deleted or automatically deleted. I am looking for the unix commands to show me more details on the rman process. i.e where is the flash recovery, copy rate etc. so I can understand the structure of this process.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kevin

ASKER

thank you all
Can I ask what additional information you needed before providing an "A" grade?