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,
LVL 1
KevinInformation TechnologyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
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.
KevinInformation TechnologyAuthor Commented:
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,
slightwv (䄆 Netminder) Commented:
>>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.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Mark GeerlingsDatabase AdministratorCommented:
The simple answer: yes, it is safe to move these *.arc files.  That will not break anything in production.  However, if you have a disk failure or other problem that would require using these files for recovery, the recovery will not be totally automatic with these files in a different directory now.

The fact that these files exist indicates that at least one Oracle database is (or was) running in archive log mode.
slightwv (䄆 Netminder) Commented:
>>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).
KevinInformation TechnologyAuthor Commented:
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.
slightwv (䄆 Netminder) Commented:
>>After reading more the system appears to be in archive mode.

Makes sense given you have .arc files.

No need to 'read', connect using sqlplus and have the dartabase tell you:
sqlplus / as sysdba
archive log list

>>original location copys can either be manually deleted or automatically deleted

Yes.  We have both said this.  You just need to understand what you are doing.

Another example where they may be needed temporarily before they can safely be deleted/moved:
If you have a Standby database or are using replication.  The recent log files might still be needed.

>> i.e where is the flash recovery

While connected to sqlplus:
show parameter db_recovery_file_dest

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
KevinInformation TechnologyAuthor Commented:
thank you all
slightwv (䄆 Netminder) Commented:
Can I ask what additional information you needed before providing an "A" grade?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.