Kevin
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,
Thanks,
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,
-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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>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).
"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).
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you all
Can I ask what additional information you needed before providing an "A" grade?
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.